i am getting the following error. can you please help?
> awk '{sub( /^[^ \t]+[ \t]+/,""); print}' 21CP
+ awk {sub( /^[^ \t]+[ \t]+/,""); print} 21CP
awk: syntax error near line 1
awk: illegal statement near line 1
Use nawk or /usr/xpg4/bin/awk on Solaris.
Quote:
Originally Posted by sais
can you please explain the command ?
The sub command replaces the first field and the tabs or spaces after the first field with nothing ("").
^[^ \t]+ -> select one or more non spaces/tabs from the begin of the line
[ \t]+ -> select one or more spaces/tabs after the characters of the begin of the line
Hi,
I want to print certain fields from my data file depending on certain conditions. Somebody pls let me know how to send it to awk.
The command below is the one which I want to use in a shell script and this prints fine
cat ./datafile.dat | grep -i $SEARCH_STR | awk -F: '{ print $1 $2 $3... (5 Replies)
I'm hoping someone can help me on this. I have a data file that greatly simplified might look like this:
sec;src;dst;proto
421;10.10.10.1;10.10.10.2;tcp
426;10.10.10.3;10.10.10.4;udp
442;10.10.10.5;10.10.10.6;tcp
sec;src;fac;dst;proto
521;10.10.10.1;ab;10.10.10.2;tcp... (3 Replies)
I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want.
The vendor wants me to submit three fields to them. Field 1 is the studentid field,... (4 Replies)
Hello,
I have several files in the following format:
1*2,3,4,5
And I wish to only print the first three fields, including the special characters '*' and ','. I have used awk to print fields before, but I do not know how to do it to include the delimiters, and how you can do it with... (1 Reply)
Hi,
I'm looking for a clever way to print all columns of a matrix twice using a for loop and NF I think. So instead of
awk -F "," '{print $1 " " $1 " " $2 " " $2...}
I can do something like
awk -F "," '{for (i,i<=NF,i++) (print $i...
So I get something like
A1,A2,A3
B1,B2,B3... (2 Replies)
Hi experts,
I need to print the first field first then last two fields should come next and then i need to print rest of the fields.
Input :
a1,abc,jsd,fhf,fkk,b1,b2
a2,acb,dfg,ghj,b3,c4
a3,djf,wdjg,fkg,dff,ggk,d4,d5
Expected output:
a1,b1,b2,abc,jsd,fhf,fkk... (6 Replies)
Hi
I have a file as below
<field1> <field2> <field3> ... <field_num1> <field_num2>
Trying to sort based on difference of <field_num1> and <field_num2> in desceding order and print all fields.
I tried this and it doesn't sort on the difference field .. Appreciate your help.
cat... (9 Replies)
Hi Gurus,
I have following input file. I tried multiple awk combinations to print selected columns without success.
HEX ID Name ver FLRGT Start Time Total Shared End Date
----- -------- --- ------ ------------------------ -------------- -------... (4 Replies)
I apologize in advance, but I continue to have trouble searching for matches between two files and then printing portions of each to output in awk and would very much appreciate some help.
I have data as follows:
File1
PS012,002 PRQ 0 1 1 17 1 0 -1 3 2 1 2 -1 ... (7 Replies)
In the f1 file below I am trying to clean it up removing lines the have _tn_ in them. Next, removing the characters in $2 before the ninth /. Then I remove the ID_(digit- always 4). Finally, the charcters after and including the first _. It is curently doing most of it but the cut is removing $1... (5 Replies)