|
|
|
|||||||
| Home | Forums | Register | Rules & FAQ | Members List | Arcade | 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 !! |
Other UNIX.COM Threads You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Script required to get a required info from file. Pls. help me. | ntgobinath | Shell Programming and Scripting | 2 | 05-31-2008 05:34 AM |
| Shell program:Help required on file formating | udiptya | UNIX for Dummies Questions & Answers | 6 | 02-04-2008 01:10 AM |
| formating array file output using perl | seismic_willy | Shell Programming and Scripting | 4 | 03-21-2007 10:23 PM |
| Formating mailx text file for Lotus Notes users | lidoiwo | Forum Support Area for Unregistered Users & Account Problems | 0 | 10-29-2005 08:45 AM |
| Formating text from a script into a log file | hugow | UNIX for Dummies Questions & Answers | 1 | 06-30-2005 01:01 AM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Search this Thread | Display Modes |
01-31-2008
|
|||
|
|||
Help required on file formating
I have two files file1 and file2 as shown below:
file1: name nameabc bcd nameabcdefg file2: age age1111 age2345 age6743 I have pasted one file on the other with the delimiter "|" and the resulttant file is: name|age nameabc|age1111 bcd|age2345 nameabcdefg|age6743 but I want it to be formatted like this: name |age nameabc |age1111 bcd |age2345 nameabcdefg |age6743 I tried it with "\t" but since the length of name can vary the number of tabs is not constant. Can anybody give a solution to this? 
|
| Forum Sponsor | ||
|
|
|
01-31-2008
|
||||
|
||||
|
After the combine, do a sed
I think you followed how to do the paste command.
The sed command is replacing the pipe with a space and a pipe symbol. > cat sfile1 name nameabc bcd nameabcdefg > cat sfile2 age age1111 age2345 age6743 > paste -d"|" sfile1 sfile2 | sed "s/|/ |/g" >sfile3 > cat sfile3 name |age nameabc |age1111 bcd |age2345 nameabcdefg |age6743
|
||||
| Google UNIX.COM |
Linear Mode
