Answered

remove special characters from a string

(0) Share

Report

Posted on by Jane L. Adney

280

The users want the item number stripped of all special characters as the search name in the product master. I have looked on the web, but I have not really found the solution that I am looking for to be able to do this. Does anyone have a suggestion on how to remove all blanks and special characters?

Thank you

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (0)

Report

It is possible to do a minor customization, but why do the users want to have the search name stripped? What functionality do they expect further or is it for searching purposes only?

Shakespeare once quoted: "What's in a name?". My quote: "What's in a number?"

As you don't give an example I cannot see the need at this moment.

Was this reply helpful? Yes No
Jane L. Adney 280 on at

Like (0)

Report

The user wants to be able to put dashes or periods in the number, but not have those special characters in the search name. They have this in the old system and expect it in the new system. I just need to know how to make them happy.

Was this reply helpful? Yes No
dolee 11,279 on at

Like (0)

Report

What about modifying NameAlias before a record is inserted into InventTable?

Was this reply helpful? Yes No
Dick Wenning 8,705 Moderator on at

Like (0)

Report

in the worse case , write a new method on the class SysQueryRangeUtil

see also

technet.microsoft.com/.../aa569937.aspx

Was this reply helpful? Yes No
Verified answer

Jane L. Adney 280 on at

Like (1)

Report

One of my co-workers figured out the solution that works great.

Static str stripStrings(str _InputString)

{

str message;

message = System.Text.RegularExpressions.Regex::Replace(_InputString, @"[\W_]", "");

return message;

}

Was this reply helpful? Yes No
Suggested answer

Mark Prouty 1,312 on at

Like (2)

Report

Native function strAlpha(inputString) seems to be the same as Jane's solution below.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

HI,

If you want to delete the special characters from string, you can use "strAlpha" function. This copies only the alphanumeric characters from a string.

Ex : info(strFmt("%1", strAlpha("?a*b!!!!cD123.")));

results in "abcD123".

I hope this helps :)

Was this reply helpful? Yes No