Column Import - Fixed width file

[senthilt1]

Hi All,

I have a fixed width input record, am using column import to split that single column into 10 columns.

If my input data is having null and empty string for some columns, will column import split those (null/emptystring) values correctly according to the length?

Please help me on this.

Thanks,
Senthil P

[ray.wurlod]

Yes, provided you have specified accurately how NULL is represented in each of those fields. In fixed-width format they can not actually be empty or null - there will be something in that fixed width.