Sponsored Content
Top Forums Shell Programming and Scripting Read column and find differences... Post 302723267 by empyrean on Monday 29th of October 2012 07:25:53 PM
Old 10-29-2012
Read column and find differences...

I have this file

Code:
427	A	C	A/C	12
436	G	C	G/C	12
445	C	T	C/T	12
447	A	G	A/G	9
451	T	C	T/C	5
456	A	G	A/G	12
493	G	A	G/A	12


I wanted to read the first column and find all other ids which are differences less than 10.
Code:
427	A	C	A/C	12	436
436	G	C	G/C	12	427,445
445	C	T	C/T	12	436,447,451
447	A	G	A/G	9	445,451,456
451	T	C	T/C	5	445,447,456
456	A	G	A/G	12	451,447
493	G	A	G/A	12

The last column should be like the above. All id's which are + or - 10 bases apart from that specific id. For example for 436, the boundaries are {426 - 446} other id's which are in that range are 427 and 445 so i displayed them in 6th column..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to read the column and print the values under that column

hi all:b:, how to read the column and print the values under that column ...?? file1 have something like this cat file1 ======= column1, column2,date,column3,column4..... 1, 23 , 12/02/2008,...... 2, 45, 14/05/2008,..... 3, 56, 16/03/2008,..... cat file2 =======... (6 Replies)
Discussion started by: gemini106
6 Replies

2. UNIX for Dummies Questions & Answers

Compare 2 files for a single column and output differences

Hi, I have a column in 2 different files which i want to compare, and output the results to a different file. The columns are in different positions in those 2 files. File 1 the column is in position 10-15 File 2 the column is in position 15-20 Please advise Thanks (1 Reply)
Discussion started by: samit_9999
1 Replies

3. Shell Programming and Scripting

Read CSV column value based on column name

Hi All, I am newbie to Unix I ve got assignment to work in unix can you please help me in this regard There is a sample CSV file "Username", "Password" "John1", "Scot1" "John2", "Scot2" "John3", "Scot3" "John4", "Scot4" If i give the column name as Password and row number as 4 the... (3 Replies)
Discussion started by: JohnGG
3 Replies

4. Shell Programming and Scripting

Running Differences Column

Hello everyone, I had such a helpful and quick response last time and it worked so perfectly, perhaps someone can help me with this problem I have (once again this is for research and not a homework problem). For instance, I have a file (varying numbers of rows, etc) with three columns of data... (2 Replies)
Discussion started by: Eblue562
2 Replies

5. HP-UX

Compare 2 systems to find any differences

Hi there, I have 2 machines running HP-UX. One off these controllers is able to send mail and the other cannot. I have looked at all the settings that I know and coannot find any differences. Is there a way to audit the 2 machinces by pulling all the settings then compare any differences? ... (2 Replies)
Discussion started by: lodey
2 Replies

6. Shell Programming and Scripting

Differences between 2 Flat Files and process the differences

Hi Hope you are having a great weeknd !! I had a question and need your expertise for this : I have 2 files File1 & File2(of same structure) which I need to compare on some columns. I need to find the values which are there in File2 but not in File 1 and put the Differences in another file... (5 Replies)
Discussion started by: newbie_8398
5 Replies

7. UNIX for Dummies Questions & Answers

Extracting combined differences based on a single column

Dear All, I have two sets of files. File 1 can be any number between 1 and 20 followed by a frequency of that number in a give documents... the lines in the file will be dependent to the analysed document. e.g. file1 1,5 4,1 then I have file two which is basicall same numbers but with... (2 Replies)
Discussion started by: A-V
2 Replies

8. Shell Programming and Scripting

How to do find differences between 2 XML Files?

Hello All, Requirement is to compare 2 XML files and see if there are any differences but from some of the providers We are receiving UTF-16 formatted XML file with no end of line as shown below. Excerpt of data file: ÿþ<^@?^@x^@m^@l^@ ^@v^@e^@r^@s^@i^@o^@n^@=^@"^@1^@.^@0^@"^@... (11 Replies)
Discussion started by: Ariean
11 Replies

9. Shell Programming and Scripting

Read first column and count lines in second column using awk

Hello all, I would like to ask your help here: I've a huge file that has 2 columns. A part of it is: sorted.txt: kss23 rml.67lkj kss23 zhh.6gf kss23 nhd.09.fdd kss23 hp.767.88.89 fl67 nmdsfs.56.df.67 fl67 kk.fgf.98.56.n fl67 bgdgdfg.hjj.879.d fl66 kl..hfh.76.ghg fl66... (5 Replies)
Discussion started by: Padavan
5 Replies

10. Shell Programming and Scripting

awk to find differences between two file

I am trying to find the differences between the two sorted, tab separated, attached files. Thank you :). In update2 there are 52,058 lines and in current2 there are 52,197 so 139 differences should result. However, awk 'FNR==NR{a;next}!($0 in a)' update2 current2 > out2comm -1 -3... (2 Replies)
Discussion started by: cmccabe
2 Replies
NSMB.CONF(5)						      BSD File Formats Manual						      NSMB.CONF(5)

NAME
nsmb.conf -- configuration file for SMB requests DESCRIPTION
The nsmb.conf file contains information about the computers and shares or mount points for the SMB network protocol. The configuration hierarchy is made up of several sections, each section containing a few or several lines of parameters and their assigned values. Each of these sections must begin with a section name enclosed within square brackets, similar to: [section_name] The end of each section is marked by either the start of a new section, or by the abrupt ending of the file, commonly referred to as the EOF. Each section may contain zero or more parameters such as: [section_name] key=value where key represents a parameter name, and value would be the parameter's assigned value. The SMB library uses the following information for section names: A) [default] B) [SERVER] C) [SERVER:SHARE] Possible keywords may include: Keyword Section Default Comment A B C Values addr - + - DNS name or IP address of server nbtimeout + + - 1s Timeout for resolving a NetBIOS name minauth + + - NTLMv2 Minimum authentication level allowed port445 + + - normal How to use SMB TCP/UDP ports streams + + + yes Use NTFS Streams if server supported soft + + + Make the mount soft notify_off + + + no Turn off using notifications kloglevel + - - 0 Turn on smb kernel logging protocol_vers_map + - - 7 Bitmap of SMB Versions that are enabled signing_required + - - no Turn on smb client signing signing_req_vers + - - 6 Bitmap of SMB Versions that have signing required validate_neg_off + - - no Turn off using validate negotiate max_resp_timeout + + - 30s Max time to wait for any response from server submounts_off + + + no Turn off using submounts dir_cache_async_cnt + + - 10 Max async queries to fill dir cache dir_cache_max + + - 60s Max time to cache for a dir dir_cache_min + + - 30s Min time to cache for a dir The minimum authentication level can be one of: kerberos Kerberos - NTLMv2, NTLM, LM, and plain-text password authentication are not attempted. ntlmv2 NTLMv2 - Kerberos authentication is attempted if a Kerberos token can be obtained, otherwise NTLMv2 authentication is attempted; if the server doesn't support encrypted passwords, the authentication fails. ntlm NTLM - Kerberos authentication is attempted if a Kerberos token can be obtained, otherwise NTLMv2 authentication is attempted and, if that fails, NTLMv1 authentication is attempted, with zeroes in the LM hash; if the server doesn't support encrypted passwords, the authentication fails. lm LM - Kerberos authentication is attempted if a Kerberos token can be obtained, otherwise NTLMv2 authentication is attempted and, if that fails, NTLMv1 authentication is attempted, including the LM hash; if the server doesn't support encrypted passwords, the authentication fails. none none - The same as lm except that, if the server doesn't support encrypted passwords, plain-text passwords are used. Required for servers that don't support extended security. (Note: "NetBIOS" as used below means "NetBIOS over TCP/IP.") "How to use SMB TCP/UDP ports" can be one of: normal Attempt to connect via port 445. If that is unsuccessful, try to connect via NetBIOS. netbios_only Do not attempt to connect via port 445. no_netbios Attempt to connect via port 445. If that is unsuccessful, do not try to connect via NetBIOS. "Bitmap of SMB Versions that are enabled" can be one of: 7 == 0111 SMB 1/2/3 should be enabled 6 == 0110 SMB 2/3 should be enabled 4 == 0100 SMB 3 should be enabled "Bitmap of SMB Versions that have signing required" can be one of: 7 Signing required for SMB 1/2/3. 6 Signing required for SMB 2/3. 4 Signing required for SMB 3. FILES
/etc/nsmb.conf The global configuration file. ~/Library/Preferences/nsmb.conf The user's configuration file, conflicts will be overwritten by the global file. EXAMPLES
What follows is a sample configuration file which may, or may not match your environment: # Configuration file for example.com [default] minauth=ntlmv2 streams=yes soft=yes notify_off=yes [WINXP] addr=windowsXP.apple.com All lines which begin with the '#' character are comments and will not be parsed. The ``default'' section specifies that only Kerberos and NTLMv2 authentication should be attempted; NTLM authentication should not be attempted if NTLMv2 authentication fails, and plain-text authen- tication should not be attempted if the server doesn't support encrypted passwords. SEE ALSO
smbutil(1), mount_smbfs(8) AUTHORS
This manual page was originally written by Sergey Osokin <osa@FreeBSD.org> and Tom Rhodes <trhodes@FreeBSD.org>. BSD
June 30, 2003 BSD
All times are GMT -4. The time now is 03:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy