Importing data through fixed-width wizard

When importing data through fixed-width wizard, how will u distinguish between different columns if the file is of multiple lines terminated by a n character.
  • Interview Candidate
  • 4
  • 2211

Showing Answers 1 - 4 of 4 Answers

Motilal

  • Jun 30th, 2006
 

Ya.. Can anybody please give any suggestions?

I think the source file needed to be cleaned manually

  Was this answer useful?  Yes

sheeladere

  • Jan 4th, 2010
 

In the Fixed width file, the columns will be allotted with some specific length( fixed width), suppose your file contains 5 columns and total length of the file record is 100, then while defining the fixed width file, all the five columns will be spaned in this 100 record length. for ex. col1 will be from 1 to 15, col 2 will be from 16 to 40, and col3 will be from 41 to 80 etc... most of the times file will have something called as Fillers in between.

Columns are supposed to be in their pre-allotted space only, thats why its called Fixed Width.

Hope it helps!

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions