Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Invalid character in chuenese text in AX 2012 r3

Posted on by 5,885

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 

  • Verified answer
    ergun sahin Profile Picture
    ergun sahin 8,812 Super User on at
    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

  • Suggested answer
    ergun sahin Profile Picture
    ergun sahin 8,812 Super User on at
    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);

  • @rp@n Profile Picture
    @rp@n 5,885 on at
    RE: Invalid character in chuenese text in AX 2012 r3

    hi Ergun,

    InvCharcr.jpg

    3348.J1.jpg

    please give me more shed on this

  • @rp@n Profile Picture
    @rp@n 5,885 on at
    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!

  • Suggested answer
    ergun sahin Profile Picture
    ergun sahin 8,812 Super User on at
    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?

  • @rp@n Profile Picture
    @rp@n 5,885 on at
    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!

  • Suggested answer
    ergun sahin Profile Picture
    ergun sahin 8,812 Super User on at
    RE: Invalid character in chuenese text in AX 2012 r3

    strRem

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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans