I have a column A(in string) :
I use a tMap to put the number in double. So, i have that :
#DIV/0! (disappears) #DIV/0! (disappears) #DIV/0! (disappears)
So, I use in Expressions :
but it doesn't work.
I want keep "#DIV/0!" in Excel. I want keep numbers in double.
Thank you in advance
Solved! Go to Solution.
No, I always want see "#DIV/0!" in my Excel.
But, when i put the column in double, Talend doesn't keep "#DIV/0!". I need them to stay because there are informations linked to the "#DIV/0!"
@Beauchamp_J,in to double column you cannot populate sting value as #DIV/0!. if you want numbers into one column and string value into another column you can do.
Thank you for that solution but i can't have two columns. (in my Excel, it is many column with number, SUM, DIV....) I just keep three columns (A= ID, B= Name and AF= Number and DIV/0!) (and other columns (D, E, F, G, ....) aren't filtered)
I will try to use tReplace.
I added a tMap more with your proposition and this works!
I needed take a pause and i had a idea after.
Thanks for your help.