|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Matching same columns and finding the smallest match
Post 302322422 by phil_heath on Wednesday 3rd of June 2009 04:51:40 PM
06-03-2009
Matching same columns and finding the smallest match
Hi all,
I am wondering if its possible to solve my problem with a simple code.
Basically I have a file that looks like this (tab delimited)
bob 8 250 tina 8 225
sam 8 225 ellen 9 315
kyle 9 275 sally 9 135
So what I want to do is match columns 2 and 5. If columns 2 and 5 match, the next thing would be to determine the shortest distance between column 3 and 6. Basically I want it to print the columns with the shortest distance.
So from the above, it will print:
bob 8 250 tina 8 225 25
kyle 9 275 ellen 9 315 40
thanks
-----Post Update-----
awk -F"\t" '$2==$5 {print $0}' filename
this is what I have so far. This could only match columns but does not do the subtraction and finding the shortest distance. I guess this is where im stuck
I am wondering if its possible to solve my problem with a simple code.
Basically I have a file that looks like this (tab delimited)
bob 8 250 tina 8 225
sam 8 225 ellen 9 315
kyle 9 275 sally 9 135
So what I want to do is match columns 2 and 5. If columns 2 and 5 match, the next thing would be to determine the shortest distance between column 3 and 6. Basically I want it to print the columns with the shortest distance.
So from the above, it will print:
bob 8 250 tina 8 225 25
kyle 9 275 ellen 9 315 40
thanks
-----Post Update-----
awk -F"\t" '$2==$5 {print $0}' filename
this is what I have so far. This could only match columns but does not do the subtraction and finding the shortest distance. I guess this is where im stuck
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a challenging task,in which i have to find the duplicate files by its name and size,then i need to take anyone of the file.Then i need to open the file and find for more than one pattern and count of that pattern.
Note:These are the samples of two files,but i can have more... (2 Replies)
Discussion started by: jerome Sukumar
2 Replies
2. Shell Programming and Scripting
Hi,I am new to shell scripting and i want to find the line numbers of matching braces.
The file contents are as follows
File XXX.dat
1 ( CLASS "FRUIT"
2 (TYPE "PERSISTENT")
3 (MESSAGE_TYPE "M")
4 (GET_REQRD "Y")
5 (SET_REQRD "Y")
6 )
7 ( CLASS... (3 Replies)
Discussion started by: Rajendra_1510
3 Replies
3. UNIX for Dummies Questions & Answers
I have a DNA file like below and I am able to write a short program which finds/not an input motif, but I dont understand how I can include in the code to report which position the motif was found. Example I want to find the first or all "GAT" motifs and want the program to report which position... (12 Replies)
Discussion started by: pawannoel
12 Replies
4. UNIX for Dummies Questions & Answers
I have a file that has information for a person....each person gets 3 or more lines to describe them.
I was hoping to match person 1, then person 2.....BUT I do not know how to tell grep I only want the first (2nd, 3rd or nth) match.
The alternative is doing line by line logic, which is fine... (8 Replies)
Discussion started by: countryStyle
8 Replies
5. Shell Programming and Scripting
Hi Friends,
I have the following input file
cat input
chr1 100 200 0.1 0.2 na 1 na nd
chr1 105 200 0.1 0.2 1 1 na 98
chr1 110 290 nf 1 na nd na 1
chr2 130 150 12 3 na 1 na 1
chr3 450 600 nf nf na 10 na nd
chr4 300 330 1 1 10 11 23 34
My requirement is
1. If $6 is na make $7 nd and... (2 Replies)
Discussion started by: jacobs.smith
2 Replies
6. Shell Programming and Scripting
I have a config file like below
JOHN 1,5,6,7,4,999,222,666,555
KELLY 54,77,33
ABC 98,22,11
name and then comma separated unique values. In my code I will have a number eg: 6 and I want to find out matching name eg: JOHN
How do i do ? Please advise. Thanks. (5 Replies)
Discussion started by: vegasluxor
5 Replies
7. Shell Programming and Scripting
Hi all, I know this sounds suspiciously like a homework course; but, it is not.
My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Discussion started by: mtucker6784
6 Replies
8. Shell Programming and Scripting
Hello All,
I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns.
So my requirement is to generate a output query which will have 20 columns all the... (7 Replies)
Discussion started by: vikas_trl
7 Replies
9. Shell Programming and Scripting
Hi,
I have requirement to find the matching patterns of two files in Unix. One file is the log file and the other is the error list file. If any pattern in the log file matches the list of errors in the error list file, then I would need to find the counts of the match.
For example,
... (5 Replies)
Discussion started by: Bobby_2000
5 Replies
10. UNIX for Beginners Questions & Answers
Hi,
i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file
I have tried with join and awk and i keep getting blank outputs or same file
is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies
LEARN ABOUT OPENSOLARIS
iconv_koi8-r
iconv_koi8-r(5) Standards, Environments, and Macros iconv_koi8-r(5) NAME
iconv_koi8-r - code set conversion tables for KOI8-R DESCRIPTION
The following code set conversions are supported: +-------------------------------------------------------------------------+ | Code Set Conversions Supported | +--------------+--------+--------------+--------+-------------------------+ | Code |Symbol |Target Code |Symbol | Target Output | +--------------+--------+--------------+--------+-------------------------+ |KOI8-R |koi8 |ISO 8859-5 |iso5 | ISO 8859-5 Cyrillic | +--------------+--------+--------------+--------+-------------------------+ |KOI8-R |koi8 |PC Cyrillic |alt | Alternative PC Cyrillic | +--------------+--------+--------------+--------+-------------------------+ |KOI8-R |koi8 |MS 1251 |win5 | Windows Cyrillic | +--------------+--------+--------------+--------+-------------------------+ |KOI8-R |koi8 |Mac Cyrillic |mac | Macintosh Cyrillic | +--------------+--------+--------------+--------+-------------------------+ CONVERSIONS
The conversions are performed according to the following tables. All values in the tables are given in octal. KOI8-R to ISO 8859-5 For the conversion of KOI8-R to ISO 8859-5, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | KOI8-R | ISO 8859-5 | KOI8-R | ISO 8859-5 | |24 | 4 |320 |337 | |241 | 362 |321 |357 | |242 | 363 |322 |340 | |243 | 361 |323 |341 | |244 | 364 |324 |342 | |245 | 365 |325 |343 | |246 | 366 |327 |322 | |247 | 367 |330 |354 | |250 | 370 |331 |353 | |251 | 371 |332 |327 | |252 | 372 |333 |350 | |253 | 373 |334 |355 | |254 | 374 |335 |351 | |256 | 376 |336 |347 | |257 | 377 |337 |352 | |260 | 360 |340 |316 | |261 | 242 |341 |260 | |262 | 243 |342 |261 | |263 | 241 |343 |306 | |264 | 244 |344 |264 | |265 | 245 |345 |265 | |266 | 246 |346 |304 | |267 | 247 |347 |263 | |270 | 250 |350 |305 | |271 | 251 |351 |270 | |272 | 252 |352 |271 | |273 | 253 |353 |272 | |274 | 254 |354 |273 | |275 | 255 |355 |274 | |276 | 256 |356 |275 | |277 | 257 |357 |276 | |300 | 356 |360 |277 | |301 | 320 |361 |317 | |302 | 321 |362 |300 | |303 | 346 |363 |301 | |304 | 324 |364 |302 | |305 | 325 |365 |303 | |306 | 344 |366 |266 | |307 | 323 |367 |262 | |310 | 345 |370 |314 | |311 | 330 |371 |313 | |312 | 331 |372 |267 | |313 | 332 |373 |310 | |314 | 333 |374 |315 | |315 | 334 |375 |311 | |316 | 335 |376 |307 | |317 | 336 | | | +---------------+----------------+----------------+---------------+ KOI8-R to PC Cyrillic For the conversion of KOI8-R to PC Cyrillic, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | KOI8-R | PC Cyrillic | KOI8-R | PC Cyrillic | |24 | 4 |333 |350 | |200-242 | 40 |334 |355 | |243 | 361 |335 |351 | |244-254 | 40 |336 |347 | |255 | 260 |337 |352 | |256-262 | 40 |340 |236 | |263 | 360 |341 |200 | |264-274 | 40 |342 |201 | |275 | 260 |343 |226 | |276-277 | 40 |344 |204 | |300 | 356 |345 |205 | |301 | 240 |346 |224 | |302 | 241 |347 |203 | |303 | 346 |350 |225 | |304 | 244 |351 |210 | |305 | 245 |352 |211 | |306 | 344 |353 |212 | |307 | 243 |354 |213 | |310 | 345 |355 |214 | |311 | 250 |356 |215 | |312 | 251 |357 |216 | |313 | 252 |360 |217 | |314 | 253 |361 |237 | |315 | 254 |362 |220 | |316 | 255 |363 |221 | |317 | 256 |364 |222 | |320 | 257 |365 |223 | |321 | 357 |366 |206 | |322 | 340 |367 |202 | |323 | 341 |370 |234 | |324 | 342 |371 |233 | |325 | 343 |372 |207 | |326 | 246 |373 |230 | |327 | 242 |374 |235 | |330 | 354 |375 |231 | |331 | 353 |376 |227 | |332 | 247 | | | +---------------+----------------+----------------+---------------+ KOI8-R to MS 1251 For the conversion of KOI8-R to MS 1251, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | KOI8-R | MS 1251 | KOI8-R | MS 1251 | |24 | 4 |317 |356 | |200-237 | 40 |320 |357 | |241 | 220 |321 |377 | |242 | 203 |322 |360 | |243 | 270 |323 |361 | |244 | 272 |324 |362 | |245 | 276 |325 |363 | |246 | 263 |326 |346 | |247 | 277 |327 |342 | |250 | 274 |330 |374 | |251 | 232 |331 |373 | |252 | 234 |332 |347 | |253 | 236 |333 |370 | |254 | 235 |334 |375 | |255 | 210 |335 |371 | |256 | 242 |336 |367 | |257 | 237 |337 |372 | |260 | 271 |340 |336 | |261 | 200 |341 |300 | |262 | 201 |342 |301 | |263 | 250 |343 |326 | |264 | 252 |344 |304 | |265 | 275 |345 |305 | |266 | 262 |346 |324 | |267 | 257 |347 |303 | |270 | 243 |350 |325 | |271 | 212 |351 |310 | |272 | 214 |352 |311 | |273 | 216 |353 |312 | |274 | 215 |354 |313 | |275 | 210 |355 |314 | |276 | 241 |356 |315 | |277 | 217 |357 |316 | |300 | 376 |360 |317 | |301 | 340 |361 |337 | |302 | 341 |362 |320 | |303 | 366 |363 |321 | |304 | 344 |364 |322 | |305 | 345 |365 |323 | |306 | 364 |366 |306 | |307 | 343 |367 |302 | |310 | 365 |370 |334 | |311 | 350 |371 |333 | |312 | 351 |372 |307 | |313 | 352 |373 |330 | |314 | 353 |374 |335 | |315 | 354 |375 |331 | |316 | 355 |376 |327 | |376 | 227 | | | +---------------+----------------+----------------+---------------+ KOI8-R to Mac Cyrillic For the conversion of KOI8-R to Mac Cyrillic, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | KOI8-R | Mac Cyrillic | KOI8-R | Mac Cyrillic | |24 | 4 |317 |356 | |200-237 | 40 |320 |357 | |240 | 312 |321 |337 | |241 | 254 |322 |360 | |242 | 257 |323 |361 | |243 | 336 |324 |362 | |244 | 271 |325 |363 | |245 | 317 |326 |346 | |246 | 264 |327 |342 | |247 | 273 |330 |374 | |250 | 300 |331 |373 | |251 | 275 |332 |347 | |252 | 277 |333 |370 | |253 | 40 |334 |375 | |254 | 316 |335 |371 | |255 | 40 |336 |367 | |256 | 331 |337 |372 | |257 | 333 |340 |236 | |260 | 334 |341 |200 | |261 | 253 |342 |201 | |262 | 256 |343 |226 | |263 | 335 |344 |204 | |264 | 270 |345 |205 | |265 | 301 |346 |224 | |266 | 247 |347 |203 | |267 | 272 |350 |225 | |270 | 267 |351 |210 | |271 | 274 |352 |211 | |272 | 276 |353 |212 | |273 | 40 |354 |213 | |274 | 315 |355 |214 | |275 | 40 |356 |215 | |276 | 330 |357 |216 | |277 | 332 |360 |217 | |300 | 376 |361 |237 | |301 | 340 |362 |220 | |302 | 341 |363 |221 | |303 | 366 |364 |222 | |304 | 344 |365 |223 | |305 | 345 |366 |206 | |306 | 364 |367 |202 | |307 | 343 |370 |234 | |310 | 365 |371 |233 | |311 | 350 |372 |207 | |312 | 351 |373 |230 | |313 | 352 |374 |235 | |314 | 353 |375 |231 | |315 | 354 |376 |227 | |316 | 355 | | | +---------------+----------------+----------------+---------------+ FILES
/usr/lib/iconv/*.so conversion modules /usr/lib/iconv/*.t conversion tables /usr/lib/iconv/iconv_data list of conversions supported by conversion tables SEE ALSO
iconv(1), iconv(3C), iconv(5) SunOS 5.10 18 Apr 1997 iconv_koi8-r(5)