Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remove commas from a text field

Status
Not open for further replies.

cbayles

IS-IT--Management
Nov 18, 2003
11
US
I'm writing a report that exports invoices to a comma delimited file. I would like to know how I can remove commas and from an item description field and replace them with spaces so it doesn't mess with the file formatting.

Any help would be greatly appreciated!
 
replace({table.field},","," ")

Reebo
UK

"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."
- Albert Einstein (1879-1955)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top