You are not logged in.
Announcement
Unanswered posts
|
Thank you Vincent. I marked this as answered!
Encoding:
Field Separator: ,
Row Separator: \n
Escape Char Settings:
Escape Char: "\\"
Text Enclosure: "\""
Hello Talend Users,
How would you setup file property for this formatted input file?
Here's the format within the file:
"FeedDate", "HotelName", "Cost"... etc.
"2012-04-01 00:00:00", "Dünenstraße 14, Regent Street", "3.5"... etc.
As you can from the file format, it has comma within a single field (HotelName); therefore, comma alone cannot be the delimiter. I want to be able to capture all strings within the double quotes.
I have unsure what to assign the properties below for this type of input file:
Encoding:
Field Separator:
Row Separator:
Escape Char Settings:
Escape Char:
Text Enclosure:
Your best practice knowledge on this would be extremely helpful!
Sincerely.