Reading alpha vs numerics?
You don’t say what your source is so I’ll take a stab at both Text and Excel.
If it is a text file the type is determined by a schema file. So you will want to set that column to Char in the schema, and maybe set the MaxScanRows to a larger number by opening the Schema.ini.
In Excel, If formatting the cells isn’t allowing it to pick up the correct type you will have to change the number of rows scanned in the Registry. This article walks through the steps.
I’m sorry – missed that detail. It’s a csv file. Do I create a schema.ini in the template folder or the source folder? Thanks.
you’d use the schema button in SC for the template which would then modify the schema.ini in the template folder for you. what ends up happening is the template schema.ini is what is used to create the source folder schema.ini on the fly as the files are processed.
Thanks Patrick! I’ll try that.
If you would like to submit an answer or comment, please sign in to the eOne portal.