Strip out the string


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Strip out the string
# 1  
Old 07-06-2010
Strip out the string

Code:
awk -F"\t" -vOFS="\t" '{print $1"\t-\t-","["$4,$5"]",$6,$7"\t-"$8"\t-\t-\t"$15}' file.tsv  >  output.tsv

Using the above command how to remove the string www.abc.com from the $7 value.
# 2  
Old 07-06-2010
Code:
gsub("www\.abc\.com","",$7)

# 3  
Old 07-07-2010
Code:
cat tab.tsv | awk -F"\t" '{print $6}'

will give the result
Code:
GET http://www.abc.com/tracker.js.php?b370 HTTP/1.1

How to remove the string "http://www.abc.com".

Last edited by pludi; 07-07-2010 at 03:20 AM.. Reason: code tags, please...
# 4  
Old 07-07-2010
Hi,
Code:
awk -F"\t" 'gsub ("http://www.abc.com","",$6)' tab.tsv

# 5  
Old 07-07-2010
Can you please tell me how to use inside

Code:
awk -F"\t" -vOFS="\t" '{print $1"\t-\t-","["$4,$5"]",'gsub ("http://www.abc.com","",$6)',$7"\t-"$8"\t-\t-\t"$15}' file.tsv  >  output.tsv

This doesnt work

Last edited by pludi; 07-07-2010 at 03:19 AM.. Reason: code tags, please...
# 6  
Old 07-07-2010
Hi,
Code:
awk -F"\t" -vOFS="\t" '{gsub ("http://www.abc.com","",$6);print $1"\t-\t-","["$4,$5"]",$6,$7"\t-"$8"\t-\t-\t"$15}' file.tsv > output.tsv

# 7  
Old 07-07-2010
If I have to make www.$var.com, it doesn't work

Code:
awk -F"\t" -vOFS="\t" '{gsub ("http://www.$var.com","",$6);print $1"\t-\t-","["$4,$5"]",$6,$7"\t-"$8"\t-\t-\t"$15}' file.tsv > output.tsv



---------- Post updated at 02:30 AM ---------- Previous update was at 01:51 AM ----------

Code:
#!/bin/bash
name='xyz'
echo $name
awk -F"\t" 'gsub ("http://articles.$name.com","",$6)' tmp.tsv

Why this $name is not read as a variable. How to make it as a variable

Last edited by Scott; 07-07-2010 at 04:47 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Strip leading and numbers from a string.

Hello I have two vars loaded with $VAR1="ISOMETHING103" $VAR2="COTHERTHING04" I need to: 1) Strip the first char. Could be sed 's/^.//' 2) The number has it's rules. If it has "hundreds", it needs to be striped. If it is just two digits it shouldn't. So, for VAR1 output should be... (7 Replies)
Discussion started by: tristezo2k
7 Replies

2. Shell Programming and Scripting

Strip First few Characters

I want to strip first few characters from each record until a proper datesamp is found. Request for getNextPage.................06/29/12 07:49:30 VVUKOVIC@67.208.166.131{7A805FEF76A62FCBB23EA78B5380EF95.tomcat1}TP-Processor14 LogExchUsage: ERROR:: isprof=false : exch=NSDQ output should be... (2 Replies)
Discussion started by: ratheeshjulk
2 Replies

3. Solaris

strip error

Hi I am getting the below error while using strip command. strip: libelf error. Request error: no string table strip: a.out: file not manipulated Could somebody please let me know what might be the solution?? It is in ksh and solaris 10. Thanks in advance (4 Replies)
Discussion started by: vali__
4 Replies

4. Shell Programming and Scripting

Strip a string in sh

I have a list of servers that I need my script to ping however this list also has the env they belong too such as SIT, PRD, warehouse and so on. The break character for each section is : A value in my list would look like this... brutus.grhq.xxx.com:warehouse Where brutus.grhq.gfs.com is... (13 Replies)
Discussion started by: LRoberts
13 Replies

5. Shell Programming and Scripting

How to strip out common terms in string

Hi, I have this kinda of data:- 0,0,0,0,1,2,0,4,5,6,7,foo 0,0,0,0,1,4,0,5,5,5,5,foo1 0,0,6,0,1,6,0,6,1,2,3,orange etc... I wanted to remove the 0 which occur on the same rows of foo,foo1 and orange in this case. Desired output is:- 0,1,2,4,5,6,7,foo 0,1,4,5,5,5,5,foo1... (9 Replies)
Discussion started by: ahjiefreak
9 Replies

6. Programming

Strip command

I am new in Unix. I go through the man strip. But did not understand that, why when we have -G (debug and release ) option in the compiler, than using strip command to strip the debug information from the objects. i want to binary for teh production i will compile it without debug option. What the... (4 Replies)
Discussion started by: Saurabh78
4 Replies

7. Shell Programming and Scripting

Need to strip a string

I have a file that looks like this: /home/fred/opt/bin /opt/usr/bin /usr/sbin/var/opt I need a way to chop of everything after the last occurance of the / sign including the /. So the file above will now look like this below. /home/fred/opt /opt/usr /usr/sbin/var I tried using... (6 Replies)
Discussion started by: x96riley3
6 Replies

8. Shell Programming and Scripting

Strip all non-alphanumerics

Hi, Can someone let me know how do I strip out any non-alphanumeric character in string tomake it alphanumeric? i.e abc def ghi ->abcdefghi abc-def-ghi ->abcdefghi abc#def-ghi->abcdefghi Thanks in advance (3 Replies)
Discussion started by: braindrain
3 Replies

9. Shell Programming and Scripting

How to strip strins

Guys, Please can someone tell me how to strip each string from the following ? TABLE1||METHOD||TYPE||STATUS||DATE What i need is to assign each value to the variable TABLE1 to var1 METHOD to var2 and so on If there is NULL in one of them, something like A||B||||C|| I want the... (14 Replies)
Discussion started by: kamathg
14 Replies
Login or Register to Ask a Question