Handling Nulls in PX sequential Files
Posted: Sun Nov 07, 2004 11:02 am
Hi , I know this subject has been posted before but I still am not getting anywhere so am posting some specifics of my problem so that I can avail myself of your monumental experience and sheer brilliance (you can tell I need help)
Basically I am trying to read a csv(ish) file using PX the format is as follows
<Integer>,<Date1>,<Date2>,<Date3>,<Date4)
Where the date fields can be null, but (and here is the gotcha) the first 3 date fields are padded to 8 space chars if null where as the last one is terminated with a <CR> if null so the data will look something like this
I've tried several combinations of field level settings w.r.t. the nullable date fields , namely dates1-3 having null field value='<SPC*8>' and the date4 null field value = /x0a but keep getting
Warnings
What is the best way to specify this as its doing my head in
Thanks in advance
Fridge
Basically I am trying to read a csv(ish) file using PX the format is as follows
<Integer>,<Date1>,<Date2>,<Date3>,<Date4)
Where the date fields can be null, but (and here is the gotcha) the first 3 date fields are padded to 8 space chars if null where as the last one is terminated with a <CR> if null so the data will look something like this
Code: Select all
0,20040216,20040216, ,<CR>
6,19971002,20040815,20000623,20040827
9,20010105,20030518, ,<CR>
15,19990412,20040831,20001017,20040826
Code: Select all
IBStatus,0: Input buffer overrun at field "DATE4", at offset: 36
What is the best way to specify this as its doing my head in
Thanks in advance
Fridge