Number formating

[NiranjanK1]

Hello All,

I would like to update additional decimal for value inside the string how can I implement below logic.

Mismath(FORMATNUMBER(value,'###0.000000'))

How to implement same.

Regards,

Niranjan 

[ShankerV]

Hi @NiranjanK1 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @NiranjanK1 

Step 1: Input

Step 2: 

Step 3:

(\d+)(.\d+)

Step 4:

[RegExOut1]+PadRight([RegExOut2], 7, "0")

Many thanks

Shanker V

[NiranjanK1]

@ShankerV thank you for quick response.

Actually I have string and number in same field. If merge both string and number format is missing. Thank you 

[ShankerV]

Hi @NiranjanK1 

Can you please share the sample input and the output expected.

Thanks in advance.

[NiranjanK1]

@ShankerV Here is the example 

Input: Mismatch(FORMATNUMBER(value,'###0.000000')

Output:

Mismatch (500.032654)

This is how Output look

Regards,

Niranjan 

[Raj]

have you tried using "ToString(ToNumber([name of coumn containing original value]), "###0.000000")" to bring the value

Hope this help

[NiranjanK1]

@Raj I have tried but I'm not getting expected Output 

[binuacs]

@NiranjanK1 would you be providing the value for the [value] field you mentioned in the below example? May be in a tabular format

Input: Mismatch(FORMATNUMBER(value,'###0.000000')

[NiranjanK1]

@binuacs value is field name which is having numeric data. Mismatch is string data. But with both of details I want additional decimals for number. It's not working any suggestions how can I add additional decimals.  Thanks in advance