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...
Show off your group to the world. Share a photo of your group with us.

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 #497 of 525 |
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

Fri Oct 3, 2003 4:33 pm

pdgfalmouth
Offline Offline
Send Email Send Email

Forward
Message #497 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