Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I am trying to parse a file. When I check the "Check each row structure against schema" in advance settings some rows have the message "Too many columns", but when I put the schemaCompliance component it doesnt show me an error message.Why is this happen?
Also in one column my values are comma seperated but my file is also comma seperated. For example the value is " Nick , joe,25;USA,student".
I figured it out. I had to check the box like you said and on the Text Enclosure " " " (with no space) .
Can you give screenshots of what you are seeing please? Also, your example of the column which has commas in it, is it surrounded by "" in the file? Can you give an example of one row in the file EXACTLY as it appears in the file?
Hey, thanks for the quick response.
In my file it is like this
Galaxy A5 (2016) Duos A510FD,Samsung,GSM;35262508,Android,Smartphone
And when I printed it is like this
I want all this "Galaxy A5 (2016) Duos A510FD,Samsung,GSM;35262508,Android,Smartphone"
to be only in AccessDevice column not to seperated in other columns.
I see. You haven't give me an example of a complete row of your file though. I can only assume (by the quote in your AccessDevice and Host columns) that your values are wrapped in quotes. Try ticking the CSV options tickbox in your tFileInputDelimited component.
The row is : Galaxy A5 (2016) Duos A510FD,Samsung,GSM;35262508,Android,Smartphone,FALSE,SSL
And I want the "Galaxy A5 (2016) Duos A510FD,Samsung,GSM;35262508,Android,Smartphone" to be in AccessDevice and do not split in other columns like in the photo that I mentioned before .
I ticked the box but nothing happened.
I figured it out. I had to check the box like you said and on the Text Enclosure " " " (with no space) .