DSXchange

Hi,

I am trying to read a fixed width file .txt

While reading when the file has a new line it do not give the warning
Warning:Missing record delimiter "\n", saw EOF instead

Else when the file has no newline at the end of the records
it gives a ewarning
Missing record delimiter "\n", saw EOF instead

Please do suggest how can i remove this warning.

Thanks

Do you mean to say, you didnt get the warning when you had the new line character in you file?
Try to delete the last line of the file and check it out.
If you albe to see the file from any Text Editior where you can view the Newline character and spaces and tabs, you might a empty line as last line. Just my guess.

I think it's the other way around - the last line in the file lacks a line terminator. Because the metadata specifies that each line has one, the warning is thrown on the final line.

The data is this way

Case 1

ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB
|


Case 2


ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB|


In both the case '|' is just to show you the position of the cursor in the file.

case 1 do not throw this warning where as Case 2 throws warning

Please suggest a solution.

In format i have given just Delimiter = None.
And for record delimiter i did not specify it..

ray.wurlod wrote:I think it's the other way around - the last line in the file lacks a line terminator. Because the metadata specifies that each line has one, the warning is thrown on the final line. ...

Suggestion: use the file format in Case 1.

Suggestion: use the file format in Case 1.

As described by Ray, the case II, does not have new line character at all, rather EOF is present in it.