DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2010
    Central WV, USA

    Null String Problem

    I have a string that is loaded from a collection that is inturn loaded from a fixed length file. Sometimes the string is null, and when I use an IF statement to test this condition I get unexpected results. In the file, the string exists as a field of 15 spaces, sometimes blank sometimes not. When loading into my collection I use the trim() function to remove the spaces (or atleast I thought).

    Here's the weird part, when I reference (display the value) of the string it will show a null value "". But if I use the Len() function, it returns a 15. and blows right through my IF statement when testing for null. I've even tried assigning it out to another var, and it tests the same way.

                    If Trim(WlNum) = "" Then
                        WlNum = "(None)"
                        WlNum = item.WellNum
                    End If
    Even when WlNum is = "" it blows right through to ELSE.

  2. #2
    Join Date
    Apr 2007
    Sterling Heights, Michigan
    A space is a valid character. Therefore, if something contains a space, it is not null. Regardless of what it "looks" like to you, the computer sees a valid, non null, character. Try this
                    If WlNum = Space(15) Or WlNum = String.Empty Then
                        WlNum = "(None)"
                        WlNum = item.WellNum
                    End If
    Last edited by Hack; 04-14-2010 at 08:16 AM.

  3. #3
    Join Date
    Feb 2010
    Central WV, USA
    Thanks for your solution, but why does a trim statement remove spaces that are surrounding a string but does not nullify a string that only contains spaces?


    It's still blowing through, even Hack's version doesn't make it work, something strange is going on and I'm not sure what it is. I'll keep you all updated.
    I've even moved the code to the Class Property and used it as a validator, still no results.

    With NewMG
       .WellNum = InputLine.Substring(112, 15)     
    End With
    ' From Immediate Win
    ? Len(NewMG.WellNum)
    ? NewMG.WellNum
    It appears that a "" with a len of 15 comes right out of the file, and no matter how I try to trap the null, I'm unsuccessful.

    Is it a function of not writing a null to this particular file type that's giving me my problem, I guess I could write a routine that puts values in those file fields but It probably would not detect the nulls either. I probably could use the len() to locate the nulls, but at this point i'm amazed that none of the above works, and I'd really love to know why?
    Last edited by rrjii2000; 04-14-2010 at 02:04 PM.

  4. #4
    Join Date
    Feb 2010
    Central WV, USA
    I think the problem has stemed from an earlier file type. This file used to be a random access file and was converted to a filestream. I think somewhere along the line, something happened to the null fields. So today I'm going to loop through the file and rewrite all the null fields. The following code is the only thing I've found that will trap the nulls.

     Public Property WellNum() As String
                Return _WellNum
            End Get
            Set(ByVal value As String)
                If Len(value) = 15 Or Len(value) = 0 Then
                    value = "(None)"
                End If
                _WellNum = value
            End Set
        End Property
    To solve this problem I loaded the suspect fields into a datagrid, at that point the null fileds displayed as "IIIIIIIII" (not I's, but a cluster of small vertical lines) It resembled a mini barcode. All null fields displayed these characters and at that point I knew what needed fixed.
    Last edited by rrjii2000; 04-15-2010 at 12:56 PM.

  5. #5
    Join Date
    Feb 2004
    Longueuil, Québec
    If you get strange characters in the grid, it means that the string contains non displayable characters, such as 8, which is a Basckspace.

    Some applications display those characters as bars (the Grid), others as little squares, other disregard them (the debugger). Trim does not remove them because they could be used for some purpose or to display special characters in particular environments.

    Those caracters could have appeared there for many reasons. Two common ones is data imported from a mainframe or from a file in another language than English. These sometimes do not use the standard ASCII (search the Internet for "ASCII code page" if you are curious), and some caracters are not translated correctly when converted to Unicode, which is the standard used in modern systems, including Windows and .NET.

    You might want to trap one of those "null" fields and see what you get as the first character with Asc(yourString.Substring(0, 1)). Assuming that all your nulls are the same format, you could thus identify them through the ASCII value of their first character.

    Try not to use nulls in any of your work. They often lead to strange problems. An empty string is as valid as a marker as a null, and usually does not bring those conflicts.
    Jacques Bourgeois

  6. #6
    Join Date
    Jan 2013
    Thanks, I met similar problem in my java bar code and it is solved now. Now I would not consider space as null.

Similar Threads

  1. Replies: 0
    Last Post: 09-19-2005, 03:39 AM
  2. Getting a large number of identities
    By Colin McGuigan in forum Database
    Replies: 12
    Last Post: 04-15-2002, 07:43 AM
  3. Writing in HKEY_LOCAL_MACHINE...Access is denied
    By Martin in forum VB Classic
    Replies: 22
    Last Post: 12-03-2001, 03:53 AM
  4. FOR XML Explicit clause in SQL Server 2000
    By reddy in forum Database
    Replies: 1
    Last Post: 06-06-2001, 04:38 PM
  5. Multi-row calculations
    By Bob Hines in forum Database
    Replies: 7
    Last Post: 04-27-2000, 11:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.