tMap : #DIV/0! disapperars

[Anonymous]

Hi !

I have a column A(in string) : 

12

10

48

16

27

24

#DIV/0!

116

147

#DIV/0!

#DIV/0!

#DIV/0!

I use a tMap to put the number in double. So, i have that :

12

10

48

16

27

24

#DIV/0!     (disappears)

116

147

#DIV/0!    (disappears)

#DIV/0!    (disappears)

#DIV/0!    (disappears)

So, I use in Expressions : 

row4.ColumnA.equals("#DIV/0!")?Double.toString(row4.ColumnA):row4.ColumnA

but it doesn't work.

I want keep "#DIV/0!" in Excel. I want keep numbers in double.

Thank you in advance

[manodwhb]

@Beauchamp_J,are you looking for the following?

[Anonymous]

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!"

[manodwhb]

@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.

[manodwhb · Accepted solution]

@Beauchamp_J,please check this wil be usefull.

[Anonymous]

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.

[Anonymous]

@manodwhb

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.