I want to extract the red numbers from the string column I have. when I run your suggestion command it remove the red numbers which are between two colon.I just want to keep those numbers.
---------- Post updated at 04:33 PM ---------- Previous update was at 04:29 PM ----------
Dear Don Cragun
I have 300 files which I used this command below to extract column 1, 2, 4, 5, and the first three number of the 10 column of my data set.
Code:
for file in *.work; do awk '{print $1,$2,$4,$5,substr($10,1,1),substr($10,3,1)}' $file > "$(basename "$file" .work).info"; done
My problem is that the number which are in the middle of the sting column tenth have different digit numbers.
Moderator's Comments:
Please use CODE tags when posting sample input, output, AND code segments.
Don't assume that a moderator will always be available to clean up your posts for you.
Last edited by Don Cragun; 03-13-2015 at 06:28 PM..
Reason: Add CODE tags.
Hi,
I would like extract from a file a character or pattern after ( n + 1) a specific pattern (n) . ( i supposed with awk)
how could i do ?
Thanks in advance. (1 Reply)
ps -eaf | grep “oracleTRLV (LOCAL=NO)” | while read ora_proc
do
echo $ora_proc
done
I would like to modify the above shell so that if character 13 and 14 equal "12" to do something.
Sorry I'm new to shell:( (14 Replies)
The log reads as follows.
fname1;lname1;eid1;addr;pincode1;
fname2;lname2;eid2;addr2;pincode2;
fname3;lname3;eid3;addr3;pincode3;
fname4;lname4;eid;addr4;pincode4;
how do i extract only fname and save it in an array
similarly for lname and so on
i tried reading a file and cutting each... (5 Replies)
I would like to extract a digit from $0 starting 2,30 to 3,99 or 2.30 to 3.99
Can somebody fix this?
awk --re-interval '{if($0 ~ /{1}{2}/) {print FILENAME, substr($0,index($0,/{1}{2}/) , 4)}}'input
abcdefg sdlfkj 3,29 g. lasdfj
alsdfjasl 2.86 gr. slkjds sldkd
lskdjfsl sdfkj kdjlksj 3,34 g... (4 Replies)
I have this:
((9:0.010,(11:0.089,13:0.004))
and I would like this:
((A9,(A11,A13))
How do I delete the semi colon and the number (i.e. 0.010) after the semi colon? Also, how can I add the letter before the number that is NOT removed?
Thank you in advance!
---------- Post updated... (4 Replies)
Hi,
I need to extract the first character of second column of my file. If the condition matches, then I need to print the 2nd and 3rd column as my output
I tried below mentioned query but it was not working
awk -F'|' '$2~/^5/' Sgn_group.txt
File Name : Sgn_group.txt
country... (2 Replies)
Hello Team,
Could you please help me with the below question?
I have a file with the following properties
1) File Delimiter is ;
2) Text columns are within double quotes
3) Numeric columns will not have double quotes
4) File has total 6 columns
Please see a sample record from file
... (3 Replies)
Hi,
I need to extract part of a text to two variables
text is
"PL/SQL procedure successfully completed. ERROR ----------------------------------------------------------------- Test Error Message PLUSVAR ---------- 1"
I want "Test Error Message" in one variable and "1" in another variable.... (11 Replies)
# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.5 (Maipo)
I have this script that will monitor filesystems and send me e-amil alerts.
#! /bin/ksh
DIST_LIST=monitor@...com
WORKDIR=/home/monitor
WARNLEVEL=90
MAIL_SUBJ="filesystems monitor on "$(hostname)
... (3 Replies)
Discussion started by: danielshell
3 Replies
LEARN ABOUT LINUX
psc
PSC(1) General Commands Manual PSC(1)NAME
psc - prepare sc files
SYNOPSIS
psc [-fLkrSPv] [-s cell] [-R n] [-C n] [-n n] [-d c]
DESCRIPTION
Psc is used to prepare data for input to the spreadsheet calculator sc(1). It accepts normal ascii data on standard input. Standard out-
put is a sc file. With no options, psc starts the spreadsheet in cell A0. Strings are right justified. All data on a line is entered on
the same row; new input lines cause the output row number to increment by one. The default delimiters are tab and space. The column for-
mats are set to one larger than the number of columns required to hold the largest value in the column.
OPTIONS -f Omit column width calculations. This option is for preparing data to be merged with an existing spreadsheet. If the option is not
specified, the column widths calculated for the data read by psc will override those already set in the existing spreadsheet.
-L Left justify strings.
-k Keep all delimiters. This option causes the output cell to change on each new delimiter encountered in the input stream. The
default action is to condense multiple delimiters to one, so that the cell only changes once per input data item.
-r Output the data by row first then column. For input consisting of a single column, this option will result in output of one row
with multiple columns instead of a single column spreadsheet.
-s cell
Start the top left corner of the spreadsheet in cell. For example, -s B33 will arrange the output data so that the spreadsheet
starts in column B, row 33.
-R n Increment by n on each new output row.
-C n Increment by n on each new output column.
-n n Output n rows before advancing to the next column. This option is used when the input is arranged in a single column and the
spreadsheet is to have multiple columns, each of which is to be length n.
-d c Use the single character c as the delimiter between input fields.
-P Plain numbers only. A field is a number only when there is no imbedded [-+eE].
-S All numbers are strings.
-v Print the version of psc
SEE ALSO sc(1)AUTHOR
Robert Bond
PSC 7.16 19 September 2002 PSC(1)
03-13-2015
