Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Non-Ascii characters...
Message
From
13/11/2000 14:55:55
 
 
To
13/11/2000 13:51:43
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00441153
Message ID:
00441199
Views:
17
>The info is definately expected. I have a table where input is multi-national with no converters to translate the character differences. So I'm left with some English and some garbage. I need to take out the garbage(sorry).

Something like:
lnX = 1
cString = "**D  )df98 df7 HF*F*D3FHDHF&DFD3"
FOR lnI = 1 to LEN(cString) 
	lcLetter = SUBSTR(cString, lnX)
	IF ISALPHA(lcLetter) or ISDIGIT(lcLetter) or lcLetter = ' '
		lnX = lnX + 1
	ELSE  
		cString = STUFF(cString, lnX, 1, '')
	ENDIF 
ENDFOR 
?cString
This gets saves only the digits, letters and spaces. EVerything else is thrown. You could modify it to keep all the symbols you want too, but it should filter out all the unidentified characters.
Previous
Reply
Map
View

Click here to load this message in the networking platform