Skip to content
+1-888-319-3663

COMMUNITY FORUM

Fixed Width File Destination

marcb@progressive-solutions.com asked 9 years ago
Is there a way to output a map into a Fixed Width file format? 

I found the information on utilizing an ini file with an odbc source connection to do this, but that is not an option as a destination.  I've tried a few different attempts, but haven't found a way to accomplish this. 

Thanks for any guidance you can provide.
Answers
Best Answer
Chris Hanson answered 9 years ago
For the file destinations we allow tab delimited, csv, or excel as the main options. Fixed width isn't currently an option built into SmartConnect.

If one of the other options doesn't work you could use a script in the map to build the fixed width file, but you would have to code it all through one of our scripting tasks which would create the file and write the lines to it.

We have a KB article with some smaple scripts in it if you serach the knowledge base and one script is how to create a file through a script but it just covers csv creation so it would need to be modified for fixed width.

H
marcb@progressive-solutions.com replied 9 years ago

Thanks Chris.  That sounds like a viable option. 

I'm having trouble finding the KB article with the sample scripts you spoke of.  I found this one (http://www.eonesolutions.com.au/Support/Knowledge-Base/Knowledge-Base-Article.aspx?articleid=32) which describes what each of the sample scripts does but doesn't actually provide the scripts.

Can you provide a link to that KB article?

Thanks.

David replied 9 years ago

Mark,

We just switched websites, so the link is currently broken.  I will send the file directly to your email address. 


If you would like to submit an answer or comment, please sign in to the eOne portal.