Special Characters

[naren6876]

Hi,

My Input file has some special characters. I have used the HEX editor to find out them and they are (OD OA pairs) and HEX (00).

I want to replace them with the spaces.

I have gone thru the forum and found some solutions like

1). EReplace and Iconv with MCP

2). EReplace( string,char(13):char(10)," ")

3) Convert function.

Please let me know which one would be the best solution.

Any input would be highly appreciated.

[chulett]

"0D 0A" are DOS record delimiters - CR/LF pairs. Use #2 for that and #3 for the hex zeroes.

[ray.wurlod]

Make the record delimiter "DOS format" might work. Or are the 0D0A pairs within quoted strings?

Otherwise, to convert the NUL characters to space, define a stage variable svNUL initialized to Char(0) then:

Code: Select all

Convert(svNUL, " ", InLink.TheColumn)

To replace the CRLF pairs, define a stage variable svCRLF initialized to Char(13):Char(10) then:

Code: Select all

Ereplace(InLink.TheField, svCRLF, " ", -1, 0)