how to use "cut" or "awk" or "sed" to remove a string


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting how to use "cut" or "awk" or "sed" to remove a string
# 1  
how to use "cut" or "awk" or "sed" to remove a string

logs:

[Sun Feb 12 10:36:20 2012] "/home/abc/public_html/index.php"
[Sun Feb 12 10:36:20 2012] "/home/abc/public_html/index.php"
[Sun Feb 12 10:36:20 2012] "/home/xyz/public_html/index.php"
[Sun Feb 12 10:36:21 2012] "/home/xyz/public_html/index.php"
[Sun Feb 12 10:36:21 2012] "/home/xyz/public_html/index.php"

how to use "cut" or "awk" or "sed" to get the following result:

[Sun Feb 12 10:36:20 2012] abc
[Sun Feb 12 10:36:20 2012] abc
[Sun Feb 12 10:36:20 2012] xyz
[Sun Feb 12 10:36:21 2012] xyz
[Sun Feb 12 10:36:21 2012] xyz
# 2  
Code:
nawk -F/ '{print $1$3}' log|tr -d \"

This User Gave Thanks to pandeesh For This Post:
# 3  
nice! it works.
# 4  
Code:
cat log | cut -d/ -f1,3 | tr -d \"/

Moderator's Comments:
Mod Comment How to use code tags when posting data and code samples.

Last edited by Franklin52; 02-12-2012 at 10:38 AM.. Reason: Please use code tags for data and code samples, thank you
# 5  
Quote:
Originally Posted by psychognite
cat log | cut -d/ -f1,3 | tr -d \"/
Thr better version of this might be replacing cat by input redirection < operator .
# 6  
One command:
Code:
awk -F'[/"]*' '{print $1$3}' log

# 7  
Hi

can you please explain the below part:
Code:
awk -F'[/"]*'

Thanks

---------- Post updated at 07:27 PM ---------- Previous update was at 07:05 PM ----------

Pure bash solution for interest:
Code:
pandeeswaran@ubuntu:~$ while read line; do line1=`echo $line|cut -d/ -f1,3|tr -d \"/`; echo $line1; done < log
[Sun Feb 12 10:36:20 2012] abc
[Sun Feb 12 10:36:20 2012] abc
[Sun Feb 12 10:36:20 2012] xyz
[Sun Feb 12 10:36:21 2012] xyz
[Sun Feb 12 10:36:21 2012] xyz

Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #241
Difficulty: Easy
In 1973, a transatlantic submarine fiber optic link connected the Norwegian Seismic Array (NORSAR) to the ARPANET, making Norway the first country outside the US to be connected to the network.
True or False?

9 More Discussions You Might Find Interesting

1. AIX

Apache 2.4 directory cannot display "Last modified" "Size" "Description"

Hi 2 all, i have had AIX 7.2 :/# /usr/IBMAHS/bin/apachectl -v Server version: Apache/2.4.12 (Unix) Server built: May 25 2015 04:58:27 :/#:/# /usr/IBMAHS/bin/apachectl -M Loaded Modules: core_module (static) so_module (static) http_module (static) mpm_worker_module (static) ... (3 Replies)
Discussion started by: penchev
3 Replies

2. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing... (1 Reply)
Discussion started by: jcdole
1 Replies

3. UNIX for Dummies Questions & Answers

Using "mailx" command to read "to" and "cc" email addreses from input file

How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address and column 3 contains “cc” e-mail address to include with same email. Sample input file, email.txt Below is an sample code where... (2 Replies)
Discussion started by: asjaiswal
2 Replies

4. Shell Programming and Scripting

grep with "[" and "]" and "dot" within the search string

Hello. Following recommendations for one of my threads, this is working perfectly : #!/bin/bash CNT=$( grep -c -e "some text 1" -e "some text 2" -e "some text 3" "/tmp/log_file.txt" ) Now I need a grep success for some thing like : #!/bin/bash CNT=$( grep -c -e "some text_1... (4 Replies)
Discussion started by: jcdole
4 Replies

5. Shell Programming and Scripting

Using sed to find text between a "string " and character ","

Hello everyone Sorry I have to add another sed question. I am searching a log file and need only the first 2 occurances of text which comes after (note the space) "string " and before a ",". I have tried sed -n 's/.*string \(*\),.*/\1/p' filewith some, but limited success. This gives out all... (10 Replies)
Discussion started by: haggismn
10 Replies

6. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

7. Shell Programming and Scripting

cat $como_file | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g'

hi All, cat file_name | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g' Can this be done by using sed or awk alone (4 Replies)
Discussion started by: harshakusam
4 Replies

8. Shell Programming and Scripting

help for saving vertical datas to horizontal with "awk" or "cut"

hi, i have a file having datas like that ./a.txt 12344 12345 12346 12347 ..... ..... ... i want to save this datas to another file like that ./b.txt 12344 12345 12346 12347 ... ... ... i think awk can make this but how? :) waiting for ur help. (3 Replies)
Discussion started by: mercury
3 Replies

9. UNIX for Dummies Questions & Answers

Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`"

Hi Friends, Can any of you explain me about the below line of code? mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'` Im not able to understand, what exactly it is doing :confused: Any help would be useful for me. Lokesha (4 Replies)
Discussion started by: Lokesha
4 Replies

Featured Tech Videos