How do I convert a string field to numeric ? [ ex .- "$0.01M" to "0.01"]

[#1]

I have a Payment field having values like "$0.01M" . I want it in numeric form "0.01". What is the best way to do that ?

Thnks .

[Anonymous]

you can use substring()

[arulsettu]

if you want only numeric values try this

KeepChar('$0.01M','.0123456789')

[Anonymous]

try:

=mid(FieldName,2,len(FieldName)-1) as NewField

[settu_periasamy]

Hi,

May be try this..

=Num(Num#('$0.01M','$#.##M'),'#.##')

[Anonymous]

it will skip: $ sign as we are picking from 2 position

will skip M symbol as well as we are fetching till len(Field)-1

[Kushal_Chawda]

try

TextBetween(Payment field,'$','M') as Number

[himanshi]

hiii,

you can also try numbers tab in chart properties.here you have options,you can choose the format as you want.

Regards,

Himanshi Dubey