|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
column extract help
Post 302188999 by aigles on Thursday 24th of April 2008 04:19:18 PM
04-24-2008
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear All,
I have a file name pointer.unl. It's contains the information below:
O|A|4560333089|PBS|AU1|01/04/2003|30/04/2006|D|IGCD|
O|A|4562222089|PBN|AU1|01/02/2006|31/01/2008|D|04065432|
O|A|3454d00089|PKR|AU1|01/03/2008||R|sdcdc|
I only need to extract first... (11 Replies)
Discussion started by: selamba_warrior
11 Replies
2. UNIX for Advanced & Expert Users
Hi Can anyone please correct, I have problem while trying to grep the 3rd word from the 1st column with the command cat file1.txt | awk '{print$3}'
All the words are seperated by comma and not by spaces.
File1.txt:
abc,123,pqr.123,abc
cdr,324,ads.232,123
Result required:
pqr.123... (2 Replies)
Discussion started by: sureshcisco
2 Replies
3. Shell Programming and Scripting
Hi all,
I have file like the following. How can i extract the value one by one and pass it to another script using a loop. It would be a great help if someone can help me in this.
001355snap
001356mvpd
001357micr
001358mast
001359lake
001360klaa
Like i have a perl script... (2 Replies)
Discussion started by: Tuxidow
2 Replies
4. Shell Programming and Scripting
Hi All,
Using below command to extract text from a file
grep -E "^.{20}5004" filename.rtf >> 5004This will give all lines with text 5004 starting at position 20.
The file filename.rtf contains several rows (millions). The four characters starting from 20 position is repeating in several... (4 Replies)
Discussion started by: hsehdar
4 Replies
5. Shell Programming and Scripting
Hello,
I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2
SDF4 -0.211654
SDF4 0.978068
... (1 Reply)
Discussion started by: Diya123
1 Replies
6. Shell Programming and Scripting
Hi all,
My goal is to always get the value at col4 in a file that contains below.
col1 col2 col3 col4 col5
xdf sdee sdff cfdd
ddd rfg fgt grf drft
I have tried the following but for the first entry(xdf sdee sdff cfdd) the 4th column is col5... (7 Replies)
Discussion started by: johnsanty
7 Replies
7. Shell Programming and Scripting
Hi ,
I need to extract data from below mentioned data, having no delimiter and havin no fixed column length.
For example:
Member nbr Ref no date
10000 1000 10202012
200000 2000 11202012
Output:
to update DB with memeber nbr on basis of ref no.
... (6 Replies)
Discussion started by: ns64110
6 Replies
8. UNIX for Dummies Questions & Answers
I have a file which extracts data from an HTML file
For Eg HTML file contains:
New York;ABC;145;Yes;YES;No
New York;BCD;113;Yes;YES;No
New York;NAS;63;Yes;YES;No
------------------------
London-48;CBT;16;Yes;YES;No
London-48;CME;17;Yes;YES;No
London-48;EUR;52;Yes;YES;No... (3 Replies)
Discussion started by: newkid.7955
3 Replies
9. Shell Programming and Scripting
I have a lot of file with a lot of lines following the same pattern
the lines go like this:
alpha_9/output- -413.74928476 2.6116
and I want it to be:
9 -413.74928476 2.6116
thanks for the help (5 Replies)
Discussion started by: galboski
5 Replies
10. Shell Programming and Scripting
hi i have sample data
a,b,c,d,e,g h http://mysite.xyx
z,b,d,f,e,s t http://123124#
a,b,c,i,m,nothing
d,i,j,e,w,nothing
output expected is
a,b,c,d,e,http://mysite.xyx
z,b,d,f,e,http://123124#
a,b,c,i,m,nothing
d,i,j,e,w,nothing
i can get only links using grep -o 'http.*'
i... (8 Replies)
Discussion started by: zozoo
8 Replies
LEARN ABOUT MOJAVE
colrm
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