Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Pico
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
Pico
Partner - Contributor III
Partner - Contributor III
Author

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

salmankojar
Partner - Creator
Partner - Creator

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

i have used replace function.