topic Loading part of data in LOAD-script in QlikView https://community.qlik.com/t5/QlikView/Loading-part-of-data-in-LOAD-script/m-p/158747#M33673 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>see</P><H4><A id="kanchor1024" name="kanchor1024"></A><A id="subfield" name="subfield">subfield</A>(YourField, '-' ,1 )</H4><H4>Good luck!</H4><H4>Rainer</H4></BODY></HTML> Mon, 14 Mar 2011 09:24:14 GMT 2011-03-14T09:24:14Z Loading part of data in LOAD-script https://community.qlik.com/t5/QlikView/Loading-part-of-data-in-LOAD-script/m-p/158746#M33672 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have some data in one tabel that i load from excel looks like:</P><P>bat-12345-sat</P><P>ch-1254-gat</P><P>12-sat-dat</P><P>I need to load everything before the first "-". Every row is one field.</P><P>Every row is in one field.</P></BODY></HTML> Mon, 14 Mar 2011 09:08:43 GMT https://community.qlik.com/t5/QlikView/Loading-part-of-data-in-LOAD-script/m-p/158746#M33672 2011-03-14T09:08:43Z Loading part of data in LOAD-script https://community.qlik.com/t5/QlikView/Loading-part-of-data-in-LOAD-script/m-p/158747#M33673 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>see</P><H4><A id="kanchor1024" name="kanchor1024"></A><A id="subfield" name="subfield">subfield</A>(YourField, '-' ,1 )</H4><H4>Good luck!</H4><H4>Rainer</H4></BODY></HTML> Mon, 14 Mar 2011 09:24:14 GMT https://community.qlik.com/t5/QlikView/Loading-part-of-data-in-LOAD-script/m-p/158747#M33673 2011-03-14T09:24:14Z