10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
Hi,
I have 2 tab-delimited input files as follows.
file1.tab:
green A apple
red B apple
file2.tab:
apple - A;Z
Objective:
Return $1 of file1 if,
. $1 of file2 matches $3 of file1 and,
. any single element (separated by ";") in $3 of file2 is present in $2 of file1
In order to... (3 Replies)
Discussion started by: beca123456
3 Replies
2. Shell Programming and Scripting
Hi, I'm trying to use awk arrays to compare values across two files based on multiple columns. I've attempted to load file 2 into an array and compare with values in file 1, but success has been absent. If anyone has any suggestions (and I'm not even sure if my script so far is on the right lines)... (4 Replies)
Discussion started by: hubleo
4 Replies
3. Shell Programming and Scripting
Need Assistance . Using wget how can i download multiple files from http site. Http doesnt has wild card (*) but FTP has it . Any ideas will be appreciative.
wget --timeout=120 --append-output=output.txt --no-directories --cut-dirs=1 -np -m --accept=grib2 -r http://sample.com/... (4 Replies)
Discussion started by: ajayram_arya
4 Replies
4. Shell Programming and Scripting
I have a csv dump from sql server that needs to be converted so it can be feed to another program. I already sorted on field 1 but there are multiple columns with same field 1 where it needs to be compared against and if it is same then append field 5.
i.e from
ANG SJ,0,B,LC22,LC22(0)
BAT... (2 Replies)
Discussion started by: nike27
2 Replies
5. Shell Programming and Scripting
Dear All,
I want to compare File1 and File2 (Separated by spaces) using four fields (Column 1,2,4,5).
Logic: If column 1 and 2 of File1 and File2 match exactly and if the File2 has the same characters as any of the characters present in column 4 and 5 of file1 then those lines of file1 and file2... (6 Replies)
Discussion started by: NamS
6 Replies
6. Shell Programming and Scripting
I want to compare File1 and File2 (Separated by spaces) using four fields (Column 1,2,4,5).
Logic: If column 1 and 2 of File1 and File2 match exactly and if the File2 has the same characters as any of the characters present in column 4 and 5 of file1 then those lines of file1 and file2 are... (1 Reply)
Discussion started by: NamS
1 Replies
7. Shell Programming and Scripting
Hi All,
I am looking for an awk script to do the following
Join the fields together only if the first 4 fields are same.
Can it be done with join function in awk??
a,b,c,d,8,,,
a,b,c,d,,7,,
a,b,c,d,,,9,
a,b,p,e,8,,,
a.b,p,e,,9,,
a,b,p,z,,,,9
a,b,p,z,,8,,
desired output:
... (1 Reply)
Discussion started by: aksijain
1 Replies
8. Programming
Hi,
I have two files formatted as following:
File 1: (user_num_ID , realID) (the NR here is 41671)
1 cust_034_60
2 cust_80_91
3 cust_406_4
..
..
File 2: (realID , clusterNumber) (total NR here is 1000)
cust_034_60 2
cust_406_4 3
..
.. (11 Replies)
Discussion started by: amarn
11 Replies
9. Shell Programming and Scripting
Hi,
i want to compare two files by one field say $3 in file1 needs to compare with $2 in file2.
sample file1 - reqd_charge_code
2263881188,24570896,439
2263881964,24339077,439
2263883220,22619162,228
2263884224,24631840,442
2263884246,22612161,442
sample file2 - rg_j
... (2 Replies)
Discussion started by: raghavendra.cse
2 Replies
10. Shell Programming and Scripting
I am trying to print the output of a command to two separate files. Is it possible to use awk to print $1 to one file and $2 to another file?
Thanks in advance! (1 Reply)
Discussion started by: TheCrunge
1 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)