03-01-2009
can I do something like this to add one more condition of checking if the 4th field is number or space or blank also:
awk -F, '$4 /^[]*||[0-9]*/' MYFILE >> OTHERFILE
I also want the other part i.e. I need to exclude all lines whose 4th field is space or blank or number:
MYFILE
a,b,c,d,e
a,b,c,2,r
c,d,f,,g
t,y,u, ,i
The new file should contain only first line. I tried using the below but I also get 3rd line
awk -F, '$4 /^ [A-Z]*/' MYFILE >> OTHERFILE
I need OTHERFILE to have only first record.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi, I have a file.....
1|3|4|5|6
1|3|4|4|5
now i ahave to search for value 4 in forth field and write that output to a file.
if i do grep 4 file1 both lines are coming to output.
can somebody help me building command.
thanks and regards
sandeep (4 Replies)
Discussion started by: mahabunta
4 Replies
2. Shell Programming and Scripting
Hello,
I have the following record in a text file, i would like modify some field:
1 - remove all space between ",", but the company name of word will not delete. Anyway, I can use the following statement to do it.
's/^ *//;s/ *, */,/g;s/ *$//' file
2. field #12, I need to modify to time... (11 Replies)
Discussion started by: happyv
11 Replies
3. Shell Programming and Scripting
Hello,
I have the following xml formatted file. I would like to get the newnumber field number and replace into customernumber for each record.
For example:
<XMLFORMAT>
<customernumberR11>9</customernumberR11>
... (12 Replies)
Discussion started by: happyv
12 Replies
4. Shell Programming and Scripting
Hi,
I am new to unix and am trying to do something below:
I have a pipe delimited file with millions of records. I need to replace the third column of the first record to the number of lines in the file. How can I do that.
Will appreciate any advice and help.
Thanks
Simi (3 Replies)
Discussion started by: simi28
3 Replies
5. Shell Programming and Scripting
Hi,
In my file, I have few records which are split across multiple lines.
File 1:
=====
james,\n
pre-auth completed,in patient,\n
Fac_Id:23451,ramson,Dallas
Expected is:
==========
james,pre-auth completed,in patient,Fac_Id:23451,ramson,Dallas (8 Replies)
Discussion started by: machomaddy
8 Replies
6. Shell Programming and Scripting
i have file A as below contents
---------------------------
Use descriptive thread titles when posting.
For example, do not post questions with subjects like
"Help Me!", "Urgent!!" or "Doubt".
For example, do not post questions
For example, do not deliminated.
output file as below:... (2 Replies)
Discussion started by: ANSHUMAN1983
2 Replies
7. Shell Programming and Scripting
Table
ACN|NAME|CITY|CTY|NO1|NO2
115|AKKK|ASH|IND|10|15
115|AKKK|ASH|IND|20|20
115|AKKK|ASH|IND|30|35
115|AKKK|ASH|IND|30|35
112|ABC|FL|USA|15|15
112|ABC|FL|USA|25|20
112|ABC|FL|USA|25|45
i have written shell script using cut command
and awk programming getting error correct it and add... (5 Replies)
Discussion started by: udhal
5 Replies
8. UNIX for Beginners Questions & Answers
Hi All,
I have a file like below. In the field 9 I am having 14,014,3,001/009 on the records. I want to convert the field to a three digit value. For example 14 should 014 , 3 should 003
11050;11001;;CREDITTRANC;5293218;NRATL;;;11095;;-1;14;3;29=0000;1.25... (5 Replies)
Discussion started by: arunkumar_mca
5 Replies
9. Shell Programming and Scripting
Each record coming with column names. I have to replace them in each record as shown below
TIME=20181219110000261|CHAN=FMBKHJBAAAADPCFNAAAAAABA|EVNT=SWIclst|VALU=Session FMBKHJBAAAADPCFNAAAAAABA started|SRC=NSS|UCPU=0|SCPU=0
Output should look like: ... (9 Replies)
Discussion started by: sudhakar1987
9 Replies
DIFF3(1) User Commands DIFF3(1)
NAME
diff3 - compare three files line by line
SYNOPSIS
diff3 [OPTION]... MYFILE OLDFILE YOURFILE
DESCRIPTION
Compare three files line by line.
-e --ed
Output unmerged changes from OLDFILE to YOURFILE into MYFILE.
-E --show-overlap
Output unmerged changes, bracketing conflicts.
-A --show-all
Output all changes, bracketing conflicts.
-x --overlap-only
Output overlapping changes.
-X Output overlapping changes, bracketing them.
-3 --easy-only
Output unmerged nonoverlapping changes.
-m --merge
Output merged file instead of ed script (default -A).
-L LABEL --label=LABEL
Use LABEL instead of file name.
-i Append `w' and `q' commands to ed scripts.
-a --text
Treat all files as text.
--strip-trailing-cr
Strip trailing carriage return on input.
-T --initial-tab
Make tabs line up by prepending a tab.
--diff-program=PROGRAM
Use PROGRAM to compare files.
-v --version
Output version info.
--help Output this help.
If a FILE is `-', read standard input. Exit status is 0 if successful, 1 if conflicts, 2 if trouble.
AUTHOR
Written by Randy Smith.
REPORTING BUGS
Report bugs to <bug-gnu-utils@gnu.org>.
COPYRIGHT
Copyright (C) 2007 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
SEE ALSO
The full documentation for diff3 is maintained as a Texinfo manual. If the info and diff3 programs are properly installed at your site,
the command
info diff
should give you access to the complete manual.
diffutils 2.8.7-cvs January 2008 DIFF3(1)