06-23-2008
Output formatting problem..Plz hlp
Hi guys,
It will be a great help if somebody can help me in following problem.
I have tried hard but because of lack of UNIX/LINUX knowledge I am not able to do it.
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
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
ftp://metalab.unc.edu/pub/Linux/distributions/
Hi all ,
I know how to go to the distibution site but How to download if using ftp I want to ask this Q:confused: (3 Replies)
Discussion started by: atiato
3 Replies
2. UNIX for Dummies Questions & Answers
How to connect to the Internet Using RH 7.2 i.e configuration plz Hlp.....cause I want to accsses to the Internet to download Help and application in the Red hat OS???? (1 Reply)
Discussion started by: atiato
1 Replies
3. UNIX for Dummies Questions & Answers
i.e configuration of C compiler :confused: (4 Replies)
Discussion started by: atiato
4 Replies
4. UNIX for Dummies Questions & Answers
tr "" "" | sort | awk 'length($0)>0' | uniq -c (1 Reply)
Discussion started by: brain_full
1 Replies
5. Shell Programming and Scripting
:)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... (5 Replies)
Discussion started by: anushree.a
5 Replies
6. Shell Programming and Scripting
I would like to keep the complete lines in the output, but my script adds carriage returns for each space (e.g. keep BRITISH AIRWAYS on one line in the output):
File1=
BAW
BRITISH AIRWAYS
RYR
RYAN AIR
for i in $(cat File1)
do
echo $i
done
Output:
BAW
BRITISH
AIRWAYS
RYR... (4 Replies)
Discussion started by: barny
4 Replies
7. Shell Programming and Scripting
Hi all........
Plss do help me.......in a big trouble... :wall::wall::wall:
I have 3 directories named as :1. /home/shuchi/source
2./home/shuchi/destination
3./home/shuchi/filter
now the problem is /home/shuchi/source has say 2 files with extension .txt as given below :
A.txt
Code:
... (0 Replies)
Discussion started by: ektubbe
0 Replies
8. Shell Programming and Scripting
Hi Guys..
Need your help to format the output of my shell script.
I am using spool command to take out put in csv file.
below is my code. (for example)
col USERNAME for a15
col EMAIL for a30
col FULL_NAME for a20
col LAST_LOGIN for a40
col DATE_CREATED for a40
SPOOL 120.csv... (3 Replies)
Discussion started by: Agupte
3 Replies
9. Shell Programming and Scripting
Hello;
I have a simple loop filtering a log:
for LU in $(< LU-list-Final)
do
OUT=$(grep -B1 $LU cibc-src-ip.cap |egrep 'IP 16|IP 19|IP 15' |awk -F">" '{print $1}')
if ; then
echo " LU $LU was accessed by ===============> $OUT "
echo ""
fi
done
The current output snippet looks like... (2 Replies)
Discussion started by: delphys
2 Replies
10. Shell Programming and Scripting
I have a file like this :
! 1 ! 542255 ! 50,140.00 !
! 2 ! 551717 ! 5,805.00 !
! 3 ! 551763 ! 8,130.00 !
! 4 ! 551779 ! 750.00 !
! 5 ! 551810 ! 56,580.00 !
! 6 ! 551816 ! 1,350.00 !
! 7 ! 551876 ! 360.00 !
! 8 ! 551898 ! ... (10 Replies)
Discussion started by: adam1969in
10 Replies
LEARN ABOUT CENTOS
script
SCRIPT(1) User Commands SCRIPT(1)
NAME
script - make typescript of terminal session
SYNOPSIS
script [options] [file]
DESCRIPTION
script makes a typescript of everything printed on your terminal. It is useful for students who need a hardcopy record of an interactive
session as proof of an assignment, as the typescript file can be printed out later with lpr(1).
If the argument file is given, script saves all dialogue in file. If no file name is given, the typescript is saved in the file type-
script.
OPTIONS
-a, --append
Append the output to file or typescript, retaining the prior contents.
-c, --command command
Run the command rather than an interactive shell. This makes it easy for a script to capture the output of a program that behaves
differently when its stdout is not a tty.
-e, --return
Return the exit code of the child process. Uses the same format as bash termination on signal termination exit code is 128+n.
-f, --flush
Flush output after each write. This is nice for telecooperation: one person does `mkfifo foo; script -f foo', and another can
supervise real-time what is being done using `cat foo'.
--force
Allow the default output destination, i.e. the typescript file, to be a hard or symbolic link. The command will follow a symbolic
link.
-q, --quiet
Be quiet.
-t, --timing[=file]
Output timing data to standard error, or to file when given. This data contains two fields, separated by a space. The first field
indicates how much time elapsed since the previous output. The second field indicates how many characters were output this time.
This information can be used to replay typescripts with realistic typing and output delays.
-V, --version
Output version information and exit.
-h, --help
Output help and exit.
NOTES
The script ends when the forked shell exits (a control-D to exit the Bourne shell (sh(1)), and exit, logout or control-d (if ignoreeof is
not set) for the C-shell, csh(1)).
Certain interactive commands, such as vi(1), create garbage in the typescript file. Script works best with commands that do not manipulate
the screen, the results are meant to emulate a hardcopy terminal.
ENVIRONMENT
The following environment variable is utilized by script:
SHELL If the variable SHELL exists, the shell forked by script will be that shell. If SHELL is not set, the Bourne shell is assumed.
(Most shells set this variable automatically).
SEE ALSO
csh(1) (for the history mechanism), scriptreplay(1).
HISTORY
The script command appeared in 3.0BSD.
BUGS
Script places everything in the log file, including linefeeds and backspaces. This is not what the naive user expects.
AVAILABILITY
The script command is part of the util-linux package and is available from Linux Kernel Archive <ftp://ftp.kernel.org/pub/linux/utils/util-
linux/>.
util-linux September 2011 SCRIPT(1)