I have a seven digit numeric field with 2 decimal positions I am trying to load into. Some of my input data has more than two decimal characters. When I simply mapped the incoming data to the target field this resulted in those records with extra decimal characters being rejected with nothing loaded. I tried using Round([F2],-2), but that just resulted in loading a value of zero in every row. I tried a variety of combinations like multiplying by 100 rounding to the zeroeth power of 10 (gave me nulls in about half the fields and zero in the rest), or multiplying by 1.00 hoping that would result in the truncation (unchanged data) but haven't found anything that worked. The Round formula above is straight out of the documentation. I've thought about trying some numeric to string conversions with a replace command, the results of which would be converted back to a number, but I haven't been able to find any documentation on whether regular expressions are supported in the replace function. I really don't want to have to introduce a pre-load formatting of my data files, because the flexibility of handling data was why we bought VImp. Running Vimp 7.2.0, loading into SQL Server ver. 8 (I think), on a Windows 2003 server, with pipe delimited data files.
