topic Re: Reading CSV Feed dynamically in Talend Studio

Reading CSV Feed dynamically

Prasanna3 — Fri, 28 Dec 2018 03:51:14 GMT

Hi
I have CSV feed like below.

I want to read that schema dynamically when columns having double quotes.

"empno","ename","sal","deptno","location"
100,Sam,500,10,Hyderabad
200,pras,600,20,mas.

Please someone provide me solution for this.i tried everything it didn't worked for me.

Re: Reading CSV Feed dynamically

sraoul2002 — Fri, 28 Dec 2018 09:26:18 GMT

Hello,

you have 2 solutions :

1- read the csv file without the header (if the header is the only line which have the double quotes)

2- Read all column of the csv file as String and remove the double quotes in tmap : varString.replace("\"","")

//varString is the fied name of your string.

let us know if you have issue anymore.

Regards

Re: Reading CSV Feed dynamically

Prasanna3 — Fri, 28 Dec 2018 12:08:25 GMT

My scenario is I should read by using dynamic feature