0 Replies Latest reply: Aug 30, 2013 3:12 PM by iTree Consulting RSS

    Load Data from TXT with multiple delimeters

    iTree Consulting

      Hi,

      If you will open my attached notepad :

       

      CARDTYPEID###NAME###CARDTYPE2GRAPHICSBITMAP###CARDTYPE2BROWSERBITMAP###TABLENAME###CLASS###DESCRIPTION###PORTSTARTNUMBER###SLOTSTARTNUMBER###CARDSIZE###CRITICALFLAG###POWERSUPPLIED###POWERUSED###POWERUNITS###COOLINGSUPPLIED###COOLINGUSED###COOLINGUNITS###ISVISIBLE###LABEL###

       

      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$$$.

       

      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.

       

      So Help on this. Also find the attached QVW and TXT file.