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