Remove Carriage returns in field

[RodM]

I suppose something like this might work

but my chr13 is wrong...

I trying to remove those phantom returns in a text field

Substitute ( g_pass_verify ; chr(13) ; "" )

[Lee Smith]

Why not use the actual character for this?

I just capture one out of a text editor, and use that in the searchString.

Lee

Edited February 12, 2010 by Guest
misread the question

[fmdevusa]

Depending on original source of text it could be a line feed Chr ( 10 )

e.g. Substitute ( text ; [ Chr ( 10 ) ; "" ] ; [ Chr ( 13 ) ; "" ] )

You might try look at the actual content using the following cf which shows each characters asc code in list form:

// codeList ( text )

Let ( [ byte = Left ( text ; 1 ) ;

result = Code ( byte ) & "¶" ;

LR = Length( result ) ;

N = Length ( text ) ];

result &

Case( N > 1 ; codeList ( Right ( text ; N -1 ) ) )

)

[RodM]

Thanks...