Invalid character in chuenese text in AX 2012 r3

(0) Share

Report

Posted on by @rp@n

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

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report

RE: Invalid character in chuenese text in AX 2012 r3

strRem

docs.microsoft.com/.../xpp-string-run-time-functions

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

RE: Invalid character in chuenese text in AX 2012 r3

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!

Was this reply helpful? Yes No
Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report

RE: Invalid character in chuenese text in AX 2012 r3

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?

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

RE: Invalid character in chuenese text in AX 2012 r3

hi Ergun,

疾病发展论坛。--展台

I wants to remove the last character ( )only. But in AX I unable to paste the specific character.

please give me more shed on this.

thanks!

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

RE: Invalid character in chuenese text in AX 2012 r3

hi Ergun,

please give me more shed on this

Was this reply helpful? Yes No
Suggested answer

ergun sahin 8,826 Moderator on at

Like (1)

Report
RE: Invalid character in chuenese text in AX 2012 r3

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?

str value = "疾病发展论坛。--展台"; value = strRem(value,"台"); info(value);

Was this reply helpful? Yes No
Verified answer

ergun sahin 8,826 Moderator on at

Like (1)

Report

RE: Invalid character in chuenese text in AX 2012 r3

We know the position(last char(strLen(value))), you can solve it with substr or strDel

Was this reply helpful? Yes No