create collection from string

(0) Share

Report

Posted on by tomiapage1

Hello, i have multiple string looks like:

user;country;city

user1;country1;city1

I want to create collection with column user;country;city

Can You advise how to achive this ?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

TheRobRush 11,128 Moderator on at

Like (0)

Report
I am just going to start off with this. Your strings are not the same, one contains commas, one contains semicolons, at end of the first there is multiple line breaks then second starts. This would be better if you just have a string that is user;country;city;user2;country2;city2 etc then no matter how long that string is you can toss this on a button and get a collection from it

ClearCollect(recordSet, ForAll(Sequence(CountRows(Split(Label16,";"))/3,1,3) As recordGrab, {User: Last(FirstN(Split(Label16,";"),recordGrab.Value)).Value, Country: Last(FirstN(Split(Label16,";"),recordGrab.Value+1)).Value, City: Last(FirstN(Split(Label16,";"),recordGrab.Value+2)).Value}))

Otherwise if the string is broken up liek in example with multiple separators you need something like this. It's much messier though

ClearCollect(recordSet, ForAll(Sequence(CountRows(Split(Substitute(Substitute(Substitute(Substitute(Label16.Text,",",";"),Char(13),";"),Char(10),""),";;",";"),";"))/3,1,3) As recordGrab, {User: Last(FirstN(Split(Substitute(Substitute(Substitute(Substitute(Label16.Text,",",";"),Char(13),";"),Char(10),""),";;",";"),";"),recordGrab.Value)).Value, Country: Last(FirstN(Split(Substitute(Substitute(Substitute(Substitute(Label16.Text,",",";"),Char(13),";"),Char(10),""),";;",";"),";"),recordGrab.Value+1)).Value, City: Last(FirstN(Split(Substitute(Substitute(Substitute(Substitute(Label16.Text,",",";"),Char(13),";"),Char(10),""),";;",";"),";"),recordGrab.Value+2)).Value}))

Was this reply helpful? Yes No
tomiapage1 34 on at

Like (0)

Report

Sorry , my mistake. in text i have only semicolons

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
the place a button, and make it's onselect

ClearCollect(recordSet, ForAll(Sequence(CountRows(Split(Label16,";"))/3,1,3) As recordGrab, {User: Last(FirstN(Split(Label16,";"),recordGrab.Value)).Value, Country: Last(FirstN(Split(Label16,";"),recordGrab.Value+1)).Value, City: Last(FirstN(Split(Label16,";"),recordGrab.Value+2)).Value}))

Was this reply helpful? Yes No
rubin_boer 4,841 Super User 2024 Season 1 on at

Like (1)

Report
hi @tomiapage1 as an alternative:

Lazy method:

ClearCollect( _finalCollection, AddColumns( ClearCollect(_temCollection, Split(_String, Char(10))), "User", Index(Split(Value,";"),1).Value, "Country", Index(Split(Value,";"),2).Value, "City", Index(Split(Value,";"),3).Value) )

Was this reply helpful? Yes No