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