Strip Punctuation Marks

[bmorse]

How can i strip out punctuation marks from a field that i am calling in a writeline command? There is a comma in the name (vendor name) and it throws off my import into my accounting program. Thanks for your help.

 

[namliam]

Instead of stripping the comma, try to make sure you wrap text fields in "" or change the column delimiter...

 

[bmorse]

Thanks. I can't change the delimiter. I ended up using the left and instr command to take out the comma. thanks for your help!

 

[DennisOJensen]

Why did you not just use the MS Access VBA String Function Replace ??

Replace ( string1, find, replacement )

string1 : The string to replace a sequence of characters with another set of characters.

find : The string that will be searched for in string1.

replacement : The string to replace find in string1

 

[bmorse]

I get a compile error when i use the function replace. i am sure i am missing a reference. this is a database that someone else wrote and i have to make some export work. its only going to be used temporarily for testing. thank you for the info tho!