Seperate String by comma seperator for amount values

[kavya.s16]

Hi everyone,

My Requirement is i have two columns both are of string datatype
1.Amount and 2.Final Amount in my datatable and there are currency values and i need to seperate them by comma

eg: 1000 should be 1,000
1000.99 should 1,000.99

I am using this expression
string.Format(System.Globalization.CultureInfo.GetCultureInfo(“en-IN”),“{0:n}”,Convert.ToDouble(amount))

but it give 1,000.00 for 1000

Note : it shouldn’t throw error for non numeric values
Any suggestions

@ppr @Yoichi @Palaniyappan

Thanks in advance

[THIRU_NANI (NaNi)]

Hey!

Try this

Assign strNumber = CurrentRow("Column Name").ToString.Trim

Assign strFinal = StrNumber.Sunstring(0,1)

StrFinal+","+StrNumber.Substring(1,)

Regards,
NaNi

[kavya.s16]

@THIRU_NANI but only 1000 the amount value can be anything
eg : 10000 should 10,000
or
1234567890 = 1,234,567,890

[sandeep_sonu (sandeep B)]

Hi @kavya.s16,

See below steps can help solving your issue

1. Convert String to Double
2. Use If condition to Validate if it is having decimals( Math.Truncate( AmountValue ) = AmountValue)
3. Based on the result use the expression
   for Decimal amount use intNum.ToString(“#,##0.00”)
   For Non Decimal amount use intNum.ToString(“#,##0”)

[kavya.s16]

@sandeep_sonu thank you!! , its working

[sandeep_sonu (sandeep B)]

@kavya.s16 , Your Welcome!
Please mark it as solution