topic Re: Formatting the Text field values in QlikView https://community.qlik.com/t5/QlikView/Formatting-the-Text-field-values/m-p/456202#M489116 <HTML><HEAD></HEAD><BODY><P>this one worked</P><P></P><P>Replace(TextField,' ','+')</P></BODY></HTML> Wed, 21 Nov 2012 17:01:56 GMT 2012-11-21T17:01:56Z Formatting the Text field values https://community.qlik.com/t5/QlikView/Formatting-the-Text-field-values/m-p/456199#M489113 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have Field Value in Text format </P><P></P><P>"New Orleans"</P><P></P><P>How can I change it into 'New+Orleans'</P><P>in the script itself.</P><P></P><P>--</P></BODY></HTML> Wed, 21 Nov 2012 15:46:23 GMT https://community.qlik.com/t5/QlikView/Formatting-the-Text-field-values/m-p/456199#M489113 2012-11-21T15:46:23Z Re: Formatting the Text field values https://community.qlik.com/t5/QlikView/Formatting-the-Text-field-values/m-p/456200#M489114 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>=Replace(FieldValue('TextField',1),' ','+')</P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 21 Nov 2012 15:52:24 GMT https://community.qlik.com/t5/QlikView/Formatting-the-Text-field-values/m-p/456200#M489114 MayilVahanan 2012-11-21T15:52:24Z Re: Formatting the Text field values https://community.qlik.com/t5/QlikView/Formatting-the-Text-field-values/m-p/456201#M489115 <HTML><HEAD></HEAD><BODY><P>i will use mapping load, &amp; applymap to change data values</P></BODY></HTML> Wed, 21 Nov 2012 16:16:17 GMT https://community.qlik.com/t5/QlikView/Formatting-the-Text-field-values/m-p/456201#M489115 Anonymous 2012-11-21T16:16:17Z Re: Formatting the Text field values https://community.qlik.com/t5/QlikView/Formatting-the-Text-field-values/m-p/456202#M489116 <HTML><HEAD></HEAD><BODY><P>this one worked</P><P></P><P>Replace(TextField,' ','+')</P></BODY></HTML> Wed, 21 Nov 2012 17:01:56 GMT https://community.qlik.com/t5/QlikView/Formatting-the-Text-field-values/m-p/456202#M489116 2012-11-21T17:01:56Z