Simple question on the possibility of xslt

XavS · April 9th, 2018, 10:45 AM

Hello everybody,

Before begin my developments, I would like to know if it is possible to do it :

My input file is a .txt which looks like to a csv.
My output file is a "real" .csv.

My txt is really particular like it :

Code:

01;FILE_HEAD;CUSTOMERS;INFO1;INFO2;INFO3
02;CUST_HEAD;CUST1;CUST_NAME
03;CUST_NUM;CUST1;PHO;0001;+33 XX
04;CUST_NUM;CUST1;PHO;0002;+33 YY
05;CUST_NUM;CUST1;FAX;0001;+33 ZZ
06;CUST_ADV;CUST1;NEWInfo
07;CUST_HEAD;CUST2;CUST_NAME2
09;CUST_ADV;CUST2;NEWInfo2
10;CUST_HEAD;CUST3;CUST_NAME3
11;FILE_HEAD;CUSTOMERS;INFO1;INFO2;INFO3

I would like to transform it in :

Code:

INFO1,INFO2,INFO3,INFO4,CUST_NAME,+33 XX,+33 ZZ,NEWInfo
INFO1,INFO2,INFO3,INFO4,CUST_NAME,+33 YY,+33 ZZ,NEWInfo
INFO1,INFO2,INFO3,INFO4,CUST_NAME2,,,NEWInfo2
INFO1,INFO2,INFO3,INFO4,CUST_NAME3,,,

Do you think it is possible ?
Sorry, but I a real newbie in XSLT...

mhkay · April 9th, 2018, 10:50 AM

It's certainly possible in XSLT, though as there's no XML involved other rule-based languages like awk might be better.

If you're going to use XSLT, make sure it's version 2.0 or higher: you'll need features like regular expressions and unparsed-text() that don't appear until 2.0.

XavS · April 9th, 2018, 11:26 AM

Okey thank you for the information, i am going to try it now.