Row separator is not right

[Anonymous]

Hello,

What is the right row separator to be use if the data that I'll be loading is like below:

"123456","ABC","ABC DEFG HIJKL","100 Yellow Street","Saigon","SAI","5000","GON"

I used "\n" but the data became like what I post below, which is the last letter or number inserted on the next column.

"12345","6BC","AABC DEFG HIJK","L100 Yellow Stree","tsaigo","nAI","S500","0GON"

[Anonymous]

Greetings,

Row separator is okay if all the data rows are on new line,

you better specify right column separator.

Regards

Chandra Kant

[Anonymous]

Where should I specify that and what would be the right column separator for that kind of data?

[Anonymous]

Which component you are using as if now ?

What is your input file type ?

If it is csv go for tFileInputDelimited and you will easily find the "Field Separator "

Regards 

Chandra Kant

[Anonymous]

The issue appears to be that your positional file pattern ( "1, 6, 3, 35, 35 ...." ) is incorrect. This is a comma separated list of lengths. The pattern shown in your screenshot says: map the first 1 character in a line to the first column, then the next 6 to the second column, followed by the next 3 in the third column and so on.

With that said, the data you show in your post does not match up with the pattern in the screenshot, so there is likely some confusion going on. 

[Anonymous]

tfileinputpositional is the component that I am using and I'm trying for both CSV and TXT file.

[Anonymous]

@JGM Indeed and I'm looking on the something weird.

[Anonymous]

Hi,

    Could you please advise which component you are using to parse the file? I was able to read the sample data you had provided from the file in right fashion.

Please refer the component details below.

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

[Anonymous]

I'm using a tfileinputpositional not the tfileinputdelimited one.

[Anonymous]

Hi,

      The data you have shown in your query is in delimited format. Is there any specific reason to choose the tfileinputpositional instead of tfileinputdelimited for your use case?

Warm Regards,

Nikhil Thampi