Formula to Separate Concatenated Items?


#21

OK, mighta gotten it:

IF( {Comma Count}>=5, 
MID( {Style Name}&'\n', 
FIND( '\n', {Style Name}, 
(LEN({Style Name 1})+2)+ 
(LEN({Style Name 2})+2)+ 
(LEN({Style Name 3})+2) )+1, 
FIND( '\n', {Style Name}&'\n', 
(LEN({Style Name 1})+2)+ 
(LEN({Style Name 2})+2)+ 
(LEN({Style Name 3})+2)+ 
(LEN({Style Name 4})+2) )
-FIND( '\n', {Style Name}&'\n', 
(LEN({Style Name 1})+2)+ 
(LEN({Style Name 2})+2)+ 
(LEN({Style Name 3})+2) )-1 ) )

#22

Yes, that works for the fifth field. Here’s the syntax for the sixth:

IF( {Comma Count}>=6, 
MID( {Style Name}&'\n', 
FIND( '\n', {Style Name}, 
(LEN({Style Name 1})+2)+ 
(LEN({Style Name 2})+2)+ 
(LEN({Style Name 3})+2)+ 
(LEN({Style Name 4})+2) )+1, 
FIND( '\n', {Style Name}&'\n', 
(LEN({Style Name 1})+2)+ 
(LEN({Style Name 2})+2)+ 
(LEN({Style Name 3})+2)+ 
(LEN({Style Name 4})+2)+ 
(LEN({Style Name 5})+2) )
-FIND( '\n', {Style Name}&'\n', 
(LEN({Style Name 1})+2)+ 
(LEN({Style Name 2})+2)+ 
(LEN({Style Name 3})+2)+ 
(LEN({Style Name 4})+2) )-1 ) )

#23

I wanted to apologize for not getting back to you; I’m guessing I experienced a browser crash part-way through my reply, since when I opened this thread, I was greeted by an edit window containing a partial response. (Anyone know if Discourse allows one to display any unfinished drafts on file?) I see you didn’t need me, thankfully.

I guess I’m one of those Santayana said were condemned to repeat the past, as I essentially recreated this post and base from scratch a couple of weeks ago. I haven’t tried a point-by-point comparison, but I have a feeling the newer version is a slightly more elegant solution (or, at least, explained more nicely).