topic Exclude commas and include valued in Talend Studio

Exclude commas and include valued

Anonymous — Sun, 27 Jan 2019 17:34:25 GMT

Hi,
My input is:
Id,name,value
2,raj,23,45
3,raw,49
4,harsh,34,76,98

As this is comma seperated i am getting output as :
Id,name,value
2,raj,23
3,raw,49
4,harsh,34

But I need all the numbers in "Value" column. Please help how to get

Re: Exclude commas and include valued

akumar2301 — Sun, 27 Jan 2019 19:34:10 GMT

One Option :

Read each line as fullrow or one column --> Split it into three cols using regular expression ( tExtractRegexFields) --> Output

Regex expr : "^(\\w+),(\\w+),(.*)"

Let me know if it works

Re: Exclude commas and include valued

vapukov — Mon, 28 Jan 2019 00:38:44 GMT

the most proper way - strongly ask (if it possible) to enquote strings in source export:

"4,\"harsh, any numbers of commas inside \",\"34,76,98"\"

it will properly handle any numbers of columns with commas inside

if for some reason it is not possible (but in many cases it only look not possible unless you did not explain reasons for changes), and in case if you sure - only last column is wrong:

solution from @uganesh - must work
another similar solution - replace first XXX commas with | or ;