February 12, 201015 yr 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) ; "" )
February 12, 201015 yr 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, 201015 yr by Guest misread the question
February 12, 201015 yr 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 ) ) ) )
Create an account or sign in to comment