Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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.
ho k thank you for your time vinod.