Finance | Project Operations, Human Resources, ...

How to replace or remove any invalid characters from text

(0) Share

Report

Posted on by @rp@n

Hi All,

Kindly let me know how to replace or remove any invalid characters from text in AX 2012 R3.

When I am copied and trying to paste the invalid characters in code it display like empty So, not able to apply in function like strRep or strRem to remove or replace that invalid characters from text.

Kindly suggest me how we can achieve this?l

Please give me more shed on this.

thanks!

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report
Copy link

Link copied!

If I m not wrong you have that character at table so you can get char from the record value with position and use char value for ax str functions (strRep,Rem etc.)

Or you can search ascii value of the char at internet and use it in the code

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

Like (0)

Report
Copy link

Link copied!

hi Ergun,

Pls let me know how will get the ASCII characters ? in google unable to paste the invalid character.

pls send me the sample code.

thanks

Was this reply helpful? Yes No
Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report
Copy link

Link copied!

Select the record and set to a string valuable. Get lenght with strlen. Loop it and get every value with char2num. You can get ascii with this. Seach İnternet with this value and do whatever you want at next step

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

Like (0)

Report
Copy link

Link copied!

thanks ergun,

if possible , pls send me the code sample.

Was this reply helpful? Yes No
Martin Dráb 239,035 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Which characters do you consider invalid in your particular case?

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

Like (0)

Report
Copy link

Link copied!

Martin, already I have marked in the screen shot in trail post. Kindly follow pls

Was this reply helpful? Yes No
Martin Dráb 239,035 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Your screenshot shows two characters. Are you saying that you want a solution for these two characters only? I doubt so. Also, there may be some special characters that aren't actually displayed.

I believe you need something more generic, but you haven't yet thought about your requirements. You must think about what you actually want before you can write code doing such a thing.

You mentioned ASCII, therefore you may want to remove all characters that aren't in the ASCII table, but it's not clear whether it's safe enough. There may be non-ASCII characters that may be acceptable. Also, ASCII contains characters that aren't valid for an invoice number, such as the vertical tab. Therefore accepting all ASCII table isn't really safe, although it may be acceptable in your code. Maybe you rather want to accept selected Unicode character categories, or something like that.

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

Like (0)

Report
Copy link

Link copied!

Martin, which I marked that only cause the issue. That marked character I wants to remove.

Kindly advice

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,035 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Well, that you have the problem with these particular characters today doesn't mean that you won't run to another character tomorrow. Even the title of this thread asks "how to replace or remove any invalid characters".

But anyway, you can use strReplace() to find and replace a character in a string. If you want to remove it, replace it with an empty string.

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

Like (0)

Report
Copy link

Link copied!

Martin, please let me know how will pass that marked character in StrReplace function?

When i am trying to paster , its showing blank.

Please give me more shed on this

Was this reply helpful? Yes No