Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.