Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Count specific characters at specific column positions
Top Forums Shell Programming and Scripting Count specific characters at specific column positions Post 302739597 by thienxho on Tuesday 4th of December 2012 12:58:27 PM
Old 12-04-2012
Quote:
Originally Posted by vgersh99
awk -f thie.awk myFile
where thie.awk is:
Code:
BEGIN {
  if (!chars) chars="A T G C"
  nchars=split(chars, charsA, FS)
}
{
  width=length($2)
  for(i=1;i<=width;i++)
   arr[substr($2,i,1),i]++
}
END {
  for(i=1;i<=nchars;i++) {
    printf("%s", charsA[i])
    for(j=1;j<=width;j++)
      printf("%s%d%s", OFS, arr[charsA[i],j], (j==width)?ORS:"")
  }
}

Hi vgersh99,

You solved my problem.

I tested your codes and compared them to my Excel count with a file of 800K rows. Both had same output.

Really appreciated your help.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

count characters in specific records

I have a text file which represents a http flow like this: HTTP/1.1 200 OK Date: Fri, 23 Jan 2009 17:16:24 GMT Server: Apache Last-Modified: Fri, 23 Jan 2009 17:08:03 GMT Accept-Ranges: bytes Cache-Control: max-age=540 Expires: Fri, 23 Jan 2009 17:21:31 GMT Vary: Accept-Encoding ... (1 Reply)
Discussion started by: littleboyblu
1 Replies

2. Shell Programming and Scripting

Insert a text from a specific row into a specific column using SED or AWK

Hi, I am having trouble converting a text file. I have been working for this whole day now, still i couldn't make it. Here is how the text file looks: _______________________________________________________ DEVICE STATUS INFORMATION FOR LOCATION 1: OPER STATES: Disabled E:Enabled ... (5 Replies)
Discussion started by: Issemael
5 Replies

3. Shell Programming and Scripting

Assigning a specific format to a specific column in a text file using awk and printf

Hi, I have the following text file: 8 T1mapping_flip02 ok 128 108 30 1 665000-000008-000001.dcm 9 T1mapping_flip05 ok 128 108 30 1 665000-000009-000001.dcm 10 T1mapping_flip10 ok 128 108 30 1 665000-000010-000001.dcm 11 T1mapping_flip15 ok 128 108 30... (2 Replies)
Discussion started by: goodbenito
2 Replies

4. UNIX for Dummies Questions & Answers

Unix command to count the number of files with specific characters in name

Hey all, I'm looking for a command that will search a directory (and all subdirectories) and give me a file count for the number of files that contain specific characters within its filename. e.g. I want to find the number of files that contain "-a.jpg" in their name. All the searching I've... (6 Replies)
Discussion started by: murphysm
6 Replies

5. Shell Programming and Scripting

How to count occurrences in a specific column

Hi, I need help to count the number of occurrences in $3 of file1.txt. I only know how to count by checking one by one and the code is like this: awk '$3 ~ /aku hanya poyo/ {++c} END {print c}' FS="\t" file1.txt But this is not wise to do as i have hundreds of different occurrences in that... (10 Replies)
Discussion started by: redse171
10 Replies

6. Shell Programming and Scripting

Can't figure out how to find specific characters in specific columns

I am trying to find a specific set of characters in a long file. I only want to find the characters in column 265 for 4 bytes. Is there a search for that? I tried cut but couldn't get it to work. Ex. I want to find '9999' in column 265 for 4 bytes. If it is in there, I want it to print... (12 Replies)
Discussion started by: Drenhead
12 Replies

7. Shell Programming and Scripting

Count specific column values

Hi all: quick question! I have the following data that resembles some thing like this: i am tired tired am i what is up hello people cool I want to count (or at least isolate) all of the unique elements in the 2nd column. I have tried this: cut -f 2 | uniq 'input' which does... (3 Replies)
Discussion started by: owwow14
3 Replies

8. Shell Programming and Scripting

Count frequency of unique values in specific column

Hi, I have tab-deliminated data similar to the following: dot is-big 2 dot is-round 3 dot is-gray 4 cat is-big 3 hot in-summer 5 I want to count the frequency of each individual "unique" value in the 1st column. Thus, the desired output would be as follows: dot 3 cat 1 hot 1 is... (5 Replies)
Discussion started by: owwow14
5 Replies

9. Shell Programming and Scripting

Overwrite specific column in xml file with the specific column from adjacent line

I have an xml file dumped from rrd file, that I want to "patch" so the xml file doesn't contain any blank hole in the resulting graph of the rrd file. Here is the file. <!-- 2015-10-12 14:00:00 WIB / 1444633200 --> <row><v> 4.0419731265e+07 </v><v> 4.5045912770e+06... (2 Replies)
Discussion started by: rk4k
2 Replies

10. Shell Programming and Scripting

Search and replace specific positions of specific lines

Hi, I have a file with hundreds of lines. I want to search for particular lines starting with 4000, search and replace the 137-139 position characters; which will be '000', with '036'. Can all of this be done without opening a temp file and then moving that temp file to the original file name. ... (7 Replies)
Discussion started by: dsid
7 Replies

LEARN ABOUT CENTOS

qrencode

QRENCODE(1)						      General Commands Manual						       QRENCODE(1)

NAME

       qrencode - Encode input data in a QR Code and save as a PNG or EPS image.

SYNOPSIS

       qrencode [OPTION]...  [STRING]

DESCRIPTION

       Libqrencode  is	a  library  for encoding data in a QR Code symbol, a kind of 2D symbology that can be scanned by handy terminals such as a
       mobile phone with CCD. The capacity of QR Code is up to 7000 digits or 4000 characters, and has high robustness.

       Qrencode is a utility software using libqrencode to encode string data in a QR Code and save as a PNG or EPS image.

OPTIONS

       -h, --help
	      display help message.

       -o FILENAME, --output=FILENAME
	      write image to FILENAME. If '-' is specified, the result will be output to standard output. If -S is given, structured  symbols  are
	      written to FILENAME-01.png, FILENAME-02.png, ... (suffix is removed from FILENAME, if specified)

       -s NUMBER, --size=NUMBER
	      specify the size of dot (pixel). (default=3)

       -l {LMQH}, --level={LMQH}
	      specify error collectin level from L (lowest) to H (highest). (default=L)

       -v NUMBER, --symversion=NUMBER
	      specify the version of the symbol. (default=auto)

       -m NUMBER, --margin=NUMBER
	      specify the width of margin. (default=4)

       -d NUMBER, --dpi=NUMBER
	      specify the DPI of the generated PNG. (default=72)

       -t {PNG,EPS,SVG,ANSI,ANSI256,ASCII,ASCIIi,UTF8,ANSIUTF8}
       --type={PNG,EPS,SVG,ANSI,ANSI256,ASCII,ASCIIi,UTF8,ANSIUTF8}
	      specify the type of the generated image. (default=PNG)

       -S, --structured
	      make structured symbols. Version must be specified.

       -k, --kanji
	      assume that the input text contains kanji (shift-jis).

       -c, --casesensitive
	      encode lower-case alphabet characters in 8-bit mode. (default)

       -i, --ignorecase
	      ignore case distinctions and use only upper-case characters.

       -8, --8bit
	      encode entire data in 8-bit mode. -k, -c and -i will be ignored.

       -M, --micro
	      encode in a Micro QR Code. (experimental)

       --foreground=RRGGBB[AA]
       --background=RRGGBB[AA]
	      specify foreground/background color in hexadecimal notation.  6-digit (RGB) or 8-digit (RGBA) form are supported.  Color output sup-
	      port available only in PNG and SVG.

       -V, --version
	      display the version number and copyrights of the qrencode.

       [STRING]
	      input data. If it is not specified, data will be taken from standard input.

EXAMPLES

       qrencode -l L -v 1 -o output.png 'Hello, world!'
	      encode into a symbol version 1, level L.

       qrencode -iSv 1 --output=output.png
	      read standard input and encode it into a structured-appended symbols in case-insensitive mode.

AUTHOR

       Written by Kentaro Fukuchi.

RESOURCES

       Main Web Site: http://fukuchi.org/works/qrencode/

       Source code repository: https://github.com/fukuchi/libqrencode/

COPYRIGHT

       Copyright (C) 2006-2012 Kentaro Fukuchi.

qrencode 3.4.1							   Oct. 9, 2012 						       QRENCODE(1)
All times are GMT -4. The time now is 02:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy