Need help with a non comma separated file (leading space being trimmed and grouping successive li...

Greetings all !

I have to deal with an annoying file that I sadly cannot convert to CSV without manual labor (at least to my knowledge).

File goes like that : groups start with a dn:, and end with an empty line.

I would like to group into columns all that data for each line starting with “dn:” and their subsequent lines (up until we start again with a new “dn:”).

Bonus question : the tool that sends the data to me cuts the lines short and my URLS are split into two lines, the second one starting with a space. When using “file reader” node it seems leading spaces are trimmed so I can’t regex my way out of this little problem. Ideas ?

dn: cn=file transfer preferences,cn=file transfer,c=fr,o=ABCDEF
description: this is another description
cn: File Transfer Preferences
dcspref_ces: DCSApp.Class*$*String-$-dcs.prefs.DCSTDFPrefs
dcspref_ces: TDF.appList*$*List-$-stuff
dcspref_ces: DCSApp.Desc*$*String-$-File Transfer
dcspref_ces: DCSApp.URL*$*String-$-https://dcs.ABCDEF.com/rne_tdf/tdfprefs/j
sp/tdfprefs.jsp
dn: cn=bcc preferences,cn=bcc,cn=dis,c=fr,o=ABCDEF
description: This is a description
cn: more cn stuff
dcspref_ces: ST.appList*$*List-$-cn=BCC Preferences, cn=BCC, cn=DIS

Thanks in advance