Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Pico
Partner - Creator
Partner - Creator

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 - Creator
Partner - Creator
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.