Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Exporting a file in fixed length as .txt format

Bitopi
7 - Meteor

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,

5 REPLIES 5
pankajk
10 - Fireball

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...

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
7 - Meteor

Hi, 

 

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

Bitopi
7 - Meteor

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

pankajk
10 - Fireball

Hi @Bitopi  - if you think this helped you solve your problem then you should consider this as 'solution' so that other users in the community can learn from 'marked solutions'....... let me know if you have any other questions.

Bitopi
7 - Meteor

yes,I have accepted as solution..

Labels