Focal Point
Reading a CSV file

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3821018331

November 16, 2004, 04:06 PM
<Pietro De Santis>
Reading a CSV file
I have four columns in a CSV file.

Some rows do not contain any data in the last column.

When I read the file with a TABLE request, I get the following error:

Input line contains less data than expected: line 2

and the line is not included in the output.

Is there any way to avoid this situation, without having to change the CSV file?

Is there anything I can add to the Master or Fex?

Thanks,

Pietro.
November 16, 2004, 04:21 PM
<Pietro De Santis>
The problem is occuring in 4.3.6.

I dug around on the Tech Support site and found that a PTF was created to resolve this issue.

We're in the middle of upgrading to 5.3.2. I tried my program in 5.3.2 and it works without the error.

Cheers.

Pietro.
November 16, 2004, 05:11 PM
susannah
Pietro, whats a PTF?
November 16, 2004, 05:17 PM
<monte2000>
PTF = Program Temporary Fix, i.e., spot fix, patch or zap.

Monica
November 16, 2004, 06:11 PM
<Pietro De Santis>
I think it's an IBI term for a patch that's applied when requested.
November 16, 2004, 07:01 PM
suzy_smith
From my memory, it's an IBM term. And I believe Focus was originally developed on IBM's VM/CMS, so that terminology kind of became ingrained to refer to a bug fix.