Delineated list as separate repeating group item

[kris.davis.digital]

I am storing data in a single DB field that is delineated by a #. I am trying to show that information read out via RG but have been banging my head and searching for a while to no avail.

Here is an example:

I have been playing around with trying to Split By but can’t seem to get it to work right. I am trying this but it keeps reading out the entire field instead of reading out each element inside the field per RG Item.

Anything would be very much appriciated!

[boston85719]

looks like what you’ve done should work. Maybe try using a different delineator, but the use of split by operator is the correct approach…another thing to check is that when you enter the # as the split by, make sure there are no spaces before or after.

[kris.davis.digital]

Appreciate the confirmation that the approach should work, just need to find the kink in the system. Good call out on the spaces.

Thanks!

[kris.davis.digital]

Ok, so I got it to work and there is another step I am fighting with:

I have two fields with delineated text. I am trying to get the items to match up but I keep getting the Another Item list being red out entirely in an RG.

[Jici]

If both list have exact same size and exact same order,
RG dats source will be split by # (from DB field 1)
In RG cell, do DB field 2:split by #:item#current cell index

[kris.davis.digital]

Amazing, TY!