Hi,
I have an excel as Input file. The cells in excel has apostrophe before the number or text.
After executing BODS job, the data in the table is null for these fields. Please let us know how to fix this issue.
Following is the excel error: 'The number in the cell is formatted as text or preceded by apostrophe'
Thanks,
Kranthi