Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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