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.
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
Guessing that your data looks like:
1,000.00
can you please show some sample data,
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
