Please help with this.. my file sizes exceed 40GB,,not possible to do manually.
I have a string in the 2nd column that has strings like 5M108N31M, 3S2M100N45M4S etc..the first column is a number.
There can be 0,1 or 2 number of S but only 1,2 Ms and only 1 N.
S only occurs at the beginning or at the end of the string.
I want to extract values corresponding to M,S,N
example for string 5M108N31M
S1=0 (since no S is present)
M1=5
N=108
M2=31
for the second string 3S2M100N45M4S
S1=3
M1=2
N=100
M2=45
S2=4
In the output the first column is (1st column in input+S1+M1)
In the output the second column is (1st column in input+S1+M1 + N )
M2 and S2 are not needed for the calculations.
I have a line from table space report:
5 135_TT ms Normal 1774336.0 1774208.0 761152.0 1013056.0 57.1%
Now I have to get 1013056.0 as o/p.
For this I tried cut -f32 -d" " previously it worked now it is showing empty space.
Suggest me the best code for this which... (1 Reply)
Hi, I want to extract rows that have specific characters at a certain column. It might be best to show you my problem.
So my tab delimited file looks like this:
YPR161C 10 16 864445 866418 - Verified 3.558
YOL138C 6 15 61325 65350 - Verified 0.6... (1 Reply)
Hi,
I have a file with the following columns:
361459 447394 CHL1
290282 290282 CHL1
361459 447394 CHL1
361459 447394 CHL1
178352861 178363529 AGA
178352861 178363529 AGA
178363657 178363657 AGA
Essentially, using CHL1 as an example. For any line that has CHL1 in... (2 Replies)
I would like to extract the last column of a text file but different rows of the text file have different numbers of columns. How do I go about doing that? Thanks! (1 Reply)
Hi all,
I need to run df, and parse the value under column of "Mounted on"
For instance, my df is
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda1 4881344 4106460 526924 89% /
none 245164 220 244944 1% /dev... (6 Replies)
Hello
Kindly help me to find out the first column from first line of a flat file in perl
I/P
9869912|20110830|00000000000013009|130|09|10/15/2010 12:36:22|W860944|N|00
9869912|20110830|00000000000013013|130|13|10/15/2010 12:36:22|W860944|N|00... (5 Replies)
Hi,
I've a text file like
ABC,,100
A,100,200
In the above example, I have 3 columns. I want to extract the second column.
I'm expecting a value like
100
i.e first record will not have any value but still it has to give me null value. second record should give 100.
Can anybody... (2 Replies)
Greetings All!!
I have a very peculiar problem where I have to parse a big text file and extract useful data out of it with starting and ending block pattern matching.
e.g. I have a input file like this:
sample data
block1
sample data
start
useful data
end
sample data
block2
sample... (5 Replies)