cut operation is not helping me much


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting cut operation is not helping me much
# 1  
Old 12-30-2010
cut operation is not helping me much

hi,
i have a file where I want to extract the the failure count [4th column]only from the file.
Code:
JOB_NAME                          STATE            RUN_COUNT FAILURE_COUNT
------------------------------ --------------- ---------- -------------
OFS_BALA_BILLING_IN                SCHEDULED           22992             0
OFS_BALA_BILLING_IN_NEW        SCHEDULED            22992             0
OS_BAL_MPRTD_IN                    SCHEDULED            22992             0
OS_TO_BALA                            SCHEDULED            22992             0
SAAS_TO_BAL_MPRTD                SCHEDULED            22989             0

I was trying with cut -d" " -f 4 filename[there is TAB in between " "]
it did not work and coming as :
Code:
      0
 
      0
    22992
      0

expected is>> only 0s should come.
I tried with cut -c 70 even its not working as expected.
its because cut -c cuts the file according to its character postion and the JOB_NAME in the file are not of similar length.

Please help.

---------- Post updated at 04:54 PM ---------- Previous update was at 04:52 PM ----------

please note that,
the columns are tab separated.
while copy pasting here, its looking like a mesh.. but in original file, all are aligned well.
# 2  
Old 12-30-2010
Code:
awk '!/-/{print $NF}' file

# 3  
Old 12-30-2010
Quote:
Originally Posted by gotam
please note that,
the columns are tab separated.
while copy pasting here, its looking like a mesh.. but in original file, all are aligned well.
If the fields are truly tab separated, You can try cut without providing the "-d" option. the default is tab.
just do cut -f4
# 4  
Old 12-30-2010
@danmero..
Thanks buddy.. i got it working

@Anchal,
Thanks for the reply.
And yes I have tried that way too. but its giving me same unexpected result.[i think the reason is where the length of the first column is little smaller then, automatiaclly the next column wud be 2 TABs separated]
Please rectify, if i am wrong.
# 5  
Old 12-30-2010
The "awk" in post #2 should work because it doesn't care whether white space is tabs or spaces or multiples of either character.


I believe that there must be more than one consecutive tab character in some of your white space.

Please post the output from this "sed" command which is designed to make control characters visible (such as tab characters):
Code:
sed -n l filename

# 6  
Old 12-30-2010
Thanks Methyl,
YEs u r true. Thanks for the tips. Smilie
Code:
OFS_BALA_BILLING_IN\t       SCHEDULED\t    22992\t      0$
OFS_BALA_BILLING_IN_NEW        SCHEDULED\t    22992\t      0$
OS_BAL_MPRTD_IN \t       SCHEDULED\t    22992\t      0$
OS_TO_BALA\t\t       SCHEDULED\t    22992\t      0$
SAAS_TO_BAL_MPRTD\t       SCHEDULED\t    22989\t      0$

# 7  
Old 12-30-2010
That's why the "cut" misbehaved.

The "awk" approach is best because it copes well with mixed and variable length white space.
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Helping a Newbie with Shell Homework

Good Evening, i got a homework where i have to list all files in the directory with the name length >=3 and <= 6 and after trying it for 2 days my Prof gave me a bit of code: #!/bin/bash for file in $(ls) do done after that he told me "now you only have to use wc and you got it" but... (1 Reply)
Discussion started by: Mentoss
1 Replies

2. Shell Programming and Scripting

Helping with similar "read -t" for KSH file

Hi all, I've trying to apply this command into my .ksh file, but UNIX doesn't accept this option. I need wait a few seconds (maybe 20sec. is very well). Could you please help me? code: #!/bin/ksh .... .... .... read -t 20 continue_run if ]; then; continue_run='N' fi ...... (3 Replies)
Discussion started by: speed_racer
3 Replies

3. Shell Programming and Scripting

Column operation : cosne and sine operation

I have a txt file with several columns and i want to peform an operation on two columns and output it to a new txt file . file.txt 900.00000 1 1 1 500.00000 500.00000 100000.000 4 4 1.45257346E-07 899.10834 ... (4 Replies)
Discussion started by: shashi792
4 Replies

4. Shell Programming and Scripting

Helping in parsing subset of text from a big results file

Hi All, I need some help to effectively parse out a subset of results from a big results file. Below is an example of the text file. Each block that I need to parse starts with "reading sequence file 10.codon" (next block starts with another number) and ends with **p-Value(s)**. I have given... (1 Reply)
Discussion started by: Lucky Ali
1 Replies

5. IP Networking

helping new Linux users remotely ?

I volunteer with a small charity which locally donates refurbished computers to people who normally could not afford their own computer. Most of these computers now have Linux on them. We are in the process of remastering Xubuntu 9.04 to use as our main distro from now on. In the past any time... (3 Replies)
Discussion started by: lagagnon
3 Replies

6. Shell Programming and Scripting

Need a helping hand --stuck in starting of this problm.

Hi all it is a real challenge for me to do it in 2 days any help or suggestion will be a great ! Problem : I have 17 - CSV files (Coma separated value) each file conating around 26 column the first line of each of the file conatin the field name and from second line the file contain data for... (13 Replies)
Discussion started by: jambesh
13 Replies
Login or Register to Ask a Question