Results 1 to 4 of 4
July 27th, 2007, 11:55 AM #1Removing special characters
I'm working with a Access DB I'm trying to remove <br> from a text field.
The problem is I don't see them in Access only when I export to CSV I see a little square box.
I need to update in Access how can I fix this or any other special characters at the same time.
July 28th, 2007, 05:38 AM #2
- Join Date
- June 18th, 2006
- The Call is coming from Inside the House!
Look in AMWSO.com they have a cleaner that is on the left nav I believe. It is very useful.
O and its totally free. Thanks AMWSO
September 24th, 2007, 06:56 PM #3
- Join Date
- September 10th, 2005
September 25th, 2007, 07:27 AM #4
If it is in Visual Basic you might try vbCr. Or in a search ^p or /n or /r or \n or \r (I rarely remember which way the slash is supposed to go.). Another option is to paste the string into word, select the line ending and hit find, usually it will transpose to Microsoft formatting in the find box.
By superCool in forum Blogging, Mobile and Social MediaReplies: 3Last Post: March 12th, 2010, 01:58 PM
By Trust in forum Rakuten LinkShare - LSReplies: 0Last Post: July 5th, 2007, 12:40 PM
By popdawg in forum Programming / Datafeeds / ToolsReplies: 2Last Post: October 8th, 2006, 12:05 PM
By dogdecor in forum ShareASale - SASReplies: 2Last Post: April 5th, 2006, 08:34 AM
By Heyder in forum Programming / Datafeeds / ToolsReplies: 5Last Post: February 27th, 2004, 07:00 AM