You are viewing limited content. For full access, please sign in.

Question

Regular Expression to remove all Commas from any text

Workflow

Updated December 19, 2018

asked on December 19, 2018

Hi All

I need to remove all commas from a text token, the text can be of any length, but max is 40 characters.

I need a regular expression to remove the all commas that might appear in the text.

This is what i have so far :-

5555.JPG (67.13 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on December 19, 2018

Do you want to remove them or substitute them with space?

I'd use the Substitute function in Token Calculator or the Pattern Matching activity. Regular expressions directly on a token don't have the full range of options like the Pattern Matching activity does.

2 0

replied on December 19, 2018

Hi Miruna

I want either remove them or replace them with a space, i haven't looked at the substitute function in the token calculator., so maybe i will start there.

0 0

replied on December 19, 2018

thanks Miruna , the substitute function works perfectly.

0 0

Question

Question

Regular Expression to remove all Commas from any text

Answer

Replies

Sign in to reply to this post.