07-26-2007
How to delete dynamic pattern
Dear Alll
I have 16 columns,in my data file.In my 16th column i m getting unwanted data like /186.how to remove it.The value in 16th column is dynamic.
Data:
-----
25|1059530000|9305282846|355780600|100|1|0|4:UPE0|241|1|4121|2|0|100|100|14655/186
25|1059530001|9305282847|355780670|100|2|0|4:UPE0|241|1|4121|2|0|100|100|14655/184
8728|2040701618|9358642959|332661308|100|0|0|4:UPW0|243|1|4616|2|0|100|100|0/0
8728|2040701617|9358642958|332661253|100|2|0|4:UPW0|243|1|4616|2|2|100|100|14655/191
Thus i want to remove those Bolded data from the line.My output should be as follows.
25|1059530000|9305282846|355780600|100|1|0|4:UPE0|241|1|4121|2|0|100|100|14655
25|1059530001|9305282847|355780670|100|2|0|4:UPE0|241|1|4121|2|0|100|100|14655
8728|2040701618|9358642959|332661308|100|0|0|4:UPW0|243|1|4616|2|0|100|100|0
8728|2040701617|9358642958|332661253|100|2|0|4:UPW0|243|1|4616|2|2|100|100|14655
can i do this in sed or awk.The error is only in 16th column.records to be deleted 10 million.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have file 1.txt with following entries as shown:
0152364|134444|10.20.30.40|015236433
0233654|122555|10.20.30.50|023365433
**
**
**
In file 2.txt I have the following entries as shown:
0152364|134444|10.20.30.40|015236433
0233654|122555|10.20.30.50|023365433... (4 Replies)
Discussion started by: imas
4 Replies
2. Shell Programming and Scripting
Hi All,
Below is my requirement. Whatever coming in between ' ', needs to delete.
Input File Contents:
==============
This is nice 'boy'
This 'is
bad
boy.' Got it
Expected Output
===========
This is nice
This
Got it (4 Replies)
Discussion started by: susau_79
4 Replies
3. Shell Programming and Scripting
Hi,
Before insert, delete everything. If ' available before insert, then we need to keep this.
Input:
====
l_s := ' INSERT INTO TEST1'
INSERT INTO TEST2
Output:
====
'INSERT INTO TEST'
INSERT INTO TEST2 (2 Replies)
Discussion started by: saurabhbaisakhi
2 Replies
4. Shell Programming and Scripting
Hi,
I have a data in a file like below -
andy 22 abc 30000 wallstreet
paul 30 xyz 40000 martstreet
john 35 abc 50000 martstreet
I want to search number of employees working in a particular company. Below query executes perfectly -
awk '/abc/{ COUNT ++; }END { print "number of... (3 Replies)
Discussion started by: shell123
3 Replies
5. Homework & Coursework Questions
if the given pattern exists in the file with the very next line starting and ending
with the same pattern , delete the line that starts and ends with the given pattern.
So upon running on this file
=====================
hai people<PATTERN> we had
<PATTERN>a lot of fun<PATTERN>
... (1 Reply)
Discussion started by: jacky29
1 Replies
6. Shell Programming and Scripting
Hello sed gurus. I am using ksh on Sun and have a file created by concatenating several other files. All files contain header rows. I just need to keep the first occurrence and remove all other header rows.
header for file
1111
2222
3333
header for file
1111
2222
3333
header for file... (8 Replies)
Discussion started by: gary_w
8 Replies
7. Shell Programming and Scripting
I have a string in which i need to match a pattern and then i need to delete that line which contains that matching string.
The string is ..
This is the given string
//abc/def/IC.5.4.3/test/...
i need to match //abc
I am writing like this
sed '/^/\/\abc/d' but it is not giving me... (4 Replies)
Discussion started by: codecatcher
4 Replies
8. Shell Programming and Scripting
I had a spot of trouble coming up with a title, hopefully you'll understand once you read my problem... :)
I have the output of an ldapsearch that looks like this:
dn: cn=sam,ou=company,o=com
uidNumber: 7174
gidNumber: 49563
homeDirectory: /home/sam
loginshell: /bin/bash
uid: sam... (2 Replies)
Discussion started by: samgoober
2 Replies
9. Shell Programming and Scripting
Hi Team,
Could someone please help me on this ..
While doing my day to day activity I use to delete manually the repeated ones ..
For example 05 & 06 are my hosts.. Now I need to print only 05 and 06, 05-06 is not required.
This is how I generate my report daily ..
DBG-STG1-05... (5 Replies)
Discussion started by: Nallachand
5 Replies
10. Shell Programming and Scripting
I have a file
Line 1 a
Line 22
Line 33
Line 1 b
Line 22
Line 1 c
Line 4
Line 5
I want to delete all lines before last occurrence of a line which contains something which is defined in a variable. Say a variable var contains 'Line 1', then I need the following in the output.
... (21 Replies)
Discussion started by: Soham
21 Replies
LEARN ABOUT OPENDARWIN
column
COLUMN(1) BSD General Commands Manual COLUMN(1)
NAME
column -- columnate lists
SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...]
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by
default, from the standard input. Empty lines are ignored.
The options are as follows:
-c Output is formatted for a display columns wide.
-s Specify a set of characters to be used to delimit columns for the -t option.
-t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the -s option. Useful for pretty-printing displays.
-x Fill columns before filling rows.
DIAGNOSTICS
The column utility exits 0 on success, and >0 if an error occurs.
ENVIRONMENT
COLUMNS The environment variable COLUMNS is used to determine the size of the screen if no other information is available.
EXAMPLES
(printf "PERM LINKS OWNER GROUP SIZE MONTH DAY " ;
printf "HH:MM/YEAR NAME
" ;
ls -l | sed 1d) | column -t
SEE ALSO
colrm(1), ls(1), paste(1), sort(1)
HISTORY
The column command appeared in 4.3BSD-Reno.
BSD
June 6, 1993 BSD