Sponsored Content
Full Discussion: Classify value to a range
Top Forums UNIX for Dummies Questions & Answers Classify value to a range Post 302536335 by chen.xiao.po on Tuesday 5th of July 2011 06:29:47 AM
Old 07-05-2011
Classify value to a range

Dear All,
I need to classify my data into sets or ranges based on values in the second column of a file as - low medium and high.

INPUT:

file1.dat
1.tmp 1.03
2.tmp 0.38
3.tmp 3.23
4.tmp 1.34

I would like to classify all the numerical values into a range based on the followng cutoffs:

1> as low (L)
1< and <=2 as medium (M)
2< as high (H)


OUTPUT:

out.dat
1.tmp 1.03 M
2.tmp 0.38 L
3.tmp 3.23 H
4.tmp 1.34 M

Could you please help??
Thanks
Po
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Getting 'out of range' when partitioning

Hello, Using Solaris 10. Going to mirror disks with solstice disksuite. Documentation says I have to make both disks partitioned exactly the same before moving on. Here's the layout of c1t0d0 Part Tag Flag Cylinders Size Blocks 0 root wm 1237 - 2473 6.00GB (1237/0/0) 12587712 ... (1 Reply)
Discussion started by: pmichner
1 Replies

2. Shell Programming and Scripting

Range generator

Dear All, I have a sorted file like 1 2 3 8 9 10 45 46 47 78 The output will be range like 1 3 8 10 45 47 78 78 (9 Replies)
Discussion started by: saifurshaon
9 Replies

3. Shell Programming and Scripting

print range between two patterns if it contains a pattern within the range

I want to print between the range two patterns if a particular pattern is present in between the two patterns. I am new to Unix. Any help would be greatly appreciated. e.g. Pattern1 Bombay Calcutta Delhi Pattern2 Pattern1 Patna Madras Gwalior Delhi Pattern2 Pattern1... (2 Replies)
Discussion started by: joyan321
2 Replies

4. Shell Programming and Scripting

How to use awk to classify file extension from input ls -l

i try to do this for a long time input is command ls -l and output is: Number of files : xx Number of file type – awk : 5 total size: 2345 bytes // file ex type .awk Number of file type – dat : 10 total size: 233 bytes // file ex type .dat ... Number of unknown file type... (1 Reply)
Discussion started by: retsuseiba
1 Replies

5. Shell Programming and Scripting

AWK to classify a file into several ones ..

Good Day All, I need to make a script that will do the following : 1- read a .csv file line by line, check the 3 field of each file print the whole line if this field matches the condition (note : FS = ",") 2-from the basic file, the script should genrate 3 new files based on the step #1... (6 Replies)
Discussion started by: engkemo2002
6 Replies

6. Shell Programming and Scripting

Date range

Dear all, how can I select in the file below only the files created between Aug 14 2014 and Feb 03 2015? EZA2284I -rw-r--r-- 1 30 8 356954 Aug 15 2014 file1 EZA2284I -rw-rw-r-- 1 30 8 251396 Feb 05 12:53 file2 EZA2284I -rw-rw-r-- 1 30 8 ... (3 Replies)
Discussion started by: simomuc
3 Replies

7. IP Networking

IP Range Assigning

Hi All, I'm a bit confused about assigning IP address from IP Ranges. I am using this scenario below to understand. Scenario Adatum.com an international IT solutions company, is launching 12 new branches in a new country where they currently have no existing branches. The sWin CIO has asked... (3 Replies)
Discussion started by: TryllZ
3 Replies

8. Homework & Coursework Questions

IP Range Assigning

THIS IS A SAMPLE PRACTICAL EXAM QUESTION, COMPLETE FILE HAS BEEN ATTACHED AS WELL. Hi All, I'm a bit confused about assigning IP address from IP Ranges. I am using this scenario below to understand. Scenario Adatum.com an international IT solutions company, is launching 12 new branches in a... (10 Replies)
Discussion started by: TryllZ
10 Replies

9. Shell Programming and Scripting

Classify lines in file using perl

The below perl executes and does classify each of the 3 lines in file.txt. Lines 2 and 3 are correct as they fit the criteria for Rule 2. The problem is that line one should be classified VUS as it does not meet the criteria for Rule 1, so Rule 3 is used. However, currently Rule 2 is changing the... (27 Replies)
Discussion started by: cmccabe
27 Replies
E2TOOLS(7)						 Miscellaneous Information Manual						E2TOOLS(7)

NAME
e2tools - utilities to manipulate files in an ext2/ext3 filesystem DESCRIPTION
E2tools is a simple set of GPL'ed utilities to read, write, and manipulate files in an ext2/ext3 filesystem. These utilities access a filesystem directly using the ext2fs library. I wrote these tools in order to copy files into a linux filesystem on a machine that does not have ext2 support. Of course, they can also be used on a linux machine to read/write to disk images or floppies without having to mount them or have root access. Supported functionality: e2cp copy files e2mv move files e2rm remove files e2mkdir create directory e2ln create hard links e2ls list files/directories e2tail output the last part of a file In general, to specify a directory or file on an ext2 filesystem for the e2tools utilities, use the following form: filesystem:directory_path The filesystem can be an unmounted partition or a regular file that's been formatted to contain an ext2 filesystem. In general, if a com- mand takes multiple file names on the command line, if the first one contains an ext2 file specification, the rest of the files are assumed to be on the same filesystem until another one is explicitly stated: /tmp/boot.img:/tmp/file1 /tmp/file2 /tmp/file3 /tmp/boot2.img:/tmp/file4 Files 1-3 are on /tmp/boot.img and the last file is on /tmp/boot2.img SEE ALSO
e2cp(1), e2ln(1), e2ls(1), e2mkdir(1), e2mv(1), e2rm(1), e2tail(1). AUTHOR
The e2tools were written by Keith Sheffield <sheff@pobox.com>. This manual page was written by Lucas Wall <lwall@debian.org>, for the Debian project (but may be used by others). March 2, 2005 E2TOOLS(7)
All times are GMT -4. The time now is 08:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy