Null character in imported strings

[CharlesR]

I have imported a series of strings from an Excel spreadsheet as text files and I can see spaces in the string. Where these are genuine spaces, for example between two names in one cell, I have no problem manipulating them, but there are also null characters where the data is shorter than the width of the Excel cell. I know that I can trim these out but what should I search the B4A string for if I want to process them for instance to determine the start of the next cell?

Many thanks

Charles

 

[Erel]

What do you mean with null characters? Can you upload the text file?

 

[CharlesR]

Attached are the first 4 lines of the file which has 300+ entries

 

[agraham]

There are no null characters in that file. The field data is separated by a Tab character, Chr(9), so the fields align vertically when displayed.

 

[CharlesR]

Thank you for your help. I can now see that is the case between the first and second fields, but is it also the case between the second and third fields?

 

[agraham]

Surely you can establish that for yourself :sign0137:
Suck it and see or use a Hex Editor to look at the file or write a loop that logs the Asc(char)values to the Log or show them in a Msgbox.

 

[CharlesR]

Surely you can establish that for yourself :sign0137:
Suck it and see or use a Hex Editor to look at the file or write a loop that logs the Asc(char)values to the Log or show them in a Msgbox.

Thank you for that. I have already developed a work around, I was just curious to see if anyone else had a simple solution.

Charles