Create a output metadata structure

[Anonymous]

Hi all,

I need to create an output file with the structure:

$$
AA User_FirstName
LN User_LastName
EM User_EMail
TF AreaCode|PhoneNumbre|MobileNumber|
DR User_StreetAddress|ZIP|TOWN|CountryCode
LG LanguageISOCode
ED EntryDate|LastDate|ExpirationDate|
$$
AA User_FirstName
LN User_LastName
EM User_EMail
TF AreaCode|PhoneNumbre|MobileNumber|
DR User_StreetAddress|ZIP|TOWN|CountryCode
LG LanguageISOCode
ED EntryDate|LastDate|ExpirationDate|

I have searched a lot but I can not find the way. Any ideas?

Thank you so much

[Anonymous]

Hello,

Could you please elaborate your case with an example with input values?

Best regards

Sabrina

[Anonymous]

Sample data. Not Real...

User_LastName;User_FirstName;User_EMail;AreaCode;PhoneNumbre;MobileNumber;User_StreetAddress;ZIP;Town;CountryCode;LanguageISOCode;EntryDate;LastDate;ExpirationDate
Acevedo Manríquez;María;a@abc.es;08;915554832;+342225566;c Alberto Zuloaga, 1;08080;Barcelona;34;es;01/08/2016;21/01/2019;01/05/2021
Acevedo Mejía;Enrique;b@defg.es;02;935556666;+342225588;c Sanchez Abello, 155;02121;Arava;34;es;01/03/2017;23/02/2019;02/08/2021
Acevedo Ruiz;Carolina;c@hij.es;45;928555222;+342225525;Pza Bigabol, 1;45069;Santander;34;es;21/05/2015;15/03/2019;03/02/2021
Acosta Canto;Tomás José;aab@abc.es;28;915558799;+342225599;Av. Jimenez Bie, 123;28012;Madrid;34;es;06/03/2019;21/01/2019;04/05/2020
Acosta Gámez; Celina;jjn@defg.es;06;915556400;+342225555;c Alberto Zuloaga, 168;06589;Alicante;34;es;05/07/2018;23/02/2019;05/07/2021
Aguilar Dorantes;Irma;hhi@hij.es;28;965554258;+342225500;Ps Castellana, 368;28356;Pozuelo de Alarcón;34;es;06/05/2017;15/03/2019;06/06/2023
Aguilar;María;bba@abc.es;15;915558822;+342225511;Av. Raimundo Fernandez, 89;15155;Granada;34;es;21/04/2017;21/01/2019;07/05/2021
Aguilar Loranca;Marcela;pbs@defg.es;08;915556969;+342225533;c. Miguel de Cervantes, 15;08121;Mataró;34;es;15/04/2017;23/02/2019;06/03/2021

In te Output format, "$$" is the begin of a new record.

Thanks

Libro1.csv