remove spaces in text field

LarsHenning · January 9, 2004, 1:38pm

I want to remove all spaces in a text field. 00 11 22 33 should be 00112233. I have tried the DELCHR in a report, but nothing happens. This is a clean-up job just this one time, nothing permanent… Anyone ?? [:D]

iammicky · January 9, 2004, 1:56pm

Give a little bit more of your code

anfinnur · January 9, 2004, 2:10pm

Var := ‘00 11 22 33’; Var := DELCHR(Var,’<>=’); //result: ‘00112233’

Nelson · January 9, 2004, 2:43pm

Did you do Rec.MODIFY? You need: OnAfterGetRecord() "Text Field" := DELCHR("Text Field"); MODIFY;

David_Singleton · January 9, 2004, 6:40pm

try Var := '00 11 22 33'; Var := DELCHR(Var); //result: '00112233'

LarsHenning · January 12, 2004, 9:58am

Thanks a lot !! DELCHR(Var,’<>=’); did it !! I guess I just messed up with the <>= Thanks again! [:)]