5,901
Hi team,
I have found one invalid character in Chienese text. Because of that I got hexadecimal invalid character error while exporting data in excel.
Kindly let me know how I will remove the invalid character through x++ from text .
Please give me more shed on this
We know the position(last char(strLen(value))), you can solve it with substr or strDel
Do you want to delete the "台" character (in the question, the parentheses are empty) or is there a different character and we can't see it?
Share
Report
All responses (
Answers (
str value = "疾病发展论坛。--展台";
value = strRem(value,"台");
info(value);
It's hard to say without seeing it (I don't understand why you can't use the character), but if you know what position it is in the text you have, you can split it with substr and set the relevant character into a variable and use that variable to make strRem.
Or, you can try with Unicode Code values or by reading the character from a different place, but as I said at the beginning, I don't understand why you can't use the character.
Can you show with an example?
Hi Ergun,
I tried this, but I unable to paste the invalid character in to the strRem() function. That's why unable to remove the invalid character from text.
I copied the whole Chinese text in notepad. From where I copied only the invalid character and try to paste in to stream function. But unable to paste.
Plesse give me more shed on this
Thanks!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156