Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to Talend so requiring help during development. I have quotes in some rows of the table but not others (having null values). I had to remove the quotes from the rows and also handle nulls for others rows. I used replace function for remove quotes but it is throwing null exception. Require help here for resolving this issue. Example is as below
Input:
"211" |
"211" |
"123,999" |
Required Output:
211 |
211 |
123,999 |
Replace(Value,Chr(34),'')
*Value will be your field name