Using ToNumber to convert string to number is returning NULLs

[sonseeahray]

I'm baffled...I'm using ToNumber to convert 2 string fields to numbers from a .txt file, but the results are returning 100% NULL. I've used this formula on .txt input files just this week, so I don't understand what is happening.

[MarqueeCrew]

Guessing that your data looks like:

1,000.00

 can you please show some sample data,

 cheers,

 mark

[sonseeahray]

Hi @MarqueeCrew Mark!

Yes, of course and sorry.

The fields are coming in with leading spaces, so I clean that up before I apply the formula.

Here is the segment of the workflow that I'm at...

And...the results now are ZEROs rather than NULLs...at this point I don't remember what I did to get the NULLS

[MarqueeCrew · Accepted solution]

Ok!

ReplaceChar([_CurrentField_],"$,",'')

 User this in a multi-field formula. 
change type to Double

rename or don't rename field ( I uncheck)

 this should help. 

cheers,

 mark

[sonseeahray]

Hi @MarqueeCrew Mark!

I'll give it a go! Thank you 😃

[sonseeahray]

@MarqueeCrew! It worked beautifully. Was it that I didn't take into account the comas?