I have 2 separate fields that I'n loading from a fixed length file. Both are numbers, and in the fixed length file we use leading zeroes.
The one field is 9 characters in length and the other is 15. I'm trying to load them in QV and turn them to numbers, dropping the zeroes, but this only wants to work for the 9-digit field. For the 15 digit field it returns NULL.
num(@42:50) as [No of Instalments], // this works fine and returns e.g. 12 from 000000012
num(@60:74) as [Total of Instalments, INT & Fees], // this doesn't work and returns NULL from 000000000123456
Solved! Go to Solution.