Splitting Variable to Collection

(0) Share

Report

Posted on by MikeSwerve

Trying to split a variable into a collection like the example below

Variable

Header1:Data1\nHeader2:Data2\nHeader3:Data3\n........Header30:Data30

Require Collection

Header1	Header2	Header3	Header30
Data1	Data2	Data3	Data30

Data may possibly have a ':' within it but Header never will.

Any help would be appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 155,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @MikeSwerve ,

The issue is that you cannot dynamically create field names. The code below will separate it all and if you put it in a gallery with a wrap count of 2, it looks like yours transposed, but that is the best you will do.

With( { wSplit: Split( YourTextHere, "\n" ) }, ClearCollect( colSplit, Ungroup( ForAll( wSplit, Split( Result, ":" ) ), "Value" ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
MikeSwerve 29 on at

Like (0)

Report
Copy link

Link copied!

Thanks WarrenBelz, that's not really the outcome I wanted.

If I had the 2 records come in as
Record 1 - Header
Header1|||Header2|||Header3|||.....Header30

Record 2 - Data
Data1|||Data2|||Data3|||.....Data30

And display it in a gallery as below
Header1 Data1
Header2 Data2
Header3 Data3
Header30 Data30

Was this reply helpful? Yes No
WarrenBelz 155,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@MikeSwerve ,

Correct - that is exactly the result I received testing it. As I said, you cannot create field/column names dynamically.

Was this reply helpful? Yes No
MikeSwerve 29 on at

Like (0)

Report
Copy link

Link copied!

Sorry WarrenBelz, I didnt set the text wrap to 2.

Some of the data has a ':' in it and its splitting those also, is there a way to split at the first ':' after every '\n'

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@MikeSwerve ,

One thing about delimited data is you have to make it consistent - for instance CSV files cannot contain any commas other than between fields. The problem is (with a bit of code gymnastics), you might be able to get the first part before the split, but you want the whole piece.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No