https://community.qlik.com/t5/QlikView/string-processing/m-p/1633471#M732014 <P>Hi All<BR /><BR />I have such dataset</P><P>LOAD * Inline [</P><P>Name,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sign&nbsp;<BR />WIND-SEP19,&nbsp; &nbsp; W<BR />WIND-OCT18,&nbsp; &nbsp;W<BR />WIND,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; W<BR />WINDY,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D<BR />];<BR />&nbsp;I need to process each row with the next logic:&nbsp; if&nbsp; there is a "-" I need to&nbsp; replace Name field value till this sign.&nbsp;&nbsp;<BR />As the result I will have the next table&nbsp;</P><P>LOAD * Inline [</P><P>Name,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sign&nbsp;<BR />WIND,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; W</P><P>WIND,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; W</P><P>WIND,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; W</P><P><BR />WINDY,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D<BR />];</P><P>Coud you, please, tell how to apply such logic it in the load script?</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 19:55:33 GMT Peony 2024-11-16T19:55:33Z https://community.qlik.com/t5/QlikView/string-processing/m-p/1633471#M732014 <P>Hi All<BR /><BR />I have such dataset</P><P>LOAD * Inline [</P><P>Name,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sign&nbsp;<BR />WIND-SEP19,&nbsp; &nbsp; W<BR />WIND-OCT18,&nbsp; &nbsp;W<BR />WIND,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; W<BR />WINDY,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D<BR />];<BR />&nbsp;I need to process each row with the next logic:&nbsp; if&nbsp; there is a "-" I need to&nbsp; replace Name field value till this sign.&nbsp;&nbsp;<BR />As the result I will have the next table&nbsp;</P><P>LOAD * Inline [</P><P>Name,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sign&nbsp;<BR />WIND,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; W</P><P>WIND,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; W</P><P>WIND,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; W</P><P><BR />WINDY,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D<BR />];</P><P>Coud you, please, tell how to apply such logic it in the load script?</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 19:55:33 GMT https://community.qlik.com/t5/QlikView/string-processing/m-p/1633471#M732014 Peony 2024-11-16T19:55:33Z https://community.qlik.com/t5/QlikView/string-processing/m-p/1633477#M732015 <P>Try this?&nbsp;</P><P>LOAD * Inline [</P><P>Name, Sign<BR />WIND-SEP19, W<BR />WIND-OCT18, W<BR />WIND, W<BR />WINDY, D<BR />] <STRONG>Where Not WildMatch(Name, 'WIND-*')</STRONG>;</P> Thu, 10 Oct 2019 07:48:53 GMT https://community.qlik.com/t5/QlikView/string-processing/m-p/1633477#M732015 Anil_Babu_Samineni 2019-10-10T07:48:53Z