Hi!
If your values are dynamic and theres no separator, then it becomes difficult to do but not impossible.
We will split it by the Static text elements such as REG: and then use First and Last to split those out into values.
The following formula will split the text up using the static elements and then output the text you requested:
With(
{
BaseValue: Label5.Text,
FirstSplit: Split(Last(Split(Label5.Text, "SO:")).Result, "REG:")
},
"SO:" & First(FirstSplit).Result & Char(10) &
With(
{
SecondSplit: Split(Last(FirstSplit).Result, "FORSIKRING:")
},
"REG:" & First(SecondSplit).Result & Char(10) &
With(
{
ThirdSplit: Split(Last(SecondSplit).Result, "JOBB:")
},
"FORSIKRING:" & First(ThirdSplit).Result & Char(10) &
With(
{
FourthSplit: Split(Last(ThirdSplit).Result, "LAGERSTED:")
},
"JOBB:" &First(FourthSplit).Result & Char(10) & Char(10) &
"LAGERSTED:" & Last(FourthSplit).Result
)
)
)
)
Could you please give this a try, replacing Label5.Text with your result from your QR code, and then let me know if you run into any issues?
Thanks,
Sancho
