Hi All,
Iam getting the following error my source is txt file its has field delimiter as | and record delimiter none and no quotes in the source data and ID is the field name.
I appriciate if some one can help me this error
Field "ID" delimiter not seen, at offset: 7
Thanks
sequential file handling
Moderators: chulett, rschirm, roy
Do you have an example of the source file that you can paste? Please include several records
Also, your column definitions (including datatype) or better yet an orchestrate schema if you can. For the column ID, how is it defined? Char(7), VarChar() or such?
Regards,
Also, your column definitions (including datatype) or better yet an orchestrate schema if you can. For the column ID, how is it defined? Char(7), VarChar() or such?
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
The error is self explanatory buddy!
Field "ID" delimiter not seen, at offset: 7
There is no delimiter, or it's corrupted due to a delimiter withing the same data itself so it got confused. It's one of the columns beginning/ending that is wrong, the issue doesn't have to be on the offset 7 exactly, check data before it.
Best!
Field "ID" delimiter not seen, at offset: 7
There is no delimiter, or it's corrupted due to a delimiter withing the same data itself so it got confused. It's one of the columns beginning/ending that is wrong, the issue doesn't have to be on the offset 7 exactly, check data before it.
Best!
Not only thoughts, but a little bit of experience.