How to replace comma in a field

[GFAlexander]

This is going to sound really lame, but can someone tell me how to replace a field with the same fields minus any commas?

Example.
Description Field = "Costume, Mens, Large"

I want it to be "Costume Mens Large"

I know it's going to be really simple, but please help.

Thanx

Gary Alexander

 

[Germancho]

Try this

YourString = STRTRAN(YoursSring, ',')

Germán Restrepo
Bogotá, Colombia

 

[Germancho]

I mean

YourString = STRTRAN(YourString, ',')

Best regards

Germán Restrepo
Bogotá, Colombia

 

[alvechurchdata]

I mean

YourString = STRTRAN(YourString, ',')

Or seeing as it's a field in the original post:

[tt] Replace YourField With StrTran(YourString, ',')[/tt]

Thinking a bit more deeply, can you guarantee that there will always be a comma plus a space between words. Will you ever have to deal with entries without spaces: "Costume,Mens,Large"

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[GFAlexander]

Thanx German.

That worked just fine.

Gary