SUBSTITUTE hex chr with other ...

[sal21]

I loop a txt file with the tipical

free file...#1 ecc....

in the string are hex cahrcter 00 (see image).

Is possible to intecept in the string and replace with space chr?

tks.

[HansV]

Say you have a variable MyString that you use to read data from the file. You can then use

MyString = Replace(MyString, Chr(0), " ")

[sal21]

Say you have a variable MyString that you use to read data from the file. You can then use

MyString = Replace(MyString, Chr(0), " ")

hummmm...

the image is refered to a Hex editor, not is the line in question

in my case 20 is a space and the . is 00 all both character in Hex

[HansV]

How do you read the line?

[sal21]

How do you read the line?

for test i use a Hex editor....

[HansV]

Yes, I understand, but how do you read the line in VBA?

[sal21]

Yes, I understand, but how do you read the line in VBA?

sorry me....

yes in vba for excel for first test and in official project with vb6 classic.

[HansV]

Please, can you show us the bit of code that you use to read the string?

[sal21]

Please, can you show us the bit of code that you use to read the string?

Sub LEGGI()

Dim sFileText As String
Dim iFileNo As Integer

iFileNo = FreeFile
Open "C:\TEMP\mytestfile.txt" For Input As #iFileNo
Do While Not EOF(iFileNo)
Input #iFileNo, sFileText
Loop
Close #iFileNo

End Sub

[HansV]

Sal, the text file that you sent me doesn't contain Chr(0) (except for the very last character):

S008.png