Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Remove characters from line

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Remove characters from line
# 1  
Old 02-12-2014
Remove characters from line
I have a the following line
Code:
22.152.25.36 - K##### [03/Jul/2013:18:05:00 -000] "GET /DGGKE/GetMail.do;jwebsphere=FADFFFGSFGSFGSDGFSDFGSDFGSDF HTTP/1.1" 200 44948

Need a cut command which should give me the below output
Code:
22.152.25.36 - K##### [03/Jul/2013:18:05:00 -000] "GET /DGGKE/GetMail.do HTTP/1.1" 200 44948

Note: The value of jwebsphere can be different for multiple entries
# 2  
Old 02-12-2014
What have you tried so far?
# 3  
Old 02-12-2014
Code:
cat file1.log | cut -f1 -d";jwebsphere" >> file2.log

but it seems i cannot use string for -d option.
Last edited by Scrutinizer; 02-12-2014 at 02:53 PM.. Reason: code tags
# 4  
Old 02-12-2014
Use sed instead:
Code:
sed 's#;[^ ]*##' file

# 5  
Old 02-14-2014
This way will also work
Code:
awk '{gsub(";jwebsphere=FADFFFGSFGSFGSDGFSDFGSDFGSDF","")}1' Sample

Last edited by Franklin52; 02-14-2014 at 04:52 AM.. Reason: Please use code tags
# 6  
Old 02-14-2014
Quote:
Originally Posted by 24ajay
Code:
awk '{gsub(";jwebsphere=FADFFFGSFGSFGSDGFSDFGSDFGSDF","")}1' Sample

This will work only if you ignore the last statement in the original post in this thread:
Quote:
Note: The value of jwebsphere can be different for multiple entries
# 7  
Old 02-14-2014
Quote:
Originally Posted by suindar1982
I have a the following line
Code:
22.152.25.36 - K##### [03/Jul/2013:18:05:00 -000] "GET /DGGKE/GetMail.do;jwebsphere=FADFFFGSFGSFGSDGFSDFGSDFGSDF HTTP/1.1" 200 44948

Need a cut command which should give me the below output
Code:
22.152.25.36 - K##### [03/Jul/2013:18:05:00 -000] "GET /DGGKE/GetMail.do HTTP/1.1" 200 44948

Note: The value of jwebsphere can be different for multiple entries
Code:
echo "22.152.25.36 - K##### [03/Jul/2013:18:05:00 -000] GET /DGGKE/GetMail.do;jwebsphere=FADFFFGSFGSFGSDGFSDFGSDFGSDF HTTP/1.1 200 44948" | sed 's/;[^ ]*//'

output
Code:
22.152.25.36 - K##### [03/Jul/2013:18:05:00 -000] GET /DGGKE/GetMail.do HTTP/1.1 200 44948

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove first 2 characters and last two characters of each line

here's what im trying to do. i have a file containing lines similar to this: data.txt: 1hsRmRsbHRiSFZNTTA1dlEyMWFkbU5wUW5CSlIyeDFTVU5SYjJOSFRuWmpia0ZuWXpKV2FHTnRU 1lKUnpWMldrZFZaMG95V25oYQpSelEyWTBka2QyRklhSHBrUjA1b1kwUkJkd3BOVXpWM1lVaG5k... (5 Replies)
Discussion started by: SkySmart
5 Replies

2. Shell Programming and Scripting

Ksh: Read line parse characters into variable and remove the line if the date is older than 50 days

I have a test file with the following format, It contains the username_date when the user was locked from the database. $ cat lockedusers.txt TEST1_21062016 TEST2_02122015 TEST3_01032016 TEST4_01042016 I'm writing a ksh script and faced with this difficult scenario for my... (11 Replies)
Discussion started by: humble_learner
11 Replies

3. Shell Programming and Scripting

I want to remove 1st and last two characters of each line of the file

I want to remove 1st and last two characters of each line of the file Ex: file1 zzfile1ee @xfile2:y qfile3>> @ file4yy and redirect to the file called new Basically file will have any charcter including space, spical character... Please help.... (7 Replies)
Discussion started by: shell1509
7 Replies

4. Shell Programming and Scripting

remove first few characters from each line

Hi, I have a file with lines like below. I need to remove first few characters from each line until a date format is found. 05/06/12 20:47:02 GUMGUY@98.192.174.74{42B42A72AC955F5926621273E3A15059.tomcat2}TP-Processor15 LogExchUsage: ERROR: 05/06/12 20:47:02... (8 Replies)
Discussion started by: ratheeshjulk
8 Replies

5. UNIX Desktop Questions & Answers

Remove new line characters from a file

I tried using below command tr -cd "" < InputFile.xml > output.txt ============= This removes all the tabs/newline/extra spaces from a file it successfully removed all the extra spaces,tabs and new line characters but then the complete file become one record. I want to retain one new line... (1 Reply)
Discussion started by: saini
1 Replies

6. UNIX for Advanced & Expert Users

Remove new line characters if found between 1 to 10 columns

Hi, I have a file with ';' delimeter which has some new line characters. How can I delete the new line characters if they are found between 1 to 10 fields. Thanks (3 Replies)
Discussion started by: rudoraj
3 Replies

7. Shell Programming and Scripting

How to remove special characters from each line?

Hello, Is there a simpler way to remove special characters (color codes) from each lines in a log file? I use sed like in the example below but I think there should be a more simple way to achieve the same result: $ cat -vet file1 ^, , , , Maybe to convert the file somehow? ... (5 Replies)
Discussion started by: majormark
5 Replies

8. UNIX for Dummies Questions & Answers

remove characters from line

Hello, I have multiple lines in a file, each of which will have data that looks like this: xxxxxyyyyzzzz4abcdXYZXYZXYZ pqrstPQRST2cdPQRSTPQRST lmnopqr6abcdefgRST.3abc I want to be able to remove the number 4 + the following 4 characters (abcd) in the first line. For the second line,... (1 Reply)
Discussion started by: Gussifinknottle
1 Replies

9. Shell Programming and Scripting

sed remove last 10 characters of a line start from 3rd line

hello experts, I need a sed command that remove last 10 characters of a line start from 3rd line. any suggestions? Thanks you (7 Replies)
Discussion started by: minifish
7 Replies

10. UNIX for Advanced & Expert Users

how to remove line greater then 3000 characters.

I am using awk and it stops when it encounter line greater then 3000 character. Is there any command which will help me remove line greater then 3000 characters. (10 Replies)
Discussion started by: naren_14
10 Replies
Login or Register to Ask a Question