HI @Anonymous
Do you want to get a gallery like this:
miguel's list
apple tomato mile |
bob's list
orange celery heavy cream |
jim's list
banana broccoli half and half |
Thanks for @timl ’s solution, it’s very simple and powerful. I’ve made a similar test.
Let me show you the solution in details:
Add a button and set it’s OnSelect property to (you will get the collection what you want after you select the button):
Clear(joint_collection);
ForAll(
Split("miguel's list,bob's list,jim's list",","),
Collect(
joint_collection,
{
column1: Last(FirstN(Split("miguel's list,bob's list,jim's list",","),
CountRows(joint_collection) + 1)).Result,
column2: Last(FirstN(Split("apple,orange,banana",","),
CountRows(joint_collection) + 1)).Result,
column3: Last(FirstN(Split( "tomato,celery,broccoli",","),
CountRows(joint_collection) + 1)).Result,
column4: Last(FirstN(Split("milk,heavy cream,half and half",","),
CountRows(joint_collection) + 1)).Result
}))
To be additional, here is another idea for your reference (little complex, but you can put it into the items property of the gallery):
ShowColumns(
AddColumns( /*add column “title3”*//*show columns “title” “title1” “title2” “title3” */
AddColumns( /*add column “title2”*/
AddColumns( /*add column “title1”*/
AddColumns( /*add column “title”*/
Concatenate( /*concatenate them to a one-column table*/
Split(
"miguel's list,bob's list,jim's list",
","
),
" ", /*” “X2, it will be used as a separator*/
Split(
"apple,orange,banana",
","
),
" ", /*” “X3, it will be used as a separator */
Split(
"tomato,celery,broccoli",
","
),
" ", /*” “X4, it will be used as a separator */
Split(
"milk,heavy cream,half and half",
","
)
),
"title",
Match( /*Match text in the format "XXX XXX" */
Result,
"\S*\s\S*"
).FullMatch
),
"title1",
Trim(
Match( /*Match text in the format " XXX" */
Result,
"\s\s\S*"
).FullMatch
)
),
"title2",
Trim(
Match( /*Match text in the format " XXX" */
Result,
"\s\s\s\S*"
).FullMatch
)
),
"title3",
Trim(
Match( /*Match text in the format " XXX( XXX XXX)" */
Result,
"\s\s\s\s\S*\s*\S*\s*\S*"
).FullMatch
)
),
"title","title1","title2","title3"
)
Beat Regards,
Bof
