Formatting the Text field values

Report Inappropriate Content · ‎2012-11-21

Hi All,

I have Field Value in Text format

"New Orleans"

How can I change it into 'New+Orleans'

in the script itself.

--

MayilVahanan · ‎2012-11-21

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 · ‎2012-11-21

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

Report Inappropriate Content · ‎2012-11-21

this one worked

Replace(TextField,' ','+')