<SOLVED>I have excel file with few columns that contain "ÿ" character at the end of the field name. I can not see them in excel, but if I save it in CSV - I can.
When I try to import it it's giving me error:
Import didn't succeed, couldn't find followind fields: Line Count , Covered Days , etc.
As you can see there is a space after Field name. But even that I create a field in table with space in it, still have an error.
Is there any replace or trim option I can use in import file to be able to convert that CHR(152)? to something?
Thank you!
Replaced a line in import file:
fields(asp_count(fields)) = replace(trim(field), chr(160),"")