problem in awk command


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting problem in awk command
# 1  
Old 02-29-2008
problem in awk command

Hello all,

i am new one to this forum.
:[bash]

i have file with these contents..
internal://project/squid-internal-static/icons/anthony-xpm.gif
http://widget.blogrush.com/img/br.png
http://www.wingware.com/css/print
http://publib.boulder.ibm.com/infoce...terwarning.css
http://www.blogger.com/img/navbar/1/corner.gif
ftp://shan.org/pdg/asd/bin.jpg
ftp://pop.ces.co.uk/qwer/gft.js
.....................................................
....................................................
....................................................
....................................................

i try try print only the domains.Like

internal://project
http://widget.blogrush.com
Wingware Python IDE - The Intelligent Development Environment for Python Programmers
ftp://pop.ces.co.uk

My problem is every line start with differently.Like
http://, ftp:// ...

and end with .co.uk , .co.in , .com

i try awk command.

awk 'BEGIN{OFS=FS="/"} {print $1 $2}' filename

but o/p is

internal:
http:
ftp:
http:

Pls help me.
# 2  
Old 02-29-2008
Here is one possible solution:

Code:
sed -n -e 's|\(^.*://[a-z.-]*\)/.*|\1|p'  file

# 3  
Old 03-01-2008
Probably, all your problem are in forgetting to put back delimiter '/'
It works for me:
Code:
> cat > try.t
internal://project/squid-internal-static/icons/anthony-xpm.gif
http://widget.blogrush.com/img/br.png
http://www.wingware.com/css/print
http://publib.boulder.ibm.com/infoce...terwarning.css
http://www.blogger.com/img/navbar/1/corner.gif
ftp://shan.org/pdg/asd/bin.jpg
ftp://pop.ces.co.uk/qwer/gft.js
^C
>nawk -F/ '{ print $1"/"$2"/"$3; }' try.t
internal://project
http://widget.blogrush.com
http://www.wingware.com
http://publib.boulder.ibm.com
http://www.blogger.com
ftp://shan.org
ftp://pop.ces.co.uk

fpmurphy: your solution does not works for me some why.
Code:
>sed -n -e 's|\(^.*://[a-z.-]*\)/.*|\1|p' try.t
>

[/QUOTE]
The tag does not works. Whithout tag it works:
Code:
c> sed -n  's|^.*://[a-z.-]*/|lll_|p' try.t
lll_squid-internal-static/icons/anthony-xpm.gif
lll_img/br.png
lll_css/print
lll_infoce...terwarning.css
lll_img/navbar/1/corner.gif
lll_pdg/asd/bin.jpg
lll_qwer/gft.js
>
c> alias sed
bash: alias: `sed' not found
> which sed
/bin/sed

Any idea why?
# 4  
Old 03-03-2008
awk

I think this one is ok for you.

Code:
awk 'BEGIN{FS="/"}{print$1"/"$2"/"$3}' filename

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Execution Problem with awk command

Hi All, I am trying to find a word from a file in loop. while read i; do DB_Name=$i awk '{for(i=1;i<=NF;i++)if($i~/$DB_Name/)print $(i)}' $BTEQ_NAME > $DB_Name_TableList.txt done <Param.txt here Param.txt contents data as ODS_TARGT_RECV FIN_TARGT... (7 Replies)
Discussion started by: Shilpi Gupta
7 Replies

2. Shell Programming and Scripting

getting problem in awk command

Hi, I have one file with tab delimited values in it. i want to increase the value of 6th field by 2 if value of 3rd field is greater than 2 . The command is working fine but space between the field is getting removed after adding. below is the file and the command Filename: test1.txt ... (13 Replies)
Discussion started by: ravi_agarwalla
13 Replies

3. Shell Programming and Scripting

Problem with Variable and AWK command

Okay, so I am trying to use a count variable to reference the column of output sent from an echo statement. So I am trying to do this #!/bin/bash CURRENT=$PWD VAR=3 CHANGE=`echo $CURRENT | awk -F "/" '{ print \$$VAR }'` This instead of giving me the third instance after the "/" gives... (4 Replies)
Discussion started by: mkjp2011
4 Replies

4. Shell Programming and Scripting

Alias problem with awk command

Hi to all, I'm facing some problems when adding an alias like: #alias list="ls -al | awk '{ print $1, $2, $3, $4, (($5/1048576))"\t", $6, $7, $8, $9 }'" and when I enter: #list I get: Syntax Error The source line is 1. The error context is { print >>> , <<< awk:... (3 Replies)
Discussion started by: enux
3 Replies

5. UNIX for Dummies Questions & Answers

problem with awk command in script.

#!/bin/sh date=`date +%y%m%d -d"1 day ago"` inbound_dir=/vis/logfiles/to_solmis cp `grep -il ST~856~ $inbound_dir/*$date*` /vis/sumit/in_ASN/ echo 'SENDER,RECEIVER,DATE,TIME,ASNUMBER' > a.csv for i in /vis/sumit/in_ASN/* do ... (8 Replies)
Discussion started by: shrima.pratima
8 Replies

6. Shell Programming and Scripting

problem with awk command

I have written some code in a KSH script to find the index of the character in a string like this #!usr/bin/ksh string="Hi How are you" awk 'BEGIN {print index ($string, "are")}' My expected output should be : 8 but it is giving the out put as : 0 I wanted to store that index value in... (8 Replies)
Discussion started by: hemanth424
8 Replies

7. Shell Programming and Scripting

problem with awk command

I am having problem running an awk commad on a file Before applying awk command on the file After applying I don't expect more than 409743 records in the file. Why do I have 1 record more after applying awk command? Please let me know (4 Replies)
Discussion started by: dsravan
4 Replies

8. Shell Programming and Scripting

Problem in awk command

Hello, I am getting problem in awk command during matching (using if in awk) when there is special character "" I have tried by loosing the special meaning, still its not working Below is my code: set pinname_watch = "DCORRECT" set pinname = "DCORRECT\" echo 'defineGateSize... (2 Replies)
Discussion started by: nehashine
2 Replies

9. Shell Programming and Scripting

Problem with sub command (awk) and numbers

Hi, I am trying to perform a simple soustraction between two floating numbers and cannot get it done for some reason due to the use of the sub command. The following is the straight-forward result of the soustraction: $ echo | gawk '{a=968;b=967.99;c=a-b;print c}' ... (2 Replies)
Discussion started by: Indalecio
2 Replies

10. Post Here to Contact Site Administrators and Moderators

AWK command problem

How can I write an AWK so it could print some fixed strings and concatenate that with other words from an input file. Also having a string like "go" in the next line in the output file as below: Example: A fixed string like: "Hello my" and the input file is: friend mother father... (4 Replies)
Discussion started by: sybase08
4 Replies
Login or Register to Ask a Question