character conversions (OpenInsight 32-bit)
At 30 JUN 2022 04:23:09PM Mike ONeal wrote:
Hello folks - We have a site that for years has pasted data into AREV and OI from various versions of Word. Current environment is OI 9.4.4, ANSII. (I can't get them to UTF-8 just yet.)
They have pasted something like this:
“living fossil”
When saved and retrieved in an entry window it displays like this:
living fossil
When exported into NotePad or Excel it displays like this:
“living fossil”
So I need to convert “ to " but I can't quite hit on the correct CHAR code(s) to locate the data within OI so that I can convert it. Any suggestions welcome.
Thanks much,
Mike O.
At 30 JUN 2022 05:53PM Andrew McAuley wrote:
World leaders in all things RevSoft
At 30 JUN 2022 07:10PM Mike ONeal wrote:
Geez, I guess not! Thanks for posting Andrew. Mike
At 01 JUL 2022 10:35AM Bruce Cameron wrote:
We have the same problem with users copying and pasting from Word.
Can try this or a variation of…
Function ClearCtrlChars(StringIn) * Create an array of ASCII characters outside of regular keyboard entries BadChars = "" For Val = 0 to 31 ; BadChars = BadChars:Char(Val) ; Next Val For Val = 127 to 252 ; BadChars = BadChars:Char(Val) ; Next Val Convert BadChars to "" in StringIn Return StringIn
At 06 JUL 2022 11:51AM Mike ONeal wrote:
Thank you for the suggestion Bruce - Mike