I am working with an existing MS SQL database that stores all the data submitted from a form into a single field:
(text output from the database)
SARtech Technologies Ltd
39 Pinegrove Crescent
As you can see, the from fields are delimited in the database field using: |¬°
I wish to retrieve this information from the database and redisplay it.
Data = Split(RS("submissiondata"), "|¬°")
This was leaving some extra characters in the array elements though that could not be removed using trim. I guessed that there might have been a carriage return in there and so I changed the array to
Data = Split(RS("submissiondata"),"|¬°" &vbcrlf)
This removed 2 of the extra characters but there are still 2 extra characters left. I tried:
Split(RS("submissiondata"), vbcrlf &"|¬°" &vbcrlf) and
Split(RS("submissiondata"), "|¬°" &vbcrlf &vbcrlf)
These both returned only a single array element.
Any idea what other characters could be occupying these two spaces. I verified that there are still two hidden characters by using Len(Data(i)). I would like to get ride of these hidden character so that I can use a conditional statement such as
If Data(i) = "" then ...
I know that I could always use
If Len(Data(i)) <> 2 then ...
but it bugs me not to be able to sort it out.