Expression to split these items into rows?

[Tiger1]

I need a good expression to split this paragraph up (if possible).

Instead I would like a row per - item - starting with (1) or (2) etc… Like this:

[Tiger1]

oh. I see.
Then shouldnt this work?
Should it be:
<<Index(SPLIT([ITEM_LIST], "* "), 1)>>
<<Index(SPLIT([ITEM_LIST], “,”), 2)>>
etc…
etc…
etc…

[Marc_Dillon · Accepted solution]

I think you need to do this:

*<<INDEX(   SPLIT(   [ITEM_LIST] , "*" ) , 2 )>>*
<<INDEX(    SPLIT(   INDEX(   SPLIT(   [ITEM_LIST] , "*" ) , 3 ) , "," ) , 1)>>
<<INDEX(    SPLIT(   [ITEM_LIST] , "," ) , 2 )>>
<<INDEX(    SPLIT(   [ITEM_LIST] , "," ) , 3 )>>
<<INDEX(    SPLIT(   [ITEM_LIST] , "," ) , 4 )>>
<<INDEX(    SPLIT(   [ITEM_LIST] , "," ) , 5 )>>

[Tiger1]

worked PERFECTLY. Thanks so much!