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.
Solved! Go to Solution.
Guessing that your data looks like:
1,000.00
can you please show some sample data,
cheers,
mark
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
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
Hi @MarqueeCrew Mark!
I'll give it a go! Thank you 😃
@MarqueeCrew! It worked beautifully. Was it that I didn't take into account the comas?