Fixed width columns on the target file.

Shree0410 · Post by **Shree0410** » Mon Jul 17, 2006 1:11 pm

Hi, I have to create a target file with fixed width column, but each column has to be seperated by a comma(target system requirement).

If I check the 'Fixed-width column' box on the inputs/format tab, the delimiter and the quote character will disabled.

Can you suggest on how to get thru this .

Using the target file type as .csv will solve this?

Krazykoolrohit · Post by **Krazykoolrohit** » Mon Jul 17, 2006 1:14 pm

keep the delimiter as comma and use char instead of varchars.

Shree0410 · Post by **Shree0410** » Mon Jul 17, 2006 1:19 pm

does that make it fixed width columns?
Also, I do not want the quote character.

Krazykoolrohit · Post by **Krazykoolrohit** » Mon Jul 17, 2006 1:21 pm

no it will not make it a fixed width file but it will fix the length of your columns.

you can get rid of the quote character by typing 000 instead of quote

DSguru2B · Post by **DSguru2B** » Mon Jul 17, 2006 1:46 pm

Fixed width file and a delimitted file are two different formats. A fixed width cannot be delimitted and a delimitted cannot be fixed width. If you want the length of the columns from then source to be preserved and have a delimiter then do as Rohit suggested, but dont call it fixed width.

clshore · Post by **clshore** » Mon Jul 17, 2006 3:50 pm

Append a comma to each field except the last.
Redefine the width of each column by one.
Write them as fixed width.

Carter

ray.wurlod · Post by **ray.wurlod** » Mon Jul 17, 2006 5:10 pm

Define additional, intermediate Char(1) columns and set the value of each to ",". Generate imaginative names (like Filler1, Filler2, or Comma1, Comma2 and so on) for these columns.

In the Sequential File stage that writes the file, specify fixed-width format. Use the Display field in the Columns grid to specify the width of each column in the file.

kumar_s · Post by **kumar_s** » Tue Jul 18, 2006 3:06 am

Why do you want it in fixed width and comma delimted?