Hi Paul,
If you output using, say, a tab format, you can then use a Restrict to Tab Fields filter with a sub filter of a Pad to Width filter to force each field to the required width.
Regards,
Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888 3104 (GMT+10 hours)
TextPipe Pro - Industrial strength text transformation workbench
Simon Carter, Crystal Software, www.crystalsoftware.com.au, (+61) 3 9888 3104 (GMT+10 hours)
TextPipe Pro - Industrial strength text transformation workbench
Winner of SIA 2003 'Best Application' award
DataPipe - Swiss army knife for fixing database data
www.downloadpipe.com.au - Australia's largest download site
www.downloadpipe.com.au - Australia's largest download site
-----Original Message-----
From: paul granger [mailto:pdgfalmouth@...]
Sent: Saturday, 4 October 2003 2:33 AM
To: textpipe-discuss@yahoogroups.com
Subject: [textpipe-discuss] EXCEL Text Generated FilesI am trying textpipe on a trial basis. I need something that can take an EXCEL spreadsheet and write it out in a text format that retains the field spacing. For example; when I have a 40 byte description field that contains only 15 characters I need it to maintain the full 40 bytes and not start the next field after the 15th character. I'm moving the text file onto a mainframe and need to have fixed lenght fields for processing on the mainframe. Seems like textpipe should handle that, not sure if it actually can and what product I would need to use to do that function. Anyhelp pointing me in the right direction would be appreciated. Thanks
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
This is the TextPipe Pro discussion group.
To unsubscribe from this group, please send a blank email to:
textpipe-discuss-unsubscribe@yahoogroups.com
For frequently asked questions, please see the TextPipe Pro FAQ and viewlets at
http://www.crystalsoftware.com.au/textpipe/faq.html
To search previously asked questions, please use the search facilities at
http://groups.yahoo.com/group/textpipe-discuss/messages
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.