Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Exporting a file in fixed length as .txt format

Highlighted
6 - Meteoroid

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,

Highlighted
9 - Comet

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

Highlighted
6 - Meteoroid

Hi, 

 

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

Highlighted
6 - Meteoroid

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

Highlighted
9 - Comet

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.

Highlighted
6 - Meteoroid

yes,I have accepted as solution..

Labels