Odd Characters Imported

[RedHeadedMonster]

I uploaded quite a bit of data from an extensive list of Word Documents.
In some of the Memo fields, it imported these weird Squares. Some times at Tabs or Paragraph returns.

Is there an Easy way to remove these things?

Thanx!
RHM

 

[pr2-eugin]

Hello RedHeadedMonster, what are the wired symbols? ¶ ? or something else.. Try to find either the ASCII Value of it or copy the Symbol and use a Replace function..

? Replace("The world is full of Evil¶, I really ¶ Really cannot stand it","¶","")
The world is full of Evil, I really  Really cannot stand it
? Replace("The world is full of Evil¶, I really ¶ Really cannot stand it",Chr(182),"")
The world is full of Evil, I really  Really cannot stand it