question ReplaceTextWithMapping to replace value with space in Support Questions

ReplaceTextWithMapping to replace value with space

tsunbonyu — Sat, 05 Oct 2019 20:37:48 GMT

Hi,

I try to replace text with space using ReplaceTextWithMapping processor. I have file with multiple lines

"action":"account sing up" "action":"account sign in" "action":"account sign out"

And I have a mapping file with \t separating the search value and replace value

account sing up asu account sign in asi account sign out aso

Regular expressions "action":"(.*)"

Matching group: 1

Result

"action":"account sing up" "action":"account sign in" "action":"account sign out"

Expected:

"action":"asu" "action":"asi" "action":"aso"

Does anyone know what I did wrong?

Thanks

David

Re: ReplaceTextWithMapping to replace value with space

MattWho — Wed, 09 Oct 2019 17:47:24 GMT

Hello David,

The ReplaceTextWithMapping processor has been around for some time now and its design is rather simplistic in its current implementation. It is designed to match a simple regex that will map one group of non-whitespace characters to another group of characters (can have white space and back references).

in your example you are matching on a a set of characters that contains whitespaces.

If you were to add a replaceText processor to your flow to replace all the whitespace with a non-whitespace character like "-", then it will work. sample ReplaceText processor configuration:

Your mapping file would of course then be based off this change:

account-sing-up asu account-sign-in asi account-sign-out aso

the resulting mapping would then work:

Thank you,

Matt

Re: ReplaceTextWithMapping to replace value with space

tsunbonyu — Wed, 09 Oct 2019 18:16:10 GMT

Thank you. It really helps 😃