manipulate column

Hi,

 

I have two files. (with more than 5000 lines)

 

The first file A.txt, 

 

Name_1; Firstname_1; address_A; phone_number;

Name_2; Firstname_2; address_B; phone_number;

Name_30; Firstname_3; address_C; phone_number;

Name_45; Firstname_4; address_D; phone_number;

Name_50; Firstname_5; address_E; phone_number;

Name_60; Firstname_5; address_E; phone_number;

 

 

The second file B.txt

 

0001;Name_1; Firstname_1; address_A; phone_number;

0002;Name_2; Firstname_2; address_B; phone_number;

0003; Name_3;Firstname_3; address_C; phone_number;

1111;Name_4; Firstname_4; address_D; phone_number;

5555;Name_5; Firstname_5; address_E; phone_number;

4567;Name_6; Firstname_6; address_F; phone_number;

1256;Name_7; Firstname_7; address_G; phone_number;

4953;Name_8; Firstname_8; address_H; phone_number;

7896;Name_60; Firstname_5; address_I; phone_number;

7897;Name_61; Firstname_61; address_J; phone_number;

 

 

 

I would like to have : 

 

0001;Name_1; Firstname_1; address_A; phone_number;

0002;Name_2; Firstname_2; address_B; phone_number;

XXXX;Name_30; Firstname_3; address_C; phone_number;

XXXX;Name_45; Firstname_4; address_D; phone_number;

XXXX;Name_50; Firstname_5; address_E; phone_number;

7896;Name_60; Firstname_5; address_E; phone_number;

 

 

 

Any help would be appreciated.

Best regards 

 

__________________________
Avant d'imprimer, pensez à l'environnement ! Please consider the environment before printing ! 
Ce message et toutes ses pièces jointes sont confidentiels et établis à l'intention exclusive de ses destinataires. Toute utilisation non conforme à sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. IFP Energies nouvelles décline toute responsabilité au titre de ce message. This message and any attachments are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. IFP Energies nouvelles should not be liable for this message.
__________________________