![]() |
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| convert rows into columns | loperam | Shell Programming and Scripting | 2 | 12-01-2008 03:57 AM |
| how to convert columns to rows | suresh3566 | Shell Programming and Scripting | 6 | 11-04-2008 08:20 AM |
| Convert Columns to Rows in a File | chrismt | Shell Programming and Scripting | 3 | 09-18-2008 06:11 AM |
| shell script required to convert rows to columns | suresh3566 | Shell Programming and Scripting | 2 | 05-07-2008 05:25 AM |
| convert rows into column | cdfd123 | Shell Programming and Scripting | 3 | 01-11-2008 12:54 PM |
|
|
LinkBack | Thread Tools | Search this Thread |
Rating:
|
Display Modes |
|
||||
|
Script to convert rows to 1 record with delimter
I have a data file as follows. The 1st line of record starts with "<JOB" and the last line of record ends with "</JOB". There are multiple rows (62 -70) within <JOB and </JOB and it varies. There are multiple records in the file starting with <JOB and ending with </JOB.
Sample data: <JOB NAME=JOE DIZA AGE=52 DOB=110956 AAA=001 BBB=070 </JOB <JOB NAME=YEZDI RANG AGE=53 DOB=110955 AAA=001 DDD=070 </JOB I want the output to look like this with delimter '|' <JOB | NAME=JOE DIZA| AGE=52 | DOB=110956 |AAA=001|BBB=070|</JOB <JOB | NAME=YEZDI RANG| AGE=53 | DOB=110955 |AAA=001|DDD=070|</JOB Any help will be appreciated. |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|