String - insert "0" and "."

Hi,

I have the datatable with string format and want to transform to the another datatable with string format as below:
image

I know we can use insert “0” and “.” but how can it work as expect for the data with “-” ? Please help me on this.

Thanks,
Tan.

Hi,

How about the following expression?

(Decimal.Parse(row("ColumnName").ToString)/1000000).ToString("0.000000")

Regards,

Thanks Yoichi, it worked as expectation.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.