ETL and Data Integration tools - Modern ETL software for everyone

I have an import of a Foxpro db whoch works fine expect when it encounters -ve fields. These seem to fail consistently.

Expression is:

[PROBDFEE]+[PROBDCNS]+[PROBDRMB]+[PROBDRTG]+[PROUDRV1BD]

Data format is -3398.16

I’m not clear why this is happening, but to correct this I've had to convert to numerics with the following expression:

StringToNumber([PROBDFEE])+StringToNumber([PROBDCNS])+StringToNumber([PROBDRMB])+StringToNumber([PROBDRTG])+StringToNumber([PROUDRV1BD])

This becomes rather lengthy and not possible in all situations.

Can you please let me know if there is something else I should try.

Thanks
Joe

Hello.

Do you have null values for any of these fields?
[PROBDFEE]+[PROBDCNS]+[PROBDRMB]+[PROBDRTG]+[PROUDRV1BD]

Can you email us your dbf file please

John