Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formatting the Text field values

Hi All,

I have Field Value in Text format

"New Orleans"

How can I change it into 'New+Orleans'

in the script itself.

--

3 Replies
MayilVahanan

HI

Try like this

=Replace(FieldValue('TextField',1),' ','+')

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable
Author

i will use mapping load, & applymap to change data values

Not applicable
Author

this one worked

Replace(TextField,' ','+')