Forum Discussion
Help Needed - Grabbing text in between delimeters
Hi all, I have a power app that is pushing data to a SharePoint list. The data is being scanned in using a barcode scanner. I am trying to write a calculation for a column to automatically grab th...
Buckets84 Try using formulas like below:
First column/output:
Last(FirstN(Split(lblInputString.Text,"="),3)).Value
Second column/output:
First(Split(Last(Split(lblInputString.Text,"=<")).Value,"=>")).Value
Where lblInputString.Text is your input string data which you want to split.
Output:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.