0

I have a mysql table that has a column with the type longtext, this column containt the content of a csv file. Is there a way to create from the content of this column a csv file and extract data from it by using talend ?

t0r0X
  • 3,595
  • 1
  • 31
  • 30
freesniper
  • 79
  • 1
  • 8

2 Answers2

1

You could extract the String from the DB using the proper Input component. Then use tExtractDelimitedField to split this long String string against a separator character (the comma, I guess). Don't forget to specify carefully your output schema

Finally, use tFileDelimitedOut to write the delimited file with data from the outgoing connection on the file system.

This could help: Validate a csv file

Community
  • 1
  • 1
Gabriele B
  • 2,565
  • 1
  • 23
  • 40
0

Sure, request the string out of the database, open a file and write the string to it - where's your actual problem?

Smutje
  • 16,951
  • 4
  • 21
  • 38