I have two files with multiple columns separated by commas.
I want to search one column from the first file in the second file;
If there is a matching, will append that matched row to the first file. Let me show an example... (unique values in the search column)
First file
aa,reg1,bb,cc,dd,ff... (6 Replies)
hi,
i am facing a problem in merging two files using awk,
the problem is as stated below,
file1:
A|B|C|D|E|F|G|H|I|1
M|N|O|P|Q|R|S|T|U|2
AA|BB|CC|DD|EE|FF|GG|HH|II|1
....
....
....
file2 :
1|Mn|op|qr (2 Replies)
Hi,
I have a master file that i need to split into multiple files based on matched patterns. sample of my data as follows:-
scaff_1 a e 123 130 c_scaff_100
scaff_1 a e 132 138 c_scaff_101
scaff_1 a e 140 150 ... (2 Replies)
Hi,
I have a file (sorted by sort) with 8 tab delimited columns. The first column contains duplicated fields and I need to merge all these identical lines.
My input file:
comp100002 aaa bbb ccc ddd eee fff ggg
comp100003 aba aba aba aba aba aba aba
comp100003 fff fff fff fff fff fff fff... (5 Replies)
Hi,
I need help to find matched patterns in 30 files residing in a folder simultaneously. All these files only contain 1 column. For example,
File1
Gr_1
st-e34ss-11dd
bt-wwd-fewq
pt-wq02-ddpk
pw-xsw17-aqpp
Gr_2
srq-wy09-yyd9
sqq-fdfs-ffs9
Gr_3
etas-qqa-dfw
ddw-ppls-qqw... (10 Replies)
Hi,
Please excuse me , i have searched unix forum, i am unable to find what i expect ,
my query is , i have 2 files of same structure and having 1 similar field/column , i need to merge 2 tables/files based on the one matched field/column (that is field 1),
file 1:... (5 Replies)
Hi,
I am trying to extract some patterns from a line. The input file is space delimited and i could not use column to get value after "IN" or "OUT" patterns as there could be multiple white spaces before the next digits that i need to print in the output file . I need to print 3 patterns in a... (3 Replies)
Hello all,
I have since given up trying to figure this out and used sed instead, but I am trying to understand awk and was wondering how someone might do this in awk.
I am trying to match on the first field of a specific file with the first field on multiple files, and append the second field... (2 Replies)
Hello, everyone
I have two files like this:
File 1: A
B
C
D
E
FFile 2:A B 1
A C 2
A K 3
B A 4
D E 3
W X 2
A B 2I want to print all lines (file2) that the first two columns are consist of elements from file1.
So, what I expected is :
A B 1
A B 2 (2 Replies)
Hello.
For a given folder, I want to select any files find $PATH1 -f \( -name "*" but omit any files like pattern name ! -iname "*.jpg" ! -iname "*.xsession*" ..... \) and also omit any subfolder like pattern name -type d \( -name "/etc/gconf/gconf.*" -o -name "*cache*" -o -name "*Cache*" -o... (2 Replies)
Discussion started by: jcdole
2 Replies
LEARN ABOUT SUNOS
iconv_dhn
iconv_dhn(5) Standards, Environments, and Macros iconv_dhn(5)NAME
iconv_dhn - code set conversion tables for DHN (Dom Handlowy Nauki)
DESCRIPTION
The following code set conversions are supported:
+--------------------------------------------------------------------+
| Code Set Conversions Supported |
+--------------+--------+--------------+--------+--------------------+
| Code |Symbol |Target Code |Symbol | Target Output |
+--------------+--------+--------------+--------+--------------------+
|DHN |dhn |ISO 8859-2 |iso2 | ISO Latin 2 |
+--------------+--------+--------------+--------+--------------------+
|DHN |dhn |MS 1250 |win2 | Windows Latin 2 |
+--------------+--------+--------------+--------+--------------------+
|DHN |dhn |MS 852 |dos2 | MS-DOS Latin 2 |
+--------------+--------+--------------+--------+--------------------+
|DHN |dhn |Mazovia |maz | Mazovia |
+--------------+--------+--------------+--------+--------------------+
CONVERSIONS
The conversions are performed according to the following tables. All values in the tables are given in octal.
DHN to ISO 8859-2
For the conversion of DHN to ISO 8859-2, all characters not in the following table are mapped unchanged.
+-----------------------------------------------------------------+
| | Conversions|Performed | |
| DHN | ISO 8859-2 | DHN | ISO 8859-2 |
|24-177 | 40 |222 |40 |
|200 | 241 |223 |364 |
|201 | 306 |224 |366 |
|202 | 312 |225-230 |40 |
|203 | 243 |231 |326 |
|204 | 321 |232 |334 |
|205 | 323 |233-237 |40 |
|206 | 246 |240 |341 |
|207 | 254 |241 |355 |
|210 | 257 |242 |363 |
|211 | 261 |243 |372 |
|212 | 346 |244-340 |40 |
|213 | 352 |341 |337 |
|214 | 263 |342-365 |40 |
|215 | 361 |366 |367 |
|216 | 363 |367 |40 |
|217 | 266 |370 |260 |
|220 | 274 |371-376 |40 |
|221 | 277 | | |
+---------------+----------------+----------------+---------------+
DHN to MS 1250
For the conversion of DHN to MS 1250, all characters not in the following table are mapped unchanged.
+-----------------------------------------------------------------+
| | Conversions|Performed | |
| DHN | MS 1250 | DHN | MS 1250 |
|200 | 245 |233-237 |40 |
|201 | 306 |240 |341 |
|202 | 312 |241 |355 |
|203 | 243 |242 |363 |
|204 | 321 |243 |372 |
|205 | 323 |244-251 |40 |
|206 | 214 |252 |254 |
|207 | 217 |253-255 |40 |
|210 | 257 |256 |253 |
|211 | 271 |257 |273 |
|212 | 346 |260-340 |40 |
|213 | 352 |341 |337 |
|214 | 263 |342-345 |40 |
|215 | 361 |346 |265 |
|216 | 363 |347-360 |40 |
|217 | 234 |361 |261 |
|220 | 237 |362-365 |40 |
|221 | 277 |366 |367 |
|222 | 40 |367 |40 |
|223 | 364 |370 |260 |
|224 | 366 |371 |40 |
|225-230 | 40 |372 |267 |
|231 | 326 |373-376 |40 |
|232 | 334 | | |
+---------------+----------------+----------------+---------------+
DHN to MS 852
For the conversion of DHN to MS 852, all characters not in the following table are mapped unchanged.
+-----------------------------------------------------------------+
| | Conversions|Performed | |
| DHN | MS 852 | DHN | MS 852 |
|200 | 244 |212 |206 |
|201 | 217 |213 |251 |
|202 | 250 |214 |210 |
|203 | 235 |215 |344 |
|204 | 343 |216 |242 |
|205 | 340 |217 |230 |
|206 | 227 |220 |253 |
|207 | 215 |221 |276 |
|210 | 275 |222-375 |40 |
|211 | 245 | | |
+---------------+----------------+----------------+---------------+
DHN to Mazovia
For the conversion of DHN to Mazovia, all characters not in the following table are mapped unchanged.
+-----------------------------------------------------------------+
| | Conversions|Performed | |
| DHN | Mazovia | DHN | Mazovia |
|200 | 217 |212 |215 |
|201 | 225 |213 |221 |
|202 | 220 |214 |222 |
|203 | 234 |215 |244 |
|204 | 245 |216 |242 |
|205 | 243 |217 |236 |
|206 | 230 |220 |246 |
|207 | 240 |221 |247 |
|210 | 241 |222-247 |40 |
|211 | 206 | | |
+---------------+----------------+----------------+---------------+
FILES
/usr/lib/iconv/*.so conversion modules
/usr/lib/iconv/*.t conversion tables
/usr/lib/iconv/iconv_data list of conversions supported by conversion tables
SEE ALSO iconv(1), iconv(3C), iconv(5)SunOS 5.10 18 Apr 1997 iconv_dhn(5)