Help: How do I create a column of fixed width data?

[limshady411]

I have a column that combines the data of every row and delimates by a | .

Instead of deliminating by |, I want to make it fixed width depending on the field. Here is what I have for the delimited by |. Any ideas on how to code for the fixed width? For example, Column 1 a max of 1 character, Column 2 will be between 2-5, Column 3 will be 6-20, Column 4 will be 21-25, etc. If the data in the field is less than the total fixed amount (IE: column 3 goes to 10 and there is 10 left to reach 20), I need the void to be blanks and for column 4 to begin at 21. Here's what I have for the delimited code and it works. I just need the fixed part going now. Thanks much everyone!

Please Login or Register  to view this content.

My output looks like:

letter | year | name | address

So with the fixed width, it should be:

A2005Limshady 123 N Blah
1234567890123456789012345678

I hope this makes sense. Thanks again!

[limshady411]

What I'm trying to do is basically the inverse of the Data --> Text to Columns function. I hope this helps and you guys can help me. Thanks again!