How to concatenate and remove a decimal point and extra 0’s

[Dittau]

Hello,

I’m using the formula to concatenate items (simple plus function in formula). I have a number like 18392.0000 and i need to remove the ‘.0000’ out of the number before I concatenate with other items. How do i do that?

[martinding]

Hi @Dittau,

The easiest way is to change the number to an Integer type before concatenating using the + sign and then simply ToString(you number) + other items.

[Dittau]

What tool do i use for that or how do i do that?

[flying008]

Hi, @Dittau 

ToString(18392.0000)

[Dittau]

That’s not what i’m looking for. Let me give a better example

column- drinks

column- food

column-price

drinks             Food               Price

soda               Chicken           6527.0000

Water               Pork                372.0000

how do i concatenate soda + chicken + only the 6527 (get rid of .0000) in the formula tool?

definitely need to use brackets as there is multiple tows of data so keep that in mind please

[Luke_C]

Hi @Dittau 

Like others have said, change the data type to numeric and then use a ToString() when you're concatenating:

[Dittau]

how do you change the data type- I’ve seen it before but can’t remember what tool that is.

[Luke_C · Accepted solution]

@Dittau I shared the workflow - it's in the select tool: