Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Remove character Before , After & in between the String and add _ in between the string

AKPWZ
8 - Asteroid

I have a string field that looks like this "0.HTTP.2.WebText"  (a JSON_Name field).

 

And I want to remove the unwanted character using regex or any other formula in my workflow to achieve the output.

The output should look like this - "HTTP_WebText".

Any idea how to solve this, please? Thanks.

 

20 REPLIES 20
Jean-Balteryx
16 - Nebula
16 - Nebula

Same as @atcodedog05! 😊

Labels
Top Solution Authors