Exporting a file in fixed length as .txt format

Hi All,

I have a file which contains name, address, date, store and a unique id in it. I want to export that file in fixed length as .txt format. I also have length specifications for the file which are as follows:

@001 id 9.
@012 date mmddyy10.
@025 source $10.
@040 name $100.
@145 slug $20.
@170 address $100.
@275 city $50.
@330 state $2.
@335 zip $10.
@350 plus4 $4.
@360 store $100.

I want the file to be exported as fixed length in .txt format whose lengths are specified as above. Can you please help me out?

Thanks in advance,

Accepted answers

pankajk

Hi @Bitopi - Please review the knowledge base article: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-read-in-fixed-width-files/ta-p/4332

I have used the 'flat' file trick a lot of times now to import fixed width text files successfully.

If you share a sample file, I can help show you how it works as well...... but the article is very useful

All comments

pankajk

Hi @Bitopi - Please review the knowledge base article: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-read-in-fixed-width-files/ta-p/4332

I have used the 'flat' file trick a lot of times now to import fixed width text files successfully.

If you share a sample file, I can help show you how it works as well...... but the article is very useful

Bitopi

Hi,

Thanks for sharing the article for reading fixed length files.but I need help on exporting the file in fixed length format.

Bitopi

Thank you for sharing the article. The article and the link for recommended discussions really helped me.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703