08-02-2009
Editing 1st or nth column
Hi,
I have a file whick is pipe delimited :
100| alpha| tabgo|watch| |||| 444444
| alpha| tabgo|watch| |||| 444444
| sweden |tabgo|watch| |||| 444444
| US| tabgo|watch| |||| 444444
100| factory| tabgo|watch| |||| 444444
| ABC| tabgo|watch| |||| 444444
| launch| tabgo|watch| |||| 444444
| Cam| tabgo|watch| |||| 444444
| Roger| tabgo|watch| |||| 444444
| Sixty| tabgo|watch| |||| 444444
The first line either has a space or a static value 100.
Need to know two things:
1) How to append a character/s say "XXX" in the second column?
Output expected:
100| alphaXX| tabgo|watch| |||| 444444
| alphaXX| tabgo|watch| |||| 444444
| swedenXX |tabgo|watch| |||| 444444
| USXX| tabgo|watch| |||| 444444
100| factoryXX| tabgo|watch| |||| 444444
| ABCXX| tabgo|watch| |||| 444444
| launchXX| tabgo|watch| |||| 444444
| CamXX| tabgo|watch| |||| 444444
| RogerXX| tabgo|watch| |||| 444444
| SixtyXX| tabgo|watch| |||| 444444
2) How to add space for the first column if there is no static value or already has a space
expected output:
100| alphaXX| tabgo|watch| |||| 444444
| alphaXX| tabgo|watch| |||| 444444
| swedenXX |tabgo|watch| |||| 444444
| USXX| tabgo|watch| |||| 444444
100| factoryXX| tabgo|watch| |||| 444444
| ABCXX| tabgo|watch| |||| 444444
| launchXX| tabgo|watch| |||| 444444
| CamXX| tabgo|watch| |||| 444444
| RogerXX| tabgo|watch| |||| 444444
| SixtyXX| tabgo|watch| |||| 444444
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi;
i have a file.txt and its 9th, 10th and 11th line lines are:
RbsLocalCell=S2C1 maxPortIP 4 (this is 9th line)
RbsLocalCell=S3C1 maxPortIP 4 (this is 10th line)
RbsLocalCell=S1C1 ... (11 Replies)
Discussion started by: gc_sw
11 Replies
2. Shell Programming and Scripting
Please help me how can I display every nth field present in a "|" delimited file.
Ex: If a have a file with data as a|b|c|d|e|f|g|h|k|l|m|n
I want to display every 3rd feild which means the output should be
c
f
k
n
Please help me. (1 Reply)
Discussion started by: ngkumar
1 Replies
3. Shell Programming and Scripting
I have an awk script to find the maximum value of the 2nd column of a 2 column datafile, but I need to find the top 5 maximum values of the 2nd column.
Here is the script that works for the maximum value.
awk 'BEGIN { subjectmax=$1 ; max=0} $2 >= max {subjectmax=$1 ; max=$2} END {print... (3 Replies)
Discussion started by: ncwxpanther
3 Replies
4. Shell Programming and Scripting
Is there an awk script that can easily perform the following operation?
I have a data file that is in the format of
1944-12,5.6
1945-01,9.8
1945-02,6.7
1945-03,9.3
1945-04,5.9
1945-05,0.7
1945-06,0.0
1945-07,0.0
1945-08,0.0
1945-09,0.0
1945-10,0.2
1945-11,10.5
1945-12,22.3... (3 Replies)
Discussion started by: ncwxpanther
3 Replies
5. Shell Programming and Scripting
Hi,
I need some unix command to replace the following thing.
cat test.dat
1234|test|8/19/2009|8/20/2009|test
1234|test|8/9/2009|8/21/2009|test
1234|test|8/1/2009|8/2/2009|test
after processing
1234|test|08/19/2009|08/20/2009|test
1234|test|08/09/2009|08/21/2009|test... (6 Replies)
Discussion started by: anshaa
6 Replies
6. Shell Programming and Scripting
Hi,
i need to remove mth and nth column from a csv file. here m and n is not a specific number. it is a variable
ex.
m=2
n=5
now i need to remove the 2nd and 5th line.. Please help how to do that.
Thanks!!! (18 Replies)
Discussion started by: zaq1xsw2
18 Replies
7. Shell Programming and Scripting
Hi Guys,
Need help with logic to break Column nth in a CSV file into two
for e.g
Refer below the second column as the nth column
"abcd","","type/beta-version"
need output in a following format
"abcd","/place/asia/india/mumbai","/product/sw/tomcat","type/beta-version"
... (5 Replies)
Discussion started by: awk-admirer
5 Replies
8. Shell Programming and Scripting
Hello Members,
Need your expert opinion how to tackle below.
I have an input file that looks like below:
USS|AWCC|AFGAW|93|70
USSAA|Roshan TDCA|AFGTD|93|72,79
ALB|Vodafone|ALBVF|355|69
ALGEE|Wataniya (Nedjma)|DZAWT|213|50,550
I like output file in below format:
... (7 Replies)
Discussion started by: umarsatti
7 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have a huge list of archives (.gz). Each archive is about 40MB. A file is generated every minute so if I want to analyze the data for 1 hour I get already 60 files for example.
These are text files, ';' separated, each line having about 300 fields (columns).
What I need to do is to... (11 Replies)
Discussion started by: Nenad
11 Replies
10. Shell Programming and Scripting
Hello All,
I am writing a shell script with following requirement:
1. I have one input file as below
CHE01,A,MSC,INO
CHE02,B,NST,INC
CHE03,C,STM,INP
2. In shell script I have predefined array as below:
Array1={A, B, C}
Array2= {U09, C04, A054} (6 Replies)
Discussion started by: angshuman
6 Replies
WATCH(1) Linux User's Manual WATCH(1)
NAME
watch - execute a program periodically, showing output fullscreen
SYNOPSIS
watch [-dhv] [-n <seconds>] [--differences[=cumulative]] [--help] [--interval=<seconds>] [--version] <command>
DESCRIPTION
watch runs command repeatedly, displaying its output (the first screenfull). This allows you to watch the program output change over time.
By default, the program is run every 2 seconds; use -n or --interval to specify a different interval.
The -d or --differences flag will highlight the differences between successive updates. The --cumulative option makes highlighting
"sticky", presenting a running display of all positions that have ever changed.
watch will run until interrupted.
NOTE
Note that command is given to "sh -c" which means that you may need to use extra quoting to get the desired effect.
Note that POSIX option processing is used (i.e., option processing stops at the first non-option argument). This means that flags after
command don't get interpreted by watch itself.
EXAMPLES
To watch for mail, you might do
watch -n 60 from
To watch the contents of a directory change, you could use
watch -d ls -l
If you're only interested in files owned by user joe, you might use
watch -d 'ls -l | fgrep joe'
To see the effects of quoting, try these out
watch echo $$
watch echo '$$'
watch echo "'"'$$'"'"
You can watch for your administrator to install the latest kernel with
watch uname -r
(Just kidding.)
BUGS
Upon terminal resize, the screen will not be correctly repainted until the next scheduled update. All --differences highlighting is lost
on that update as well.
Non-printing characters are stripped from program output. Use "cat -v" as part of the command pipeline if you want to see them.
AUTHORS
The original watch was written by Tony Rems <rembo@unisoft.com> in 1991, with mods and corrections by Francois Pinard. It was reworked and
new features added by Mike Coleman <mkc@acm.org> in 1999.
1999 Apr 3 WATCH(1)