topic Re: can we remove pipe delimiter between double quotes in Talend Studio

can we remove pipe delimiter between double quotes

Sasidhar1 — Sat, 16 Nov 2024 03:06:58 GMT

my data is having pipeline in fields having double quotes.

there is no particular sequence for that.

Delimiter is also pipeline

Requirement:

I need to delete all the pipelines which are in between double quotes by using only two components ( tFileInputDelimited and tFileOutputDelimited )

Sample input with random columns having double quotes.

Sample Output (Required)

Only tFileInputDelimiter and tFileOutputDelimiter should be used

can anyone please help...

Anonymous — Tue, 03 Mar 2020 11:15:52 GMT

Hi Sasidhar,

We need to use replace function to replace "|" with "" (empty) value. But, we have to use tMap between components.

As of my knowledge, we don't have any option to replace in tfileinput/output delimited components.

Thanks.

Sasidhar1 — Tue, 03 Mar 2020 12:13:46 GMT

ho k thank you for your time vinod.