Power Platform Community Forum Thread Details

Hi,

I have a long text string with comments that is built like this:

"2024-10-01

Blablablabla

2024-10-02

Blabla bla bla

etc."

Now I want to divide this string into pieces where the new strings start with the dates each time. The idea is to use Split and MatchAll, but I can't figure out how to combine these functions. Or is there any better ideas?

All ideas are welcome and appreciated!

Categories:

Building Power Apps

Something like this should work even though needs to be optimized. The example is created with a label and a button.

Label1.Text set to

"2024-10-01 Blablablabla 2024-10-02 Blabla bla bla 2024-10-03 TestBlabla bla bla"

"\d\d\d\d\-\d\d\-\d\d" is a regular expression representing the format of the date in your example

The button OnSelect set to

UpdateContext({theStringLength: Len(Label1.Text)});

ClearCollect(
    myIndexedTable,
    With(
        {
            data: ShowColumns( MatchAll(Label1.Text, "\d\d\d\d\-\d\d\-\d\d"),StartMatch)
            
        },
        AddColumns(
            RenameColumns(
                Sequence(CountRows(data)),
                Value,
                Index
            ),
            StartString,
            Index(
                data,
                Index
            ).StartMatch
        )
    )
);

ClearCollect(mySearchTable, myIndexedTable);

ClearCollect(
   myStringStartAndSize,
   AddColumns(
      myIndexedTable,
      strLength,
      With({
      getStringPosition:LookUp(mySearchTable,  Index = myIndexedTable[@Index] + 1, StartString)
      },
      If ( !IsBlank( getStringPosition)  , getStringPosition -  myIndexedTable[@StartString], theStringLength - myIndexedTable[@StartString] + 1 )
      )
   )
);