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
  • 4,212
  • 1
  • 38
  • 34
freesniper
  • 79
  • 1
  • 9

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,665
  • 1
  • 25
  • 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
  • 17,733
  • 4
  • 24
  • 41