file column length using awk

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk: Matching Pattern From other file with length

Hi, I have input file whose first column needs(match.txt) to be matched with the first column of the input file with min & max length as defined in match.txt. But conditions are not matching. Please help on the changes in the code below as for multiple enteries in match.txt complete match.txt will...

2. Shell Programming and Scripting

Splitting fixed length file using awk

Hi, I need to split a fixed length file of 160 characters based on value of a column. Example: ABC 456780001 DGDG SDFSF BCD 444440002 SSSS TTTTT ABC 777750003 HHHH UUUUU THH 888880001 FFFF LLLLLL HHH 999990002 GGGG OOOOO I need to split this file on basis of column from...

3. Shell Programming and Scripting

Awk: Need help replacing a specific column in a file by part of a column in another file

Hi, I have two input files as File1 : ABC:client1:project1 XYZ:client2-aa:project2 DEF:client4:proj File2 : client1:W-170:xx client2-aa:WT-04:yy client4:L-005A:zz Also, array of valid values can be hardcoded like Output : ABC:W:project1 XYZ:WT:project2

4. Shell Programming and Scripting

awk get length of a binary file.

Hi.. Just got a problem with awk and cannot figure out whats the issue. I am not really expert in awk so looking for help/opinion from experts Command is $ cat abinaryfile | sed -e "s/@@//g;s/@$//" | awk ' begin {} { printf(length($0)); }' Well its a binary file and I am...

5. Shell Programming and Scripting

Need to extract data from Column having variable length column

Hi , I need to extract data from below mentioned data, having no delimiter and havin no fixed column length. For example: Member nbr Ref no date 10000 1000 10202012 200000 2000 11202012 Output: to update DB with memeber nbr on basis of ref no. ...

6. Shell Programming and Scripting

Finding multiple column values and match in a fixed length file

Hi, I have a fixed length file where I need to verify the values of 3 different fields, where each field will have a different value. How can I do that in a single step.

7. Shell Programming and Scripting

how to fix the column length in a file using Awk Prog

Hi I use the following code to read the file and to fix the length of the column of the record in the file 'Sample.txt' ls Samp* | awk ' { a=$1 } END{ FS="n" for(i=1;i<=NR;i++) { while( getline < a ) { f1=$0; print("Line::",f1); f2=substr(f1,1,10) print("Field1::",f2);...

8. UNIX for Dummies Questions & Answers

Convert a tab delimited/variable length file to fixed length file

Hi, all. I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file: 10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783 19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657 And this is the expected...

9. Shell Programming and Scripting

print a file with one column having fixed character length

Hi guys, I have tried to find a solution for this problem but couln't. If anyone of you have an Idea do help me. INPUT_FILE with three columns shown to be separated by - sign A5BNK723NVI - 1 - 294 A7QZM0VIT - 251 - 537 A7NU3411V - 245 - 527 I want an output file in which First column...

10. Shell Programming and Scripting

Comparing column of variable length anf fixed width file

Hi, I have two input files. File1: ID Name Place 1-234~name1~Newyork 1-34~name2~Boston 1-2345~name3~Hungary File1 is a variable length file where each column is seperated by delimitter "~". File2: ID Country 1-34<<11 SPACES>>USA<<7 spaces>> 1-234<<10 SPACES>>UK<<8...

LEARN ABOUT OPENSOLARIS

iconv_koi8-r

iconv_koi8-r(5)                                         Standards, Environments, and Macros                                        iconv_koi8-r(5)

NAME

       iconv_koi8-r - code set conversion tables for KOI8-R

DESCRIPTION

       The following code set conversions are supported:

       +-------------------------------------------------------------------------+
       |                     Code Set Conversions Supported                      |
       +--------------+--------+--------------+--------+-------------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |      Target Output      |
       +--------------+--------+--------------+--------+-------------------------+
       |KOI8-R        |koi8    |ISO 8859-5    |iso5    | ISO 8859-5 Cyrillic     |
       +--------------+--------+--------------+--------+-------------------------+
       |KOI8-R        |koi8    |PC Cyrillic   |alt     | Alternative PC Cyrillic |
       +--------------+--------+--------------+--------+-------------------------+
       |KOI8-R        |koi8    |MS 1251       |win5    | Windows Cyrillic        |
       +--------------+--------+--------------+--------+-------------------------+
       |KOI8-R        |koi8    |Mac Cyrillic  |mac     | Macintosh Cyrillic      |
       +--------------+--------+--------------+--------+-------------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   KOI8-R to ISO 8859-5
       For the conversion of KOI8-R to ISO 8859-5, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |    KOI8-R     |  ISO 8859-5    |    KOI8-R      |  ISO 8859-5   |
       |24             | 4              |320             |337            |
       |241            | 362            |321             |357            |
       |242            | 363            |322             |340            |
       |243            | 361            |323             |341            |
       |244            | 364            |324             |342            |
       |245            | 365            |325             |343            |
       |246            | 366            |327             |322            |
       |247            | 367            |330             |354            |
       |250            | 370            |331             |353            |
       |251            | 371            |332             |327            |
       |252            | 372            |333             |350            |
       |253            | 373            |334             |355            |
       |254            | 374            |335             |351            |
       |256            | 376            |336             |347            |
       |257            | 377            |337             |352            |
       |260            | 360            |340             |316            |
       |261            | 242            |341             |260            |
       |262            | 243            |342             |261            |
       |263            | 241            |343             |306            |
       |264            | 244            |344             |264            |
       |265            | 245            |345             |265            |
       |266            | 246            |346             |304            |
       |267            | 247            |347             |263            |
       |270            | 250            |350             |305            |
       |271            | 251            |351             |270            |
       |272            | 252            |352             |271            |
       |273            | 253            |353             |272            |
       |274            | 254            |354             |273            |
       |275            | 255            |355             |274            |
       |276            | 256            |356             |275            |
       |277            | 257            |357             |276            |
       |300            | 356            |360             |277            |
       |301            | 320            |361             |317            |
       |302            | 321            |362             |300            |
       |303            | 346            |363             |301            |
       |304            | 324            |364             |302            |
       |305            | 325            |365             |303            |
       |306            | 344            |366             |266            |
       |307            | 323            |367             |262            |
       |310            | 345            |370             |314            |
       |311            | 330            |371             |313            |
       |312            | 331            |372             |267            |
       |313            | 332            |373             |310            |
       |314            | 333            |374             |315            |
       |315            | 334            |375             |311            |
       |316            | 335            |376             |307            |
       |317            | 336            |                |               |
       +---------------+----------------+----------------+---------------+

   KOI8-R to PC Cyrillic
       For the conversion of KOI8-R to PC Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |    KOI8-R     |  PC Cyrillic   |    KOI8-R      | PC Cyrillic   |
       |24             | 4              |333             |350            |
       |200-242        | 40             |334             |355            |
       |243            | 361            |335             |351            |
       |244-254        | 40             |336             |347            |
       |255            | 260            |337             |352            |
       |256-262        | 40             |340             |236            |
       |263            | 360            |341             |200            |
       |264-274        | 40             |342             |201            |
       |275            | 260            |343             |226            |
       |276-277        | 40             |344             |204            |
       |300            | 356            |345             |205            |
       |301            | 240            |346             |224            |
       |302            | 241            |347             |203            |
       |303            | 346            |350             |225            |
       |304            | 244            |351             |210            |
       |305            | 245            |352             |211            |
       |306            | 344            |353             |212            |
       |307            | 243            |354             |213            |
       |310            | 345            |355             |214            |
       |311            | 250            |356             |215            |
       |312            | 251            |357             |216            |
       |313            | 252            |360             |217            |
       |314            | 253            |361             |237            |
       |315            | 254            |362             |220            |
       |316            | 255            |363             |221            |
       |317            | 256            |364             |222            |
       |320            | 257            |365             |223            |
       |321            | 357            |366             |206            |
       |322            | 340            |367             |202            |
       |323            | 341            |370             |234            |
       |324            | 342            |371             |233            |
       |325            | 343            |372             |207            |
       |326            | 246            |373             |230            |
       |327            | 242            |374             |235            |
       |330            | 354            |375             |231            |
       |331            | 353            |376             |227            |
       |332            | 247            |                |               |
       +---------------+----------------+----------------+---------------+

   KOI8-R to MS 1251
       For the conversion of KOI8-R to MS 1251, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |    KOI8-R     |    MS 1251     |    KOI8-R      |   MS 1251     |
       |24             | 4              |317             |356            |
       |200-237        | 40             |320             |357            |
       |241            | 220            |321             |377            |
       |242            | 203            |322             |360            |
       |243            | 270            |323             |361            |
       |244            | 272            |324             |362            |
       |245            | 276            |325             |363            |
       |246            | 263            |326             |346            |
       |247            | 277            |327             |342            |
       |250            | 274            |330             |374            |
       |251            | 232            |331             |373            |
       |252            | 234            |332             |347            |
       |253            | 236            |333             |370            |
       |254            | 235            |334             |375            |
       |255            | 210            |335             |371            |
       |256            | 242            |336             |367            |
       |257            | 237            |337             |372            |
       |260            | 271            |340             |336            |
       |261            | 200            |341             |300            |
       |262            | 201            |342             |301            |
       |263            | 250            |343             |326            |
       |264            | 252            |344             |304            |
       |265            | 275            |345             |305            |
       |266            | 262            |346             |324            |
       |267            | 257            |347             |303            |
       |270            | 243            |350             |325            |
       |271            | 212            |351             |310            |
       |272            | 214            |352             |311            |
       |273            | 216            |353             |312            |
       |274            | 215            |354             |313            |
       |275            | 210            |355             |314            |
       |276            | 241            |356             |315            |
       |277            | 217            |357             |316            |
       |300            | 376            |360             |317            |
       |301            | 340            |361             |337            |
       |302            | 341            |362             |320            |
       |303            | 366            |363             |321            |
       |304            | 344            |364             |322            |
       |305            | 345            |365             |323            |
       |306            | 364            |366             |306            |
       |307            | 343            |367             |302            |
       |310            | 365            |370             |334            |
       |311            | 350            |371             |333            |
       |312            | 351            |372             |307            |
       |313            | 352            |373             |330            |
       |314            | 353            |374             |335            |
       |315            | 354            |375             |331            |
       |316            | 355            |376             |327            |
       |376            | 227            |                |               |
       +---------------+----------------+----------------+---------------+

   KOI8-R to Mac Cyrillic
       For the conversion of KOI8-R to Mac Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |    KOI8-R     | Mac Cyrillic   |    KOI8-R      | Mac Cyrillic  |
       |24             | 4              |317             |356            |
       |200-237        | 40             |320             |357            |
       |240            | 312            |321             |337            |
       |241            | 254            |322             |360            |
       |242            | 257            |323             |361            |
       |243            | 336            |324             |362            |
       |244            | 271            |325             |363            |
       |245            | 317            |326             |346            |
       |246            | 264            |327             |342            |
       |247            | 273            |330             |374            |
       |250            | 300            |331             |373            |
       |251            | 275            |332             |347            |
       |252            | 277            |333             |370            |
       |253            | 40             |334             |375            |
       |254            | 316            |335             |371            |
       |255            | 40             |336             |367            |
       |256            | 331            |337             |372            |
       |257            | 333            |340             |236            |
       |260            | 334            |341             |200            |
       |261            | 253            |342             |201            |
       |262            | 256            |343             |226            |
       |263            | 335            |344             |204            |
       |264            | 270            |345             |205            |
       |265            | 301            |346             |224            |
       |266            | 247            |347             |203            |
       |267            | 272            |350             |225            |
       |270            | 267            |351             |210            |
       |271            | 274            |352             |211            |
       |272            | 276            |353             |212            |
       |273            | 40             |354             |213            |
       |274            | 315            |355             |214            |
       |275            | 40             |356             |215            |
       |276            | 330            |357             |216            |
       |277            | 332            |360             |217            |
       |300            | 376            |361             |237            |
       |301            | 340            |362             |220            |
       |302            | 341            |363             |221            |
       |303            | 366            |364             |222            |
       |304            | 344            |365             |223            |
       |305            | 345            |366             |206            |
       |306            | 364            |367             |202            |
       |307            | 343            |370             |234            |
       |310            | 365            |371             |233            |
       |311            | 350            |372             |207            |
       |312            | 351            |373             |230            |
       |313            | 352            |374             |235            |
       |314            | 353            |375             |231            |
       |315            | 354            |376             |227            |
       |316            | 355            |                |               |
       +---------------+----------------+----------------+---------------+

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_koi8-r(5)

Shell Programming and Scripting