how to find the field has more than 2 decimals


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting how to find the field has more than 2 decimals
# 1  
Old 11-16-2016
how to find the field has more than 2 decimals

Hi Gurus,

I have below sample file, I need find the line which 2rd field has more than 2 decimals.

in sample file, I need to find xyz, 123456.789

Code:
 
 abc, 1234.45, def
xyz, 123456.789, xxx
bce, 1234.34, xxx

thanks in advance

Last edited by ken6503; 11-16-2016 at 10:56 PM.. Reason: subject description is not clear
# 2  
Old 11-16-2016
With well over 100 posts we would have that you have learned something from the suggestions we have provided in helping you with your previous problems. What have you tried to solve this problem on your own?

What shell are you using?

What operating system are you using?
# 3  
Old 11-16-2016
Quote:
Originally Posted by Don Cragun
With well over 100 posts we would have that you have learned something from the suggestions we have provided in helping you with your previous problems. What have you tried to solve this problem on your own?

What shell are you using?

What operating system are you using?
I have tried to search the solution from internet, but no luck at all.

my shell is ksh

my os is solaris.

thanks.
# 4  
Old 11-16-2016
Instead of searching the internet, why don't you look back through all of the solutions you have been given to solve your previous problems and use what you have learned from those solutions to try come up with a very simple nawk script that will do what you have asked for here?
# 5  
Old 11-16-2016
Quote:
Originally Posted by Don Cragun
With well over 100 posts we would have that you have learned something from the suggestions we have provided in helping you with your previous problems. What have you tried to solve this problem on your own?

What shell are you using?

What operating system are you using?
I tried below command but it gave me the record with one decimal as well.

Code:
awk -F"," '$2!~/\.[0-9][0-9]$/ {print $0}' test

# 6  
Old 11-16-2016
Code:
awk -F"," '$2 ~ /\.[0-9][0-9][0-9]/' test

This User Gave Thanks to Aia For This Post:
# 7  
Old 11-16-2016
try this...

Code:
awk -F, '{split($2,Arr,".")}length(Arr[2])>2'  test

This User Gave Thanks to itkamaraj For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find the difference in specific field

Hi All, Seeking for your assistance to get the difference of field1 and field2 and output all the records if there's a difference. please see below scenario. file1.txt 250|UPTREND FASHION DESIGN,CORP.|2016-04-04 09:36:13.991257 74|MAINSTREAM BUSINESS INC.|2016-04-04 09:36:13.991257... (1 Reply)
Discussion started by: znesotomayor
1 Replies

2. Shell Programming and Scripting

Find pattern in first field of file

Hello all I have two files. 1. Pattern.txt - It contains patterns to be matched. It has large number of patterns to be matched. Cat Pattern.txt Ram Shyam Mohan Jhon I have another file which has actual data and records are delimted by single or multiple spaces. 2.... (8 Replies)
Discussion started by: krsnadasa
8 Replies

3. Shell Programming and Scripting

Find a blank field

Find a blank field Hi I have set of fields that have some blank values, how to find that and get its line noumbers in output file. Ex: Col1 col2 col3 11 ss 103 12 104 13 105 14 se 106 (2 Replies)
Discussion started by: Shenbaga.d
2 Replies

4. Shell Programming and Scripting

how to find the 2nd field

java....4059... compsite 62u IPv4 170747 TCP *:9400 (LISTEN) java...... 05... compsite 109u IPv4 171216 TCP *:9401 (LISTEN) This is Joust formated like this Please Repace "." with space" " All are Right Justfied Output :- 4058 and 05 so that i can kill this (1 Reply)
Discussion started by: pareshpatra
1 Replies

5. Shell Programming and Scripting

Find and replace blank in the last field

Hi all, I have a huge file and I need to get ride of the fields 6-11 and replace the blanks in field 5 with a missing value(99999). 159,93848,5354,343,67898,45,677,5443,434,5545,45 677,45545,3522,244, 554,54344,3342,456, 344,43443,2344,444,23477... (12 Replies)
Discussion started by: GoldenFire
12 Replies

6. Shell Programming and Scripting

find the field number

######################## SOLVED ################## Hi I have a header file like the following and the field "IDENTIFIER" can be at any possition on this line, The line can containt a variable number of field, not alway the same depending of the header file i use ... (6 Replies)
Discussion started by: kykyboss023
6 Replies

7. Shell Programming and Scripting

find the last field in a string

Hi all I have strings with fields separated by <space> and I want to automatic find the value of "the last field -1" for each string Strings don't have the same nb of fields I know it's possible with awk but I didn't find syntax... Many thanks for your help ;) (3 Replies)
Discussion started by: madmat
3 Replies

8. Shell Programming and Scripting

Find top N values for field X based on field Y's value

I want to find the top N entries for a certain field based on the values of another field. For example if N=3, we want the 3 best values for each entry: Entry1 ||| 100 Entry1 ||| 95 Entry1 ||| 30 Entry1 ||| 80 Entry1 ||| 50 Entry2 ||| 40 Entry2 ||| 20 Entry2 ||| 10 Entry2 ||| 50... (1 Reply)
Discussion started by: FrancoisCN
1 Replies

9. Shell Programming and Scripting

convert Regular decimals to Packed decimals

Hi, I am trying to find if there is a way to convert regular decimal values to Paced decimal values. I tried to find a c program but I could get a Packed converted to regular decimal not the other way round. If not unix please let me know if any other progrimming language I can use to do... (2 Replies)
Discussion started by: mgirinath
2 Replies

10. Shell Programming and Scripting

find pattern and replace another field

HI all I have a problem, I need to replace a field in a file, but only in the lines that have some pattern, example: 100099C01101C00000000059394200701CREoperadora_TX 100099C01201C00000000000099786137OPERADORA_TX2 in the example above I need to change the first field from 1 to 2 only if... (3 Replies)
Discussion started by: sergiioo
3 Replies
Login or Register to Ask a Question