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…
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…
@SagarSB Check below link u will get numerous methods for doing it.
Hi @SagarSB,
This will fix your case.
https://gallery.uipath.com/packages/FormatDoubleIntegerActivities/#others
Regards
Balamurugan.S
Can anyone show me this with we example ,
According to situation mentioned by me above
@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
if my input is 12000 then expected is 12,000.
and if 120000 then expected is 120,000.
@SagarSB Are you expecting dot at the end?
@Manjuts90
no
@SagarSB then below method will work for u.
for me this works (must be as a string)
string.format(“{0:n0}”, <variable.string>)
@SagarSB what problem u getting in above method
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.
@SagarSB if your value 1200000 then ur output must be 1,200,000 right?
no…
if 120000 then 120,000
@SagarSB i am getting that output from above method
Hi @SagarSB,
Here is the example with output.
Output :
Here is the activity
File : nn.zip (1.6 KB)
Regards
Balamurugan.S
Thank you so much i will try and let you know
what you have pass in Properties of activities
Hi @SagarSB,
Case-1
Format : “##,###”
GroupSeparator: “,”
Case-2
Format : “###,###”
GroupSeparator: “,”
Regards
Balamurugan.S