removing return

[huntert]

I have alittle problem I cant figure out. I am trying to remove a blank line in front and/or after of a string or memo field. I can easily identify if there is a blank line with looking at CHR(13) but I can seem to remove this from the string. Any help would be appreciated. thanks in advance. hunter

 

[JimWWinter]

REPLACE YourFldName WITH STRTRAN(YourFldName,CHR(13),'')

Bear in mind though that you probably also need to get rid of CHR(10) so the following might be more what you need.

REPLACE YourFldName WITH STRTRAN(YourFldName,CHR(13)+CHR(10),'')

Regards,
Jim

 

[huntert]

Thanks. Forgeting the CHR(10) was the issue for me. I add STRTRAN(YourFldName,CHR(13)+CHR(10),'',1,1) the '1,1' to take just the first occurance away. hunter