Sponsored Content
Top Forums Shell Programming and Scripting Count column data in a text file Post 302746947 by rangarasan on Thursday 20th of December 2012 08:32:07 AM
Old 12-20-2012
Quote:
Originally Posted by sathyaonnuix
Thanks Rangarasan. I will take this as a part of motivation and correct my mistakes.

To err is human Smilie
All is well Smilie Good spirit Smilie

Last edited by rangarasan; 12-20-2012 at 10:26 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grouping data numbers in a text file into prescribed intervals and count

I have a text file that contains numbers (listed from the smallest to the largest). For ex. 34 817 1145 1645 1759 1761 3368 3529 4311 4681 5187 5193 5199 5417 5682 . . (5 Replies)
Discussion started by: Lucky Ali
5 Replies

2. Shell Programming and Scripting

using awk to substitute data in a column delimited text file

using awk to substitute data in a column delimited text file hello i would like to use awk to do the following calculation from the following snippet. input file C;2390 ;CV BOUILLOTTE 2L 2FACES NERVUREES ;1.00 ;3552612239004;13417 ;25 ;50 ; 12;50000 ; ; ... (3 Replies)
Discussion started by: iindie
3 Replies

3. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Can anyone please help with this? I have 2 files as given below. If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value. file1 abc_1 foo1@a .... abc_1 soo2@a ... def_2 soo2@a .... def_2 foo1@a ........ (7 Replies)
Discussion started by: prashali
7 Replies

4. Shell Programming and Scripting

Count column data

Hi Guys, B07 U51C A1 44 B1 44 Yes B07 L64U A2 44 B1 44 Yes B07 L62U A2 44 B1 44 Yes B07 L11C A4 32 B1 44 NO B05 L12Z A1 12 B1 44 NO B01 651Z A2 44 B1 44 NO B04 A51Z A2 12 B1 44 NO L07 B08D A4 12 B1 44 NO B07 RU8D A4 44 B1 44 Yes B07 L58D A4 15 B1 44 No B07 LA8D A4 44 B1 44 Yes B07... (6 Replies)
Discussion started by: asavaliya
6 Replies

5. Shell Programming and Scripting

Advanced: Sort, count data in column, append file name

Hi. I am not sure the title gives an optimal description of what I want to do. Also, I tried to post this in the "UNIX for Dummies Questions & Answers", but it seems no-one was able to help out. I have several text files that contain data in many columns. All the files are organized the same... (14 Replies)
Discussion started by: JamesT
14 Replies

6. Shell Programming and Scripting

Generate tabular data based on a column value from an existing data file

Hi, I have a data file with : 01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083 I... (1 Reply)
Discussion started by: himanish
1 Replies

7. Shell Programming and Scripting

Compare 2 text file with 1 column in each file and write mismatch data to 3rd file

Hi, I need to compare 2 text files with around 60000 rows and 1 column. I need to compare these and write the mismatch data to 3rd file. File1 - file2 = file3 wc -l file1.txt 58112 wc -l file2.txt 55260 head -5 file1.txt 101214200123 101214700300 101250030067 101214100500... (10 Replies)
Discussion started by: Divya Nochiyil
10 Replies

8. Shell Programming and Scripting

Change data in one column with data from another file's column

Hello, I have this file outputData: # cat /tmp/outputData __Capacity^6^NBSC01_Licences^L3_functionality_for_ESB_switch __Capacity^2100^NBSC01_Licences^Gb_over_IP __Capacity^1837^NBSC01_Licences^EDGE_BSS_Fnc __Capacity^1816^NBSC01_Licences^GPRS_CS3_and_CS4... (1 Reply)
Discussion started by: nypreH
1 Replies

9. Shell Programming and Scripting

Column to row and position data in a text file

Hi everyone.. I have a list of values in a file... a, b, c, 1, 2, 3, aaaa, bbbbb, I am interested in converting this column to a row.. "text",aaaa, bbbb a,1 (7 Replies)
Discussion started by: manihi
7 Replies

10. UNIX for Beginners Questions & Answers

How to insert data into black column( Secound Column ) in excel (.XLSX) file using shell script?

Source Code of the original script is down below please run the script and try to solve this problem this is my data and I want it column wise 2019-03-20 13:00:00:000 2019-03-20 15:00:00:000 1 Operating System LAB 0 1 1 1 1 1 1 1 1 1 0 1 (5 Replies)
Discussion started by: Shubham1182
5 Replies
ascii(5)							File Formats Manual							  ascii(5)

NAME
ascii - map of ASCII character set SYNOPSIS
DESCRIPTION
The file provides a map of the ASCII character set, giving both octal and hexadecimal equivalents of each character. The file contains the following text: |000 nul|001 soh|002 stx|003 etx|004 eot|005 enq|006 ack|007 bel| |010 bs |011 ht |012 nl |013 vt |014 np |015 cr |016 so |017 si | |020 dle|021 dc1|022 dc2|023 dc3|024 dc4|025 nak|026 syn|027 etb| |030 can|031 em |032 sub|033 esc|034 fs |035 gs |036 rs |037 us | |040 sp |041 ! |042 " |043 # |044 $ |045 % |046 & |047 ' | |050 ( |051 ) |052 * |053 + |054 , |055 - |056 . |057 / | |060 0 |061 1 |062 2 |063 3 |064 4 |065 5 |066 6 |067 7 | |070 8 |071 9 |072 : |073 ; |074 < |075 = |076 > |077 ? | |100 @ |101 A |102 B |103 C |104 D |105 E |106 F |107 G | |110 H |111 I |112 J |113 K |114 L |115 M |116 N |117 O | |120 P |121 Q |122 R |123 S |124 T |125 U |126 V |127 W | |130 X |131 Y |132 Z |133 [ |134 |135 ] |136 ^ |137 _ | |140 ` |141 a |142 b |143 c |144 d |145 e |146 f |147 g | |150 h |151 i |152 j |153 k |154 l |155 m |156 n |157 o | |160 p |161 q |162 r |163 s |164 t |165 u |166 v |167 w | |170 x |171 y |172 z |173 { |174 | |175 } |176 ~ |177 del| | 00 nul| 01 soh| 02 stx| 03 etx| 04 eot| 05 enq| 06 ack| 07 bel| | 08 bs | 09 ht | 0a nl | 0b vt | 0c np | 0d cr | 0e so | 0f si | | 10 dle| 11 dc1| 12 dc2| 13 dc3| 14 dc4| 15 nak| 16 syn| 17 etb| | 18 can| 19 em | 1a sub| 1b esc| 1c fs | 1d gs | 1e rs | 1f us | | 20 sp | 21 ! | 22 " | 23 # | 24 $ | 25 % | 26 & | 27 ' | | 28 ( | 29 ) | 2a * | 2b + | 2c , | 2d - | 2e . | 2f / | | 30 0 | 31 1 | 32 2 | 33 3 | 34 4 | 35 5 | 36 6 | 37 7 | | 38 8 | 39 9 | 3a : | 3b ; | 3c < | 3d = | 3e > | 3f ? | | 40 @ | 41 A | 42 B | 43 C | 44 D | 45 E | 46 F | 47 G | | 48 H | 49 I | 4a J | 4b K | 4c L | 4d M | 4e N | 4f O | | 50 P | 51 Q | 52 R | 53 S | 54 T | 55 U | 56 V | 57 W | | 58 X | 59 Y | 5a Z | 5b [ | 5c | 5d ] | 5e ^ | 5f _ | | 60 ` | 61 a | 62 b | 63 c | 64 d | 65 e | 66 f | 67 g | | 68 h | 69 i | 6a j | 6b k | 6c l | 6d m | 6e n | 6f o | | 70 p | 71 q | 72 r | 73 s | 74 t | 75 u | 76 v | 77 w | | 78 x | 79 y | 7a z | 7b { | 7c | | 7d } | 7e ~ | 7f del| Control Characters The following table shows the set of ASCII control characters with their octal, decimal, and hexadecimal values. To obtain the respective characters from the keyboard, use the indicated keypress combinations. To place control characters in a file when using the or editor, type Ctrl-before typing the desired control character. +----+-----+-----+---------+--------+------------------------+--------------+ |Oct | Dec | Hex | Display | Symbol | Char Name | Keypress | +----+-----+-----+---------+--------+------------------------+--------------+ |000 | 000 | 00 | none | NUL | Null | Ctrl-Shift-@ | |001 | 001 | 01 | ^A | SOH | Start of Header | Ctrl-A | |002 | 002 | 02 | ^B | STX | Start of Text | Ctrl-B | |003 | 003 | 03 | ^C | ETX | End of Text | Ctrl-C | |004 | 004 | 04 | ^D | EOT | End of Transmission | Ctrl-D | |005 | 005 | 05 | ^E | ENQ | Enquire | Ctrl-E | |006 | 006 | 06 | ^F | ACK | Acknowledge | Ctrl-F | |007 | 007 | 07 | ^G | BEL | Bell | Ctrl-G | +----+-----+-----+---------+--------+------------------------+--------------+ |010 | 008 | 08 | ^H | BS | Back Space | Ctrl-H | |011 | 009 | 09 | ^I | HT | Horizontal Tab | Ctrl-I | |012 | 010 | 0A | ^J | LF | Line Feed | Ctrl-J | |013 | 011 | 0B | ^K | VT | Vertical Tab | Ctrl-K | |014 | 012 | 0C | ^L | FF | Form Feed | Ctrl-L | |015 | 013 | 0D | ^M | CR | Carriage Return | Ctrl-M | |016 | 014 | 0E | ^N | SO | Shift Out | Ctrl-N | |017 | 015 | 0F | ^O | SI | Shift In | Ctrl-O | +----+-----+-----+---------+--------+------------------------+--------------+ |020 | 016 | 10 | ^P | DLE | Data Link Escape | Ctrl-P | |021 | 017 | 11 | ^Q | DC1 | Device Control 1 | Ctrl-Q | |022 | 018 | 12 | ^R | DC2 | Device Control 2 | Ctrl-R | |023 | 019 | 13 | ^S | DC3 | Device Control 3 | Ctrl-S | |024 | 020 | 14 | ^T | DC4 | Device Control 4 | Ctrl-T | |025 | 021 | 15 | ^U | NAK | Negative Acknowledge | Ctrl-U | |026 | 022 | 16 | ^V | SYN | Synchronize | Ctrl-V | |027 | 023 | 17 | ^W | ETB | End Transmission Block | Ctrl-W | +----+-----+-----+---------+--------+------------------------+--------------+ |030 | 024 | 18 | ^X | CAN | Cancel | Ctrl-X | |031 | 025 | 19 | ^Y | EM | End of Medium | Ctrl-Y | |032 | 026 | 1A | ^Z | SUB | Substitute | Ctrl-Z | |033 | 027 | 1B | ^[ | ESC | Escape | Ctrl-[ | |034 | 028 | 1C | ^ | FS | File Separator | Ctrl- | |035 | 029 | 1D | ^] | GS | Group Separator | Ctrl-] | |036 | 030 | 1E | ^^ | RS | Record Separator | Ctrl-Shift-^ | |037 | 031 | 1F | ^_ | US | Unit Separator | Ctrl-Shift-_ | +----+-----+-----+---------+--------+------------------------+--------------+ |177 | 127 | 7F | ^? | DEL | Delete | DEL | +----+-----+-----+---------+--------+------------------------+--------------+ WARNINGS
Note that some HP-UX subsystems, such as the keyboard interface, window systems, and other system software, may use selected keyboard con- trol characters for special purposes, possibly causing unexpected results. FILES
ascii(5)
All times are GMT -4. The time now is 11:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy