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
# 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 #910
Difficulty: Easy
In C, you can declare a pointer as follows: data_type * pointer_variable_name;
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