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.
error with processing excel file
Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators
- DataMystic Support
- Site Admin
- Posts: 2227
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
Re: error with processing excel file
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
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
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.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