| |||||||||||
| |||||||||||
Perl to export tab delimted file to Quattro Pro Posted by mparker1113 (mparker1113), 28 September 2006 Sounds obtuse, but it is true -- that is what we are looking to do. Anyone have an idea where I can start with this? (Much thanks) Posted by admin (Graham Ellis), 28 September 2006 Hello,What form is you data in at the moment? If it's in a space delimited file, then a piece of code like: open (FH,"input.txt"); open (FHO,"quattro.tab"); while ($line = <FH>) { @flds = split(/\s+/,$line); print FHO (join("\t",@flds),"\n"); } should do the trick. You may want to use "\r\n" in yoiur print if Quattro Pro's version of tab delimited files for imports need a cr, lf sequence, and you may need to modify it to surround the fields by quotes - these are things you'll find out in testing. Posted by mparker1113 (mparker1113), 28 September 2006 Thank you for the post, Graham. This is good news!I will probably be about a week before I get back to this, but your suggestion is a good start! -- Mike This page is a thread posted to the opentalk forum
at www.opentalk.org.uk and
archived here for reference. To jump to the archive index please
follow this link.
|
| ||||||||||
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho |