Search the web
Sign In
New User? Sign Up
textpipe-discuss · TextPipe user discussion forum
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
EXCEL Text Generated Files   Message List  
Reply | Forward Message #502 of 525 |
RE: [textpipe-discuss] EXCEL Text Generated Files

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
Winner of SIA 2003 'Best Application' award
DataPipe - Swiss army knife for fixing database data
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 Files

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


Tue Dec 2, 2003 6:05 am

crystalsoftw...
Offline Offline
Send Email Send Email

Forward
Message #502 of 525 |
Expand Messages Author Sort by Date

I 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....
paul granger
pdgfalmouth
Offline Send Email
Dec 2, 2003
4:58 am

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...
Simon Carter, Crystal...
crystalsoftw...
Offline Send Email
Dec 2, 2003
6:08 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help