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 the data between a specific delimeter. This needs to be done in two separate columns for two separate sections of the value.
An example of the data is: =+03000=W40562400929900=<V0108000=>024074
I need the value after the second "=" delimeter and before the next "=" delimeter (W40562400929900) in one column.
For the second column, I need the value after "=<" and before "=>" (V0108000).
Any help would be appreciated. I have tried several variations from articles I have read using Right, Left, and Len, but have been unable to fully comprehend the syntax to make adjustments to what I need.
2 Replies
Buckets84 Try using formulas like below:
First column/output:
Last(FirstN(Split(lblInputString.Text,"="),3)).ValueSecond column/output:
First(Split(Last(Split(lblInputString.Text,"=<")).Value,"=>")).ValueWhere 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.
Buckets84 I've had to do something like this before, pulling multiple different strings between delimiters in the filename and putting those strings into specific fields in a SharePoint List. My own solution was to run a Power Automate flow on new list entries, using the function "split" to extract specific strings, and then create an output that mapped to specific file properties (in the SharePoint List). I believe you can create a Flow right in PowerApps now. Check out the Power Fx formula reference and see if this might work for your scenario. (https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-split)
