Output formatting prob.. guyz plz hlp

Shell Programming and Scripting
1

:)Hi guys,
I have written a script that returns 3 things of all the employees in my organisation. i.e. Name, Login time & log out time of each and every employee. It returns the output in pipe-delimited format. For your ref. sending a small sample

e.g.
Deepti|083032|174501
Anushka|081705|190003
Neeraj|082715|173200

After getting this output I copy it to excel and convert that pipe-delimited txt to normal excel format by using �Text-to-columns� option in excel.
Then I use MS Word's �Mail Merge� function to arrange n print it in a particular format. For your ref. sending a small sample

e.g. (After using MS word's �Mail Merge� option, the document which is ready to print looks something like this)

Name: Deepti

Login time: 083032

Log out time: 174501

Name: Anushka

Login time: 081705

Log out time: 190003

Name: Neeraj

Login time: 082715

Log out time: 173200

This format then I print on a �PIN Mailer� (Continuous stationary)
Now, what my problem is, as you can see, I have to do lot of manual work in this log printing process.
Can I in any way automate it? Like, something which I can incorporate in my script which is giving me that pipe-delimited format.
Can I get a txt document that can be ready to print?

Waiting for reply.
And thanx in advance

2

W/o error checking wrt fields or contents:

cat file | while read LINE; do LINE=(${LINE//|/ })
 echo -en "Name: ${LINE[0]}\nLogin time: ${LINE[1]}\nLog out time: ${LINE[2]}\n\n"
done
3

Something like http://www.unix.com/unix-dummies-questions-answers/19852-converting-horizontal-line-vertical-line.html

4

Dear unSpawn when i incorporated ur suggestion in scrypt and got an error msg

Error msg: test.sh: Syntax error at line 1 : `(' is not expected.

Line that i hv incorporated in my scrypt is
cat login.txt | while read LINE; do LINE=(${LINE//|/ })
echo -en "Name: ${LINE[0]}\nLogin time: ${LINE[1]}\nLog out time: ${LINE[2]}\n\n"
done

Plz help

5

Not using Bash? Try:

awk -F'|' '{print "Name:", $1, "\n", "Login time:", $2, "\n", "Log out time:", $3, "\n\n" }' inputfile
6

Hey Thanx unSpawn, Finally it worked.. few probs are there to incorporate ur suggestion in my original script but i can manage it...
Thanx a lot yaar
:b: all the best