error with processing excel file

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

yrakeshreddy
Posts: 4
Joined: Thu Dec 18, 2008 7:01 am

error with processing excel file

Postby yrakeshreddy » Thu Dec 18, 2008 7:05 am

I am a new user of Textpipe. How can I extract two columns from Excel to tab delimited text and add a " symbol to the end of each column ?

Thanks.

Rakesh.

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: error with processing excel file

Postby DataMystic Support » Mon Jan 05, 2009 8:59 am

Use Filters\Convert\Excel spreadsheets to text, then
Filters\Convert\CSV\CSV to Tab-delimited, then
Filters\Restrict\Delimited fields (CSV, Tab, Pipe, etc) and inside this:
Filters\Add\Left margin
Filters\Add\Right margin
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

mutu26
Posts: 1
Joined: Wed Jun 10, 2009 11:34 pm

Re: error with processing excel file

Postby mutu26 » Thu Jul 02, 2009 3:54 pm

DataMystic Support wrote:Use Filters\Convert\Excel spreadsheets to text, then
Filters\Convert\CSV\CSV to Tab-delimited, then
Filters\Restrict\Delimited fields (CSV, Tab, Pipe, etc) and inside this:
Filters\Add\Left margin
Filters\Add\Right margin

For solve problems with excel files there is-repair xlsx corrupt,it is free as far as I know and has many features,besides that utility helped me many times and I grateful for it,software can repair .xlsx even without touching your keyboard, just left click your mouse several times and all of your data will be recovered,automatically and attempts to repair xlsx corrupt, that was considered lost,recover maximum percents of your document manually, than the entire Excel workbook.


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Baidu [Spider] and 1 guest