topic Re: reformat '### ##' into '#####' in QlikView https://community.qlik.com/t5/QlikView/reformat-into/m-p/483659#M180733 <HTML><HEAD></HEAD><BODY><P>it also worked </P><P>thanks</P></BODY></HTML> Mon, 12 Aug 2013 09:14:02 GMT felcar2013 2013-08-12T09:14:02Z reformat '### ##' into '#####' https://community.qlik.com/t5/QlikView/reformat-into/m-p/483654#M180728 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i need to reconvert something like this</P><P></P><P>Field1</P><P>236 23</P><P>569 74 </P><P>45621</P><P>12369</P><P>x</P><P></P><P>into this:</P><P></P><P>Field2</P><P>23623</P><P>56974 </P><P>45621</P><P>12369</P><P>x</P><P></P><P>thanks</P></BODY></HTML> Mon, 12 Aug 2013 08:40:13 GMT https://community.qlik.com/t5/QlikView/reformat-into/m-p/483654#M180728 felcar2013 2013-08-12T08:40:13Z Re: reformat '### ##' into '#####' https://community.qlik.com/t5/QlikView/reformat-into/m-p/483655#M180729 <HTML><HEAD></HEAD><BODY><P>try in load statement:</P><P></P><P>Num(Keepchar(Field1,'1234567890')) as Field2</P></BODY></HTML> Mon, 12 Aug 2013 08:44:36 GMT https://community.qlik.com/t5/QlikView/reformat-into/m-p/483655#M180729 tresB 2013-08-12T08:44:36Z Re: reformat '### ##' into '#####' https://community.qlik.com/t5/QlikView/reformat-into/m-p/483656#M180730 <HTML><HEAD></HEAD><BODY><P>Try num(num#(Field1)) as Field2</P></BODY></HTML> Mon, 12 Aug 2013 08:45:42 GMT https://community.qlik.com/t5/QlikView/reformat-into/m-p/483656#M180730 Gysbert_Wassenaar 2013-08-12T08:45:42Z Re: reformat '### ##' into '#####' https://community.qlik.com/t5/QlikView/reformat-into/m-p/483657#M180731 <HTML><HEAD></HEAD><BODY><P>This is an example of <A _jive_internal="true" href="https://community.qlik.com/people/robwunderlich">Rob Wunderlich</A>'s technique, check CLEANED_TEXT after cleaning from spaces.</P><P></P><P>SpaceMap:</P><P><SPAN style="color: #0000ff; font-size: 10pt;">MAPPING</SPAN><SPAN style="font-size: 10pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 10pt;"><STRONG>LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">repeat</SPAN><SPAN style="font-size: 10pt;">(' ', </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">RecNo</SPAN><SPAN style="font-size: 10pt;">()), ' '<BR /></SPAN><SPAN style="color: #0000ff; font-size: 10pt;">AutoGenerate</SPAN><SPAN style="font-size: 10pt;"> 10&nbsp; </SPAN><SPAN style="color: #008000; font-size: 10pt;">// up to 10 spaces<BR /></SPAN><SPAN style="font-size: 10pt;">;<BR /><BR />SAMPLE:<BR /></SPAN><SPAN style="color: #0000ff; font-size: 10pt;"><STRONG>LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> * </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">Inline</SPAN><SPAN style="font-size: 10pt;"><BR /></SPAN><SPAN style="color: #800000; font-size: 10pt;">[TEXT<BR />HELLO AND&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WELCOME<BR /> THIS IS A SAMPLE TEST<BR /> I&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AM NOT SURE<BR />]</SPAN><SPAN style="font-size: 10pt;">;<BR /><BR />DATA2:<BR /></SPAN><SPAN style="color: #0000ff; font-size: 10pt;"><STRONG>LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">MapSubString</SPAN><SPAN style="font-size: 10pt;">('SpaceMap', </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">trim</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">TEXT</SPAN><SPAN style="font-size: 10pt;">)) </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">as</SPAN><SPAN style="font-size: 10pt;"> </SPAN><SPAN style="color: #800000; font-size: 10pt;">CLEANED_TEXT</SPAN><SPAN style="font-size: 10pt;"><BR /></SPAN><SPAN style="color: #0000ff; font-size: 10pt;">Resident</SPAN><SPAN style="font-size: 10pt;"> SAMPLE;<BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I hope this helps!</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">MultiView<BR /></SPAN></P></BODY></HTML> Mon, 12 Aug 2013 08:50:01 GMT https://community.qlik.com/t5/QlikView/reformat-into/m-p/483657#M180731 Anonymous 2013-08-12T08:50:01Z Re: reformat '### ##' into '#####' https://community.qlik.com/t5/QlikView/reformat-into/m-p/483658#M180732 <HTML><HEAD></HEAD><BODY><P>thanks it worked</P></BODY></HTML> Mon, 12 Aug 2013 09:13:41 GMT https://community.qlik.com/t5/QlikView/reformat-into/m-p/483658#M180732 felcar2013 2013-08-12T09:13:41Z Re: reformat '### ##' into '#####' https://community.qlik.com/t5/QlikView/reformat-into/m-p/483659#M180733 <HTML><HEAD></HEAD><BODY><P>it also worked </P><P>thanks</P></BODY></HTML> Mon, 12 Aug 2013 09:14:02 GMT https://community.qlik.com/t5/QlikView/reformat-into/m-p/483659#M180733 felcar2013 2013-08-12T09:14:02Z Re: reformat '### ##' into '#####' https://community.qlik.com/t5/QlikView/reformat-into/m-p/483660#M180734 <HTML><HEAD></HEAD><BODY><P>thanks for this one</P><P>nice solution</P></BODY></HTML> Mon, 12 Aug 2013 13:49:06 GMT https://community.qlik.com/t5/QlikView/reformat-into/m-p/483660#M180734 felcar2013 2013-08-12T13:49:06Z