Number format issue

[SagarSB]

Hi Experts,

If i m passing value as 12000 to variable then i require it as 12,000.
And when i m passing value 120000 then i require it as 120,000.

How can i acheive this…

[Manjuts90]

@SagarSB Check below link u will get numerous methods for doing it.

.NET String.Format() to add commas in thousands place for a number

[balupad14]

Hi @SagarSB,

This will fix your case.

FormatDoubleIntegerActivities 1.0.0

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 1.Nuget Package - Format.DoubleInteger.Activities.1.0.0.nupkg (6.1 KB) 2.Setup document -Uipath Nuget Setup Document.zip (68.6 KB) 3.Samples - NumberFormatNuget.zip …

Regards
Balamurugan.S

[SagarSB]

Can anyone show me this with we example ,
According to situation mentioned by me above

[Manjuts90]

@SagarSB
ex:- my=12345
my.ToString(“N0”)
output- 12,345

ex:- my=12345
my.ToString(“N”)
output- 12,345.00

There are other methods in link also u try it out

[SagarSB]

@Manjuts90

if my input is 12000 then expected is 12,000.
and if 120000 then expected is 120,000.

[Manjuts90]

@SagarSB Are you expecting dot at the end?

[SagarSB]

@Manjuts90
no

[Manjuts90]

@SagarSB then below method will work for u.

@SagarSB
ex:- my=12345
my.ToString(“N0”)
output- 12,345

[pllo2ptk]

for me this works (must be as a string)
string.format("{0:n0}", <variable.string>)

[SagarSB]

@Manjuts90

what if input is 120000.

I want 120,000 for this input

[Manjuts90]

@SagarSB what problem u getting in above method

[SagarSB]

@Manjuts90

actually i m matching this value with applications generated value.
the application generates 12,000 if value is in thousand.
so i am converting my input to 12,000 format.
but when the value generated in application is in millions as 120000 , application generate it as 120,000.
here my variable taking value 1,20,000…hence i m facing problem.

[Manjuts90]

@SagarSB if your value 1200000 then ur output must be 1,200,000 right?

[SagarSB]

@Manjuts90

no…
if 120000 then 120,000

[Manjuts90]

@SagarSB i am getting that output from above method

[balupad14]

Hi @SagarSB,

Here is the example with output.

Output :

Here is the activity

File : nn.zip (1.6 KB)

Regards
Balamurugan.S

[SagarSB]

@balupad14

Thank you so much i will try and let you know

[SagarSB]

@balupad14

what you have pass in Properties of activities

[balupad14]

Hi @SagarSB,

Case-1
Format : “##,###”
GroupSeparator: “,”

Case-2
Format : “###,###”
GroupSeparator: “,”

Regards
Balamurugan.S