Split of CSV formatted cell / cell with CSV narratives

[DanielCh]

Hello Community!

Glad to be back, I have a trouble with below formatted data (sample workflow in attachment). So basically within one cell I have data in csv which contains attributes and values (it comes from html tables).

What I would like to achieve is to find a way of splitting it somehow, to obtain one of below outputs (preferable first, as account number could be necessary):

1)  with account number

2) without account number

Please consider that one of the delimiters is \n and level down we got comma.

I will appreciate any assistance, thank you!

 

[geraldo]

@DanielCh 

an example workflow on how to start generating. probably the real values ??will be very different and will need adjustments to the filters