Need to remove empty commas

[sruthesanju (Sweety)]

If i get the input like this ina variable

,2019

Output should be 2019

Input2

2022,2023,2019

Output should be
2022,2023,2019

Input 3

2022,2023,2019,

Output should be
2022,2023,2019

Need to remove empty commas

[arjunshenoy]

Hi @sruthesanju

You can use the following:

strValue.trim(","c)

Here, strValue is the string variable in which the value is stored.

Edit: Verify the TRIM function

Hope this helps,
Best Regards.

[Anil_G (Anil Gorthi)]

@sruthesanju

You can use this

Str.TrimEnd(","c).TrimStart(","c)

Cheers

[Gvivek9889 (Vivek Gupta)]

Hi @sruthesanju

Please try this

yourStringVariable.TrimStart(",“c).TrimEnd(”,"c)

[Chirag_Shetty_Divakar (Chirag Shetty)]

Hey @sruthesanju
Hope this will help

String trim.zip (68.4 KB)

Cheers.

[Pavanraj_Shetty]

Hi @sruthesanju

Try this

Test.zip (2.7 KB)

Hope this might help you

[sruthesanju (Sweety)]

If my input is ,2019,2019

Output should be 2019,2019

But i am getting result as 2019,2019

[Chirag_Shetty_Divakar (Chirag Shetty)]

Hey @sruthesanju

Output should be 2019,2019

But i am getting result as 2019,2019

What is the difference in this can you specify its the same right ?

Do you mean you want to remove the comma in between also ?

[sruthesanju (Sweety)]

Yes between as commas need to remove

[Jithesh_R (Jithesh Karkera)]

Hey @sruthesanju ,
Just give a try to this

RemoveCommas.zip (1.7 KB)

Regards,

[Chirag_Shetty_Divakar (Chirag Shetty)]

Hey @sruthesanju
Is this what you want

You can use this.

Cheers.

[sruthesanju (Sweety)]

Getting error in opening the code can you share the pic of the code

[Jithesh_R (Jithesh Karkera)]

@sruthesanju
Check this

Regards,

[Anil_G (Anil Gorthi)]

@sruthesanju

Please try this

System.Text.RegularExpressions.Regex.Replace(str.Trim(","c),",{2,}",",")

cheers