topic Load Data from TXT with multiple delimeters in QlikView https://community.qlik.com/t5/QlikView/Load-Data-from-TXT-with-multiple-delimeters/m-p/556062#M692938 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>If you will open my attached notepad :</P><P></P><TABLE><TBODY><TR><TD>CARDTYPEID###</TD><TD>NAME###</TD><TD>CARDTYPE2GRAPHICSBITMAP###</TD><TD>CARDTYPE2BROWSERBITMAP###</TD><TD>TABLENAME###</TD><TD>CLASS###</TD><TD>DESCRIPTION###</TD><TD>PORTSTARTNUMBER###</TD><TD>SLOTSTARTNUMBER###</TD><TD>CARDSIZE###</TD><TD>CRITICALFLAG###</TD><TD>POWERSUPPLIED###</TD><TD>POWERUSED###</TD><TD>POWERUNITS###</TD><TD>COOLINGSUPPLIED###</TD><TD>COOLINGUSED###</TD><TD>COOLINGUNITS###</TD><TD>ISVISIBLE###</TD><TD>LABEL###</TD></TR></TBODY></TABLE><P></P><P>These are my field. Start from CARDTYPEID### and End with LEVEL###. CARDTYPEID### is unique key and It start with some number. LEVEL### is End of the Column - 0$$$.</P><P></P><P>Some of the data is null so \N is available, At data entry time some raw is blank so it start with new row. Now I want to identify a single row which has been start with Unique Key and end with 0$$$. Due to blank row I am not able to Identify the same. I have removed the delimeter. But Some row is coming blank and for that new row is coming with different field.</P><P></P><P>So Help on this. Also find the attached QVW and TXT file.</P></BODY></HTML> Fri, 30 Aug 2013 19:12:05 GMT sona_sa 2013-08-30T19:12:05Z Load Data from TXT with multiple delimeters https://community.qlik.com/t5/QlikView/Load-Data-from-TXT-with-multiple-delimeters/m-p/556062#M692938 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>If you will open my attached notepad :</P><P></P><TABLE><TBODY><TR><TD>CARDTYPEID###</TD><TD>NAME###</TD><TD>CARDTYPE2GRAPHICSBITMAP###</TD><TD>CARDTYPE2BROWSERBITMAP###</TD><TD>TABLENAME###</TD><TD>CLASS###</TD><TD>DESCRIPTION###</TD><TD>PORTSTARTNUMBER###</TD><TD>SLOTSTARTNUMBER###</TD><TD>CARDSIZE###</TD><TD>CRITICALFLAG###</TD><TD>POWERSUPPLIED###</TD><TD>POWERUSED###</TD><TD>POWERUNITS###</TD><TD>COOLINGSUPPLIED###</TD><TD>COOLINGUSED###</TD><TD>COOLINGUNITS###</TD><TD>ISVISIBLE###</TD><TD>LABEL###</TD></TR></TBODY></TABLE><P></P><P>These are my field. Start from CARDTYPEID### and End with LEVEL###. CARDTYPEID### is unique key and It start with some number. LEVEL### is End of the Column - 0$$$.</P><P></P><P>Some of the data is null so \N is available, At data entry time some raw is blank so it start with new row. Now I want to identify a single row which has been start with Unique Key and end with 0$$$. Due to blank row I am not able to Identify the same. I have removed the delimeter. But Some row is coming blank and for that new row is coming with different field.</P><P></P><P>So Help on this. Also find the attached QVW and TXT file.</P></BODY></HTML> Fri, 30 Aug 2013 19:12:05 GMT https://community.qlik.com/t5/QlikView/Load-Data-from-TXT-with-multiple-delimeters/m-p/556062#M692938 sona_sa 2013-08-30T19:12:05Z