Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

Regex to substitute " " to "_" in automation function RegexReplace. \s not working.

Hi all,

while creating my automations, I need to use the regex replace 

The filed I have is like "my_string" and I need to convert it to "my string" , with a space instead of the "_" .

If I use "\s" it doesn't work, neither inserting only the space in the box, nor [' '].

How can I do it?


thank you very much!

Labels (2)
2 Replies
Partner - Contributor III
Partner - Contributor III

It seems like it uses regex to find the value to remove, but not for the new value to insert. 

Partner - Creator
Partner - Creator

Hi @Pico i have attached the json file for your can check and use it.

i have used replace function.