Hello, i am trying to add comma on a column and it has text as the end. how can i add comma to it. current output F1F24387521342344676769879812323436756757Total Sum689789 Expected Output F1F243,875.002,134,234.0046,767.00698,798.001,232,343.006,756,757.00Total Sum7,689,789.00 i also tried Toround, ToString and when i change column to double from string then i last line become Null from Total Sum.

Adding comma with text

Hello,

i am trying to add comma on a column and it has text as the end. how can i add comma to it.

current output

Expected Output

i also tried Toround, ToString and when i change column to double from string then i last line become Null from Total Sum.

Developer

@kauser
I did not consider the decimal number since it was not in your sample.
maybe we can do something like this.

@kauser
I just learned recently that we can add thousand seperator with ToString function.

Thanks for your advice. its work but if there is decimal number then it wont work. can you please help to on input data below there data have decimal

@kauser
I did not consider the decimal number since it was not in your sample.
maybe we can do something like this.