Joindre deux fichier avec deux champs de jointure Post: 302342145

Sponsored Content

Top Forums Shell Programming and Scripting Joindre deux fichier avec deux champs de jointure Post 302342145 by tukuyomi on Friday 7th of August 2009 01:23:56 PM

08-07-2009

Registered User

EDIT: after re-reading your post, this script does not correspong to what you want to do ... but it can help you
---------------
I came up with a script -in bash- like this, I hope it will be useful:

Code:

#!/bin/bash

array1=($(sed 's/;/\ /g' file1))
array2=($(sed 's/;/\ /g' file2))
cat /dev/null > file3
for ((i=0; i<${#array1[*]}; i++)); do
    echo ${array1[$i]}';'${array2[$i]} >> file3;
done
exit 0

file1 and file2 are text files containing your datas
file3 will be created with your data joined together
How does it works:
Lines 3 and 4: we create 2 arrays containing datas (we replace ; with \ (spaces))
Line 5; we create a empty file3
Line 6, 7 and 8: we join together datas from array1 and array 2.
The script was tested with 2 sample files:

Code:

file1:
1;3;5;7;9
11;13;15;17;19

file2;
2;4;6;8;10
12;14;16;18;20

resulting file3:
1;2
3;4
5;6
7;8
9;10
11;12
13;14
15;16
17;18
19;20

tukuyomi

View Public Profile for tukuyomi

Find all posts by tukuyomi

8 More Discussions You Might Find Interesting

1. Solaris

Filesystems Part Deux

In reading Ralph's pervious post I came accross a question. Say you have two hard drives in your system. One is running Solaris 10 and the other is Linux on ext2 FS. Is it possible to mount the linux using Solaris and transfer files? Thanks, Robert

2. Solaris

Fichier d'erreur

bonjour Ou puis je trouver les fichiers d'erreur (l'�quivalent du errpt sous Aix) sous Sun Solaris ? merci

3. HP-UX

Target LUNs plus que deux sur un SAN de 2 fabrics

salut admin, Normalement mon serveur doit voir un de mes LDEV � partir de deux chemins sur le SAN et ainsi lui attribuer seulement deux Target LUNs. Or il lui en a attribu� 8!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Tr�s bizzare! Auriez vous une id�e. Merci pour votre aide appr�ci�e

4. Solaris

Probleme avec SVM

Bonjour, J'ai ajout� par erreur � un sous mirroir des disques de cette facon : metattach d53 c2t90d0s0 c2t90d1s0 ... alors que j'aurais du faire un stripe par disque (comme �a) : metattach d53 c2t90d0s0 metattach d53 c2t90d1s0 .. Derriere, j'ai fais un growfs -M du FS pour l'aggrandir et...

5. AIX

Ajout colonne calcu�e ds un fichier .txt

Mon but est de cr�er un script ksh ou commande aix permettant ceci. J'ai un fichier .txt organis� par bloc d'informations, chaque bloc d�bute par 000 et ce comme suit : 000... 001... 003... 004... 000... 001... 003... 004... . . .Mon but est d'ajouter une colonne en fin de chaque ligne afin...

6. Shell Programming and Scripting

Script Send Mail by Parameters avec Attached file

Hi i have a script for show the information files. ls -l how do you for to place this result in a file of text and to send it attached for e-mail. The information of the mail must be in paramentros. for example e-mail to I must write the e-mail, the subject and the motive of the mail! ...

7. AIX

M�moire insuffisante avec awk

Bonjour, Je suis sur Aix 5 et j'ai un script qui traite un fichier texte de 5 G. Au lancement du scripte,j'ai le message suivant: awk : 0602-561 M�moire disponible insuffisante actuellement. Voir le script "blan.sh" awk 'BEGIN { print "Traitement de votre fichier " FILENAME } ...

8. Shell Programming and Scripting

Help script shell find fichier

Hello, I am looking for a shell script that can 1- take as input a variable, like "server.cpu" 2- do a search for that variable in a directory that contains subdirectories. The search will start at the last subdirectory working up to the top level if I can not find the file 3-...

LEARN ABOUT ULTRIX

diff3

diff3(1)						      General Commands Manual							  diff3(1)

Name
       diff3 - 3-way differential file comparison

Syntax
       diff3 [-ex3] file1 file2 file3

Description
       The command compares three versions of a file, and publishes the ranges of text that disagree, flagged with the following codes:

	  ====	      all three files differ

	  ====1       file1 is different

	  ====2       file2 is different

	  ====3       file3 is different

       The type of change needed to convert a given range of a given file to some other is indicated in one of these ways:

	  f : n1 a    Text is to be appended after line number n1 in file f, where f = 1, 2, or 3.

	  f : n1 , n2 c
		      Text is to be changed in the range line n1 to line n2.  If n1 = n2, the range may be abbreviated to n1.

       The original contents of the range follows immediately after a c indication.  When the contents of two files are identical, the contents of
       the lower-numbered file is suppressed.

Options
       -3   Produces an editor script containing the changes between file1 and file2 that are to be incorporated into file3.

       -e	   Produces an editor script containing the changes between file2 and file3 that are to be incorporated into file1.

       -x	   Produces an editor script containing the changes among all three files.

Examples
       Under the -e option, publishes a script for the editor that incorporates into file1 all changes between file2 and  file3  -  that  is,  the
       changes	that would normally be flagged ==== and ====3.	Option -x (-3) produces a script to incorporate only changes flagged ==== (====3).
       The following command applies the resulting script to `file1':
       (cat script; echo '1,$p') | ed - file1

Restrictions
       Text lines that consist of a single `.'	defeat -e.

Files
       /tmp/d3?????
       /usr/lib/diff3

See Also
       cmp(1), comm(1), diff(1), dffmk(1), join(1), sccsdiff(1), uniq(1)

																	  diff3(1)