Page 1 of 1
error with processing excel file
Posted: Thu Dec 18, 2008 7:05 am
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.
Re: error with processing excel file
Posted: Mon Jan 05, 2009 8:59 am
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
Re: error with processing excel file
Posted: Thu Jul 02, 2009 3:54 pm
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.