datastage

How to remove double Quotes In DataStage using a transformer stage?


We receiving Input data like below “VENKATA,KRISHNA”

I want output like below VENKATA,KRISHNA

Can anyone help me with this


Solution

  • Check out the Ereplace function - it allows to replace certain characters so you could rplace " with '' (empty string).

    An alternative is TRIM - you can specify which character the command should trim and also if All occurrences or Both (from both sides of the string) plus more.