ETL and Data Integration tools - Modern ETL software for everyone

Visual Importer can easily load a value from a text file which looks like this, -1234.56, into a money field in SQL server. But it errors when the field has the sign trailing, like this, 1234.56-. Can you think of a way around this error?

Ron

Try these calculations

Iif(POS('-','1000-')>0,'-'+Replace('1000-','-',''),'XX')

Iif(POS('-',[FIELDNAME])>0,'-'+Replace('[FIELDNAME]','-',''),[FIELDNAME])

Mike