String - insert "0" and "."

Help Studio
, ,
#1

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.

#2

Hi,

How about the following expression?

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

Regards,

#3

Thanks Yoichi, it worked as expectation.

1 Like
#4

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