Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
dhnaz_yus07
Contributor
Contributor

Handling Quotes and Null values in a column

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
Labels (3)
1 Reply
HirisH_V7
Master
Master

Replace(Value,Chr(34),'')

*Value will be your field name
HirisH
“Aspire to Inspire before we Expire!”