I have an Excel file with mostly numeric data but '<< entered where I'd like to have zeros. Ordinarily I'd use an if statement to convert that value to zero, but I can't enclose it in single quote marks because it already begins with a single quote. Is there an alternative delimiter I can use in the load script?
(I've actually solved the problem by reading the left(fieldname,2) which avoids the issue. But I'm still curious if there's a way to solve the problem.)
