Sponsored Content
Full Discussion: Match to range in files
Top Forums Shell Programming and Scripting Match to range in files Post 302922421 by cmccabe on Friday 24th of October 2014 12:57:55 PM
Old 10-24-2014
Match to range in files

I am trying to create a script that will use the position in column A ($1) in 48850.txt and search for it in columns B ($2) in gene.txt. Then when it finds a match it copies the text in column A ($1) and places it in column C ($3) of 48850.txt. I have attached the files. Thank you Smilie.

Code:
 The first position in 48850.txt is chrX:138982061 and that is between chrX: 13789061-13956831 (row 25325 in gene.txt) and the text in column A ($1) is GPM6B.  So that text would be copied to column D ($4) of 48850.txt.

48850.txt
chrX:138982061	138982120	 A_16_P21610256    GPM6B

Thank you Smilie.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match a specific IP range

Hello all, I would like a bit of help with a problem I am having. I have the following example file: $ cat test_hosts 10.10.2.3 host1 10.10.2.4 host2 10.10.2.130 host3 10.10.2.5 host4 10.10.2.230 host5 10.10.2.22 host6 I need to match all IP addresses in the 10.10.2.1-10.10.2.22... (5 Replies)
Discussion started by: sylaan
5 Replies

2. Shell Programming and Scripting

match range of different numbers by AWK

if the column1 and 2 in both files has same key (for example "a" and "a1") compare each first key value(a1 of a) of input2 (for example 1-4 or 65-69 not 70-100 or 44-40 etc) with all the values in input1. if the range of first key value in input2 is outof range in input1 values named it as out... (54 Replies)
Discussion started by: repinementer
54 Replies

3. UNIX for Dummies Questions & Answers

How to match 2 columns where one column has data as a range

Hi, I have a query about joining files using data ranges. Example files below - I want to join file1 to file2 with matches where file1 column 1 is equal to file2 column1, and file1 column 2 is within the range of file2 columns 3 and 4. I would like rows which don't match to be printed too. ... (4 Replies)
Discussion started by: auburn
4 Replies

4. Shell Programming and Scripting

awk to match a numeric range specified by two columns

Hi Everyone, Here's a snippet of my data: File 1 = testRef2: A1BG - 13208 13284 AAA1 - 34758475 34873943 AAAS - 53701240 53715412File 2 = 42MLN.3.bedS2: 13208 13208 13360 13363 13484 13518 13518My awk script: awk 'NR == FNR{a=$1;next} {$1>=a}{$1<=a}{print... (5 Replies)
Discussion started by: heecha
5 Replies

5. Shell Programming and Scripting

Awk numeric range match only one digit?

Hello, I have a text file with lines that look like this: 1974 12 27 -0.72743 -1.0169 2 1.25029 1974 12 28 -0.4958 -0.72926 2 0.881839 1974 12 29 -0.26331 -0.53426 2 0.595623 1974 12 30 7.71432E-02 -0.71887 3 0.723001 1974 12 31 0.187789 -1.07114 3 1.08748 1975 1 1 0.349933 -1.02217... (2 Replies)
Discussion started by: meridionaljet
2 Replies

6. UNIX for Dummies Questions & Answers

Display lines after match is found within specified range

I have a file which has collection of segments occuring n(For eg.100) times ISA GS ST NM1*85 N3 N4 NM1*IL N3 N4 REF*D9*1001 ISE GE SE ISA GS ST NM1*85 N3 (13 Replies)
Discussion started by: nsuresh316
13 Replies

7. Shell Programming and Scripting

Match on a range of numbers

Hi, I'm trying to match a filename that could be called anything from vout001 to vout252 and was trying to do a small test but I'm not getting the result I thought I would.. Can some one tell me what I'm doing wrong? *****@********>echo $mynumber ... (4 Replies)
Discussion started by: Jazmania
4 Replies

8. Shell Programming and Scripting

Match text in a range and copy value

In the files attached, I am trying to: if Files.txt $1 is in the range of Exons.txt $1, then in Files.txt $4 the value from Exons.txt $3 is copied else if no match is found Exons.txt $3 = "Intron" For example, the first value in File.txt $1 is chr1:14895-14944 and is not found in any range... (4 Replies)
Discussion started by: cmccabe
4 Replies

9. Shell Programming and Scripting

Get range out using sed or awk, only if given pattern match

Input: START OS:: UNIX Release: xxx Version: xxx END START OS:: LINUX Release: xxx Version: xxx END START OS:: Windows Release: xxx Version: xxx ENDHere i am trying to get all the information between START and END, only if i could match OS Type. I can get all the data between the... (3 Replies)
Discussion started by: Dharmaraja
3 Replies

10. UNIX for Beginners Questions & Answers

Match patterns between two files and extract certain range of strings

Hi, I need help to match patterns from between two different files and extract region of strings. inputfile1.fa >l-WR24-1:1 GCCGGCGTCGCGGTTGCTCGCGCTCTGGGCGCTGGCGGCTGTGGCTCTACCCGGCTCCGG GGCGGAGGGCGACGGCGGGTGGTGAGCGGCCCGGGAGGGGCCGGGCGGTGGGGTCACGTG... (4 Replies)
Discussion started by: bunny_merah19
4 Replies
XmTextFindString(3X)													      XmTextFindString(3X)

NAME
XmTextFindString - A Text function that finds the beginning position of a text string SYNOPSIS
#include <Xm/Xm.h> Boolean XmTextFindString (widget, start, string, direction, position) Widget widget; XmTextPosition start; char *string; XmTextDirection direction; XmTextPosition *position; DESCRIPTION
XmTextFindString locates the beginning position of a specified text string. This routine searches forward or backward for the first occur- rence of the string starting from the given start position. If it finds a match, the function returns the position of the first character of the string in position. Specifies the Text widget ID. Specifies the character position from which the search proceeds. This is an integer number of characters from the beginning of the text buffer. The first character position is 0. Specifies the search string. Indicates the search direction. It is relative to the primary direction of the text. The possible values are: The search proceeds toward the end of the text buffer. The search proceeds toward the beginning of the text buffer. Specifies the pointer in which the first charac- ter position of the string match is returned. This is an integer number of characters from the beginning of the buffer. The first charac- ter position is 0. If the function returns False, this value is undefined. For a complete definition of Text and its associated resources, see XmText(3X). RETURN VALUE
Returns True if a string match is found; otherwise, returns False. SEE ALSO
XmText(3X), XmTextFindStringWcs(3X) XmTextFindString(3X)
All times are GMT -4. The time now is 08:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy