Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

captainlaw
2012-04-20 01:32:33

Thank you Vincent.  I marked this as answered!

vgalopin
2012-04-19 23:22:30

Encoding:
Field Separator: ,
Row Separator: \n

Escape Char Settings:
Escape Char: "\\"
Text Enclosure: "\""

captainlaw
2012-04-19 20:42:50

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.

Board footer

Powered by FluxBB