Code: Select all
'NORTH ' <> 'NORTH' Import issues CSV
If you're making CSV from Excel/Access, for example, its going to "properly" make the CSV.
But when I make an export from Magic, my data might be
Code: Select all
1,NORTH ,Tom
2,SOUTH ,Bill
If it was "proper" CSV, it would be
Code: Select all
1,"NORTH","Tom"
2,"SOUTH","Bill"
So I banged my head for an hour trying to find out why a simple test wasn't running the correct code:
If BO.Region='NORTH' THEN something <--- will fail using my data import. Mac version.
If you edit that field you will see its padded with 5 spaces. Removing them makes my test evaluate correctly.
Yes, if I was doing a "final" import after lots of testing, I could load my data into/out of Excel to make it Proper then I wouldn't have the issue.
PS _ Just found this in my logging output. I guess I have to go modify all my export routines to get these fields trimmed. Look at the last line.