|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help on email data file as excel from unix!! | sparan_peddu | Shell Programming and Scripting | 1 | 10-19-2008 03:08 AM |
| manipulate data with specific format | tonet | Shell Programming and Scripting | 5 | 04-25-2008 12:24 PM |
| how to read the data from an excel sheet and use those data as variable in the unix c | Anne Grace | UNIX for Advanced & Expert Users | 1 | 03-03-2008 07:21 AM |
| sed or other tool to manipulate data, including email addresses | manouche | Shell Programming and Scripting | 3 | 02-19-2008 05:53 PM |
| reading data from excel using shell script | tiger99 | Shell Programming and Scripting | 11 | 01-06-2008 01:35 AM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
11-26-2008
|
||||
|
||||
Excel data manipulate
All, I have the following format of data in a spreadsheet Code:
A 1
2
3
4
B 1
2
3
4
where 'A' is value of 'A1', '1 2 3 4' is value of cell B1, 'B' is value of cell A2, and '1 2 3 4' is value of cell B2. There are thousands of rows with such a data format in the spreadsheet. Is there any way which you can think where I can get this data in the followin format. Code:
A 1 A 2 A 3 A 4 B 1 B 2 B 3 B 4 I was thinking if I could convert the spreadsheet to a csv and do some manipulations using sheel script. The above is just an example format. the data in the cells in spreadsheet may be different. Regards, Rahul. |
| Bookmarks |
| Tags |
| shell script, shell scripting, unix scripting, unix scripting basics |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
