can we remove pipe delimiter between double quotes

[Sasidhar1]

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]

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]

ho k thank you for your time vinod.