04-02-2008
Output format - comparison with I/p file
Hi,
I have a file which contains more than 1 lakh records like following:
a. name, id, city, state, country, phone (Expected I/P file format)
name, id, city,, state, country, phone (Current I/P file format )
I want to achieve following tasks,
a, Remove the extra comma in the City field.
b, Add / Remove extra string in the id field (eg. if id is 5001 I want to add 0 in the beginning, ie, 05001 / in some case, if id is 0123 remove 0 from the beginning ie, 123.
Please advice.
Thanks and Regards,
Vel
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hello all
Script and example of file
#!/bin/sh
#sh gdata.sh /users/testsuite/db/appl/
DATE=`date '+20%y-%m-%d'`
echo $DATE
for i in ${1}/$DATE/* ; do
find $i -name daily -prune -o -name run.log -print -exec grep -c ! {} \; done > test.log.
The test.log contains output like this ... (9 Replies)
Discussion started by: getdpg
9 Replies
2. Shell Programming and Scripting
hi ,
i need to format the output which is availble in a file
file output is
Following are the Process_Scheduler Domains running in the server Ram-pc
VPORCL
Following are the Application Server domains running in the server Ram-pc
VPORCL01
VPORCL02
these value VPORCL,VPORCL01...... (5 Replies)
Discussion started by: becksram123
5 Replies
3. Shell Programming and Scripting
Hi,
I am trying to put a script together that allows for a command to be executed and then the output goes to a .html file. I am running the script on HPUX.
I run:
/var/fl/user/lmutil lmstat -a -c license_lic.dat > /web/results.html
This saves the command to a .html file but the text is... (1 Reply)
Discussion started by: zerbitated
1 Replies
4. Shell Programming and Scripting
I have a file which has following contents
usmtnz-dinfsi19
62
61
18400
18800
99.7
usmtnz-dinfsi19
62
61
18400
18800
99.7
i want the o/p to be like
date (7 Replies)
Discussion started by: fugitive
7 Replies
5. Shell Programming and Scripting
Hi,
I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format.
Example:
File.txt
AP|{SSHA}VEEg42CNCghUnGhCVg==
APVG3|{SSHA}XK|"password"
AP3|{SSHA}XK|"This is test"
....
etc
---------
test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies
6. Shell Programming and Scripting
hi
i need some help over here.. please help
i have a log file as per below
---------------------------------------------------------------------------------------------------------
JOB START DATE : 20110510204513
JOB ID : us2cap3ds9... (6 Replies)
Discussion started by: sitaldip
6 Replies
7. Shell Programming and Scripting
Hello,
I couldn't find anything on the Forum that would help me to solve this problem. Could any body help me process below data using awk?
I have got two files:
file1:
Worker1: Thomas
Position: Manager
Department: Sales
Salary: $5,000
Worker2: Jason
Position: ... (5 Replies)
Discussion started by: killerbee
5 Replies
8. Shell Programming and Scripting
i have file as
FileD
funny mou1
funny mou2
raspe mou4
damn mou1
this file is a csv with /t.
i want to find all values with the first column of this file in fileB and then check for in that line if the second column vvalues are present or not .
for eg... (4 Replies)
Discussion started by: rajniman
4 Replies
9. Shell Programming and Scripting
Hi Friends,
I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving...
File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies
10. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
LEARN ABOUT DEBIAN
flowtop
flowtop(8) netsniff-ng-toolkit flowtop(8)
NAME
flowtop - provide top-like netfilter connection tracking information
SYNOPSIS
flowtop [--city-db <path>][--country-db <path>] [-T|--tcp][-U|--udp][-v|--version][-h|--help]
DESCRIPTION
flowtop is a tiny tool to print human-readable netfilter connection tracking information.
EXAMPLES
flowtop
Show only TCP flows
flowtop --udp
Show only UDP flows
flowtop --city-db /usr/share/GeoIP/GeoIPCity.dat
Use the specified GeoIP city database
flowtop --country-db /usr/share/GeoIP/GeoIP.dat
Use the specified GeoIP country database
OPTIONS
-T|--tcp
Only show TCP flows (default)
-U|--udp
Only show UDP flows
-s|--show-src
Also include flow source in top output
--city-db
Path to GeoIP city database
--country-db
Path to GeoIP country database
-v|--version
Print version.
-h|--help
Print help text and lists all options.
AUTHOR
Written by Daniel Borkmann <daniel@netsniff-ng.org>
DOCUMENTATION
Documentation by Emmanuel Roullit <emmanuel@netsniff-ng.org>
BUGS
Please report bugs to <bugs@netsniff-ng.org>
2012-06-29 flowtop(8)