Converting Long string (15 Chars) to numeric

Anonymous — Sat, 13 Oct 2012 05:13:37 GMT

I need to convert it from text to numeric. I tried everything with no success. This issue is linking this field one is char and the other is numeric.

Data Sample:

Re: Converting Long string (15 Chars) to numeric

swuehl — Sat, 13 Oct 2012 09:04:38 GMT

Yeah, I remember I ran into the same issue some time ago. Not very intuitive, but I think the solution was to use

LOAD

evaluate(FIELD) as FIELD,

...