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
susannahPietro, 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_smithFrom 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.