UNIX for Advanced & Expert Users

Hey..

I'm writing a code to download some stuff from Informix database and put it on Xls. It works fine, but I have a problem fitting in a new requirement.

I have currently a file which has information like below.

f_name|Ronnie|Johnson|23.00|
f_sal|Ronnie|Jhonson|4000.00|
f_dept|Finance|Jr.Asst|23|

Now I need to insert a new column with a description corresponding to field name and that value needs to be inserted before it.

EmpName|f_name|Ronnie|Johnson|23.00|
EmpSalary|f_sal|Ronnie|Jhonson|4000.00|
EmpDept|f_dept|Finance|Jr.Asst|23|

I'm not sure of how to insert a value before a text moving the whole line to the right..

any thoughts please...

Try reeading the main page for join
IF you create a second file

Code:

EmpName|f_name
EmpSalary|f_sal
EmpDept|f_dept

you can join it to the first file. join creates a relation - in the database sense - almost like a join between two tables. Except it works per row - so if you have 30 lines in file1, then file2 needs 30 lines as well. If you want every line in the join to have a leading column

Hey..

I tried the way u told me .. I'm on AIX actually..

In the first file there are multiple entries of the field name.. like

f_name|Ronnie|Johnson|23.00|
f_name|xxxx|yyyy|000|
f_name|ssss|dddd|123|
f_sal|Ronnie|Jhonson|4000.00|
f_sal|xxxx|yyyy|000|
f_sal|ssss|dddd|123|
f_dept|Finance|Jr.Asst|23|

I created a second file like

f_name|EmpName
f_sal|EmpSalary
f_dept|EmpDept

and did a simple join after sorting both the files..
join file1 file2 > file3.

nothing happened. No error popped up an nothing is happening.. is AIX a problem..
i tried using "join -i" option but that is not available in AIX i guess.
the number of rows in the two files are obviously not the same

is there anyother way out ??

Did you read the man page for join on AIX?so, with this:

Code:

join -t\| -1 1 -2 1 -o 1.2,2.3,2.4 file2 file1

you get this:

Code:

EmpName|Johnson|23.00
EmpName|yyyy|000
EmpName|dddd|123
EmpSalary|Jhonson|4000.00
EmpSalary|yyyy|000
EmpSalary|dddd|123

...on AIX even

Works bud !!.. thanks much !