|
|
|
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 |
| Format problem of text file | repinementer | Shell Programming and Scripting | 13 | 09-14-2009 04:38 AM |
| Changing the text file format | kavithakuttyk | Shell Programming and Scripting | 3 | 06-11-2009 01:07 PM |
| Format a text file | jhardy | Shell Programming and Scripting | 2 | 03-17-2009 02:32 PM |
| Conver Excel file to another format ( text) | ZINGARO | HP-UX | 6 | 07-23-2008 02:52 PM |
| write data into a text file in bold format | miltony | UNIX for Dummies Questions & Answers | 1 | 09-28-2005 08:21 AM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
10-27-2009
|
||||
|
||||
Content format in a text file
Hi, I need to format the content in a text file as below format. Can some one help me how to approach? Also whether is it possible to convert the output to excel in column wise? Present: Code:
============================================================================= Name: vinodh Status: active dateofjoin: 2009/09/25 14:31:43; course: csc school of computing science ============================================================================= Name: sam Status: notactive dateofjoin: 2009/09/25 14:31:43; course: csc school of computing science ============================================================================= Name: John Status: notactive dateofjoin: 2009/09/25 14:31:43; course: it ============================================================================= Required: Code:
Name: vinodh Status: active dateofjoin: 2009/09/25 14:31:43; course: csc school of computing science Name: sam Status: notactive dateofjoin: 2009/09/25 14:31:43; course: csc school of computing science Name: John Status: notactive dateofjoin: 2009/09/25 14:31:43; course: it Thanks |
|
10-30-2009
|
|||||
|
|||||
|
Not very compact but works on your example: Code:
awk '$1=$1' RS= infile| sed 's/ =\+ /\n/g; s/=\+ //g; s/ =\+//g' Name: vinodh Status: active dateofjoin: 2009/09/25 14:31:43; course: csc school of computing science Name: sam Status: notactive dateofjoin: 2009/09/25 14:31:43; course: csc school of computing science Name: John Status: notactive dateofjoin: 2009/09/25 14:31:43; course: it |
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
