Convert format to number

KNIME Analytics Platform
1

Hi,

Can you please help me in determining the node I should use in converting the numbers on the left column to my desired format in the right column?

CURRENT FORMAT DESIRED FORMAT
7.10011E+14 710010782100010
7.10011E+14 710010975600060
7.10012E+14 710011544800010
7.10012E+14 710011544800020
7.10012E+14 710011544800030
7.10012E+14 710011544800040
7.10012E+14 710012396300010
7.10012E+14 710012396300030
7.10013E+14 710012814700010
7.10013E+14 710013211300010

Thanks for your help!

2

Hi @ann_knime

It would be helpfull if you can upload a KNIME flow with sample data.
afbeelding
So we can see what the actual CURRENT FORMAT is in a KNIME table. And search/create a solution from that point.

gr. Hans

2 Likes
3

Hello @ann_knime ,

Lets assume your Current Format is in String. If not convert it to string.

Here you can use Column Expression Node to convert your string value to desired format

1
1718×413 22.7 KB

Use following code in expression editor

2
2746×703 14.1 KB

Regards,
Yogesh

2 Likes
4

Hi HansS,

Attached is the sample KNIME table with data. Below is my desired output based on the data in the table:

DESIRED OUTPUT
710010813400020
710010813400030
710010813400040
710010813400050
710012466400020
710012466400030
710012466400040
710012466400050
710010813400100
710010813400110

Thank you for the help.
SAMPLE TABLE.knwf (4.4 KB)

1 Like
5

Thanks Yogesh! I will try this.
Thank you so much for your help! :slight_smile:

6

Hi @ann_knime

Your input data is configured as a string. What you see is what you get. With the String to Number node you can convert it to a double for example. But this transformation does not give you the information you expect as output.
afbeelding

gr. Hans

1 Like
7

hey @ann_knime,

Do you want to group similar numbers and add 10,20 ,30 and so on as per count?

8

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.