Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
michela_lioni
Contributor
Contributor

Hi everyone

I have a long and always changing list of Order Numbers, (example : ORD 0017906713)

I need to replace the space and put '-' instead. I'm currently struggling as the replace function will ask me to put a specific term to substitute with a new one.


I hope that makes sense (ps: excuse my poor english)


Thank you in advance,

Michela

1 Reply
m_woolf
Master II
Master II

replace([Order Numbers],' ','-') as Whatever