Number Formatting like 100k to 100,000

[ozisak (Ozlem)]

Hi to All,

I have a project that gets likes and dislikes of Youtube videos and writes them to the excel.
and do some calculations on likes and dislikes count.

My problem is, I’m getting the likes as “100k”, so not an integer. Even if it was just “100”, I know I should convert. because Get text activity’s result is the string. However, the value is 100k, and dont know the way I should follow.

should i use “.replace()” method for K and then convert it to String?

or anything should be in excel, any other suggestions?

Cheers,

Ozi

[Coolbox (Jørgen Kold)]

You can use VARIABLE.replace(“K”,“000”) //where VARIABLE is your string
If you need it as a number in calculations, you can add:

double.parse(VARIABlE.replace(“K”,“000”)) //where VARIABLE is your string

[ozisak (Ozlem)]

@Coolbox

double.parse(VARIABlE.replace(“K”,“000”))

Oh yes! im gonna add this, will inform you.
Thank you

[balupad14 (Balamurugan)]

Hi @ozisak,

you can use this activity to format any type.

FormatActivities

I have created a custom activity to format the double and number values instead of using the code invoke. Using this activity you can able to format in any combination. It has 2 activities. One is for double value and another one is for integer. I Hope it will helpful . Sample File : NumberFormatNuget.zip (2.2 KB) [image] [image] Regards Balamurugan

I am looking for number format as per following 1200,00,000.00

Hi @kawalkarhemant and all members, I have created a custom activity to format the double and number values instead of using the code invoke. Using this activity you can able to format in any combination. It has 2 activities. One is for double value and another one is for integer. I Hope it will helpful . Below I have attached Thank you Balamurugan.S

Regards
Bala