01-15-2010
The "sed 's/-.*|/|/' file" works for me however how can I specify to remove the "-" on a particular column so that it doesnt touch ant other fields with "-" ? I n this case I only want to touch the field 12
blah|08-232|foo|bar|blah|aaa|aaa|asa|as|as|foo|94555-7777|blah
9 More Discussions You Might Find Interesting
1. HP-UX
Hi Guys here I am again,
I have two files in a specified location.
Location ex: /opt/xdm/input/
input file names: 1. abc_app.yyyymmdd.dtd
2. abd_app.yyyymmdd.dtd
I need to build a code that reads the files from the location based on the oldest date and cuts the date part... (5 Replies)
Discussion started by: ruthless
5 Replies
2. Shell Programming and Scripting
Hi,
Is it possible to remove the first part of the file name using find.
i.e i have something like 2006abc.txt , 1007bed.txt etc,
I wanna rename them to abc.txt , bed.txt
I tried some stupid way..
find . -name '*.txt' -exec mv {} `cut -f2-5 -d"_" {}` \;
somehow iam not getting it.
... (3 Replies)
Discussion started by: braindrain
3 Replies
3. Shell Programming and Scripting
I have an xml file, from where I need to take out Application2 entries and keep the others. I need to remove from <product> to </product> and the key element to look for while removing should be <application> as other pairs can be same for others.
<product>
... (10 Replies)
Discussion started by: chiru_h
10 Replies
4. Shell Programming and Scripting
Hi,
I have two input files as
File1 :
ABC:client1:project1
XYZ:client2-aa:project2
DEF:client4:proj
File2 :
client1:W-170:xx
client2-aa:WT-04:yy
client4:L-005A:zz
Also, array of valid values can be hardcoded like
Output :
ABC:W:project1
XYZ:WT:project2 (1 Reply)
Discussion started by: aa2601
1 Replies
5. Shell Programming and Scripting
Hi Gurus,
I have file name like:
abcd.20131005.dat
I need to remove mid part of data
final name should be
abcd.dat
thanks in advance (2 Replies)
Discussion started by: ken6503
2 Replies
6. Shell Programming and Scripting
hi all,
how can i use grep or awk to clean the following input data:
n<>the<>96427210 861521305 123257583
n<>obj<>79634223 861521305 79634223
n<>nmod<>68404733 861521305 68422718
where the desired results is to remove all non-numeric characters?:
96427210 861521305 123257583 ... (5 Replies)
Discussion started by: owwow14
5 Replies
7. Shell Programming and Scripting
(14 Replies)
Discussion started by: dhruuv369
14 Replies
8. Shell Programming and Scripting
Dear all,
How can I remove duplicated column in a text file?
Input:
LG10_PM_map_19_LEnd 1000560 G AA AA AA AA AA GG
LG10_PM_map_19_LEnd 1005621 G GG GG GG AA AA GG
LG10_PM_map_19_LEnd 1011214 A AA AA AA AA GG GG
LG10_PM_map_19_LEnd 1011673 T TT TT TT TT CC CC... (1 Reply)
Discussion started by: huiyee1
1 Replies
9. Shell Programming and Scripting
Gents,
Is there the chance to remove part of the file,
Taking in consideration this condition.
For each record the first row start with the string % VE
should be 56 rows for each records..
first row = % VE
last row = % sw
total 56 rows for each record.
Then in the case that the... (4 Replies)
Discussion started by: jiam912
4 Replies
COLRM(1) BSD General Commands Manual COLRM(1)
NAME
colrm -- remove columns from a file
SYNOPSIS
colrm [start [stop]]
DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read
from the standard input. Output is written to the standard output.
If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec-
ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not
zero.
Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).
EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs.
SEE ALSO
awk(1), column(1), cut(1), paste(1)
HISTORY
The colrm command appeared in 3.0BSD.
BSD
August 4, 2004 BSD