Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: merging colums from different files
Top Forums Shell Programming and Scripting merging colums from different files Post 60863 by ppass on Monday 24th of January 2005 07:09:53 AM
Old 01-24-2005
merging colums from different files
hi all ,

i have three files that contain numbes as the first column .
i want to add these files together so the numbers from the first file is in the first column ; the numbers from the second file in the second column; and the numbers from the third file in the third column .


as an example :

file1 file2 file3
12 23 236
13 234 234
134 233 234
14 237 233
14 2367 232
14 2399 232



file 4
12 23 236
13 234 234
134 233 234
14 237 233
14 2367 332
14 2399 232

thank in advance
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Merging two files

Hi I have a requirement like this. I have two files This is how data1.txt looks: EI3171280 38640658501 NENN2005-12-129999-12-312005-12-12HALL NANCY 344 CHENEY HIGHWAY ... (4 Replies)
Discussion started by: venommaker
4 Replies

2. Shell Programming and Scripting

merging two files

Friends, os: redhat enterprise linux/SCO UNIX5.0 I have two files and I would like to merge on given key value. Now I have tried with join commd but it does not supporte multiple delimiters. and if records length is not fixed. join -a1 5 -a2 1 -t -o file1 file2 > outname Can any... (7 Replies)
Discussion started by: vakharia Mahesh
7 Replies

3. Shell Programming and Scripting

Merging 2 files

Hi, I have got two files 1.txt 1111|apple| 2222|orange| 2.txt 1111|1234|000000000004356| 1111|1234|000000001111| 1111|1234|002000011112| 2222|5678|000000002222| 2222|9102|000000002222| I need to merge these two so that my out put looks like below: Search code being used should be... (4 Replies)
Discussion started by: jisha
4 Replies

4. Shell Programming and Scripting

Help with merging files

i would like to merge two files that have the same format but have different data. i would like to create one output file that contains information from both the original files.:rolleyes: (2 Replies)
Discussion started by: joe black
2 Replies

5. Shell Programming and Scripting

Compare two csv files by two colums and create third file combining data from them.

I've got two large csv text table files with different number of columns each. I have to compare them based on first two columns and create resulting file that would in case of matched first two columns include all values from first one and all values (except first two colums) from second one. I... (5 Replies)
Discussion started by: agb2008
5 Replies

6. Shell Programming and Scripting

merging of files.

Hi, I want to merge the two files on the basis of columns like... file 1 Data Key A 12 B 13 file2 Data Value A A1 A A2 B B1 B B2 (5 Replies)
Discussion started by: clx
5 Replies

7. UNIX for Dummies Questions & Answers

Merging two files

Hi, I have two files a.txt and b.txt. a.txt 1 2 3 4 b.txt a b c d e I want to generate a file c.txt by merging these two file and the resultant file would contain c.txt 1 (4 Replies)
Discussion started by: siba.s.nayak
4 Replies

8. Shell Programming and Scripting

Merging two files with same name

Hello all, I have limited experience in shell scripting. Here goes my question: I have two directories that have same number of files with same file names i.e. consider 2 directories A and B. Both directories have files 1.txt, 2.txt...... I need to merge the file 1.txt of A with file 1.txt... (5 Replies)
Discussion started by: jaysean
5 Replies

9. Shell Programming and Scripting

Merging two files

Guys, I am having little problem with getting a daily report! The daily process that I do is as follows 1. Unload Header for the report from the systables to one unl file, say Header.unl 2. Unload the data from the required table/tables to another unl file, say Data.unl 3. Send a... (2 Replies)
Discussion started by: PikK45
2 Replies

10. Shell Programming and Scripting

Compare 2 colums in two files

Hi , I am trying to write a part in shell script. I have two files with one column each and would like to output it to a new file giving the records which are different.Pls help experts. File1 Column name 11 12 13 14 18 File2 Column name 11 12 14 17 19 (2 Replies)
Discussion started by: Rossdba
2 Replies

LEARN ABOUT OPENSOLARIS

iconv_1250

iconv_1250(5)                                           Standards, Environments, and Macros                                          iconv_1250(5)

NAME

       iconv_1250 - code set conversion tables for MS 1250 (Windows Latin 2)

DESCRIPTION

       The following code set conversions are supported:

       +----------------------------------------------------------------------+
       |                   Code Set Conversions Supported                     |
       +-------------+----------+--------------+----------+-------------------+
       |    Code     |  Symbol  | Target Code  | Symbol   |  Target Output    |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2     | ISO 8859-2   |iso2      |ISO Latin 2        |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2     | MS 852       |dos2      |MS-DOS Latin 2     |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2     | Mazovia      |maz       |Mazovia            |
       +-------------+----------+--------------+----------+-------------------+
       |MS 1250      | win2     | DHN          |dhn       |Dom Handlowy Nauki |
       +-------------+----------+--------------+----------+-------------------+

CONVERSIONS

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

   MS 1250 to ISO 8859-2
       For the conversion of MS 1250 to ISO 8859-2, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |   MS 1250     |  ISO 8859-2    |   MS 1250      |  ISO 8859-2   |
       |24-211         | 40             |235             |273            |
       |212            | 251            |236             |276            |
       |213            | 40             |237             |274            |
       |214            | 246            |241             |267            |
       |215            | 253            |245             |241            |
       |216            | 256            |246-267         |40             |
       |217            | 254            |271             |261            |
       |221-231        | 40             |273             |40             |
       |232            | 271            |274             |245            |
       |233            | 40             |276             |265            |
       |234            | 266            |247             |365            |
       +---------------+----------------+----------------+---------------+

   MS 1250 to MS 852
       For the conversion of MS 1250 to MS 852, all characters not in the following table are mapped unchanged.

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

   MS 1250 to Mazovia
       For the conversion of MS 1250 to Mazovia, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |   MS 1250     |    Mazovia     |   MS 1250      |   Mazovia     |
       |200-213        | 40             |310-311         |40             |
       |214            | 230            |312             |220            |
       |215-216        | 40             |313-320         |40             |
       |217            | 240            |321             |245            |
       |220-233        | 40             |322             |40             |
       |234            | 236            |323             |243            |
       |235-236        | 40             |324-325         |40             |
       |237            | 246            |326             |231            |
       |240            | 377            |327-333         |40             |
       |241-242        | 40             |334             |232            |
       |243            | 234            |335-336         |40             |
       |244            | 40             |337             |341            |
       |245            | 217            |340-341         |40             |
       |246-252        | 40             |342             |203            |
       |253            | 256            |343             |40             |
       |254            | 252            |344             |204            |
       |255-256        | 40             |345             |40             |
       |257            | 241            |346             |215            |
       |260            | 370            |347             |207            |
       |261            | 361            |350             |40             |
       |262            | 40             |351             |202            |
       |263            | 222            |352             |221            |
       |264            | 40             |353             |211            |
       |265            | 346            |354-355         |40             |
       |266            | 40             |356             |214            |
       |267            | 372            |357-360         |40             |
       |270            | 40             |361             |244            |
       |271            | 206            |362             |40             |
       |272            | 40             |363             |242            |
       |273            | 257            |364             |223            |
       |274-276        | 40             |365             |40             |
       |277            | 247            |366             |224            |
       |300-303        | 40             |367             |366            |
       |304            | 216            |370-373         |40             |
       |305            | 40             |374             |201            |
       |306            | 225            |375-376         |40             |
       |307            | 200            |                |               |
       +---------------+----------------+----------------+---------------+

   MS 1250 to DHN
       For the conversion of MS 1250 to DHN, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |   MS 1250     |      DHN       |   MS 1250      |     DHN       |
       |200-213        | 40             |306             |201            |
       |214            | 206            |307-311         |40             |
       |215-216        | 40             |312             |202            |
       |217            | 207            |313-320         |40             |
       |220-233        | 40             |321             |204            |
       |234            | 217            |322             |40             |
       |235-236        | 40             |323             |205            |
       |237            | 220            |324-325         |40             |
       |240            | 377            |326             |231            |
       |241-242        | 40             |327-333         |40             |
       |243            | 203            |334             |232            |
       |244            | 40             |335-336         |40             |
       |245            | 200            |337             |341            |
       |246-252        | 40             |340             |40             |
       |253            | 256            |341             |240            |
       |254            | 252            |342-345         |40             |
       |255-256        | 40             |346             |212            |
       |257            | 210            |347-351         |40             |
       |260            | 370            |352             |213            |
       |261            | 361            |353-354         |40             |
       |262            | 40             |355             |241            |
       |263            | 214            |356-360         |40             |
       |264            | 40             |361             |215            |
       |265            | 346            |362             |40             |
       |266            | 40             |363             |216            |
       |267            | 372            |364             |223            |
       |270            | 40             |365             |40             |
       |271            | 211            |366             |224            |
       |272            | 40             |367             |366            |
       |273            | 257            |370-371         |40             |
       |274-276        | 40             |372             |243            |
       |277            | 221            |373-376         |40             |
       |300-305        | 40             |                |               |
       +---------------+----------------+----------------+---------------+

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_1250(5)
All times are GMT -4. The time now is 07:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy