error with processing excel file

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

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

error with processing excel file

Post by yrakeshreddy »

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: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: error with processing excel file

Post by DataMystic Support »

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
mutu26
Posts: 1
Joined: Wed Jun 10, 2009 11:34 pm

Re: error with processing excel file

Post by mutu26 »

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.
Post Reply