Hello, I am reading a PDF text, and isolating a table. I am then splitting the table data up into seperate substrings in an array. I am trying to split the substring data up, to get a name, a set of dates, and a cost value. The data is split up by spaces, and looks something like the data below (r…

Hi @ptrobot , I got some help from a colleague in the office. We have managed to work out where the dates are by splitting the line by “/” and assigning the integer substrings to integer variables. If they didn’t break then a full date was present, and we split by the date value to get the name and …

I would recommend using one regular expression with three groups: (?<=Scheduled Payment )(.+) (\d{2}/\d{2}/\d{2}-\d{2}/\d{2}/\d{2}) (\d+,\d+\.\d+) Use the Matches activity with the pattern above and then loop through the matches with a For Each activity. For each item you can get the values like t…

Hi @ptrobot , This is the sequence including the Matches activity. I am looking at the locals panel during running, and the variable used in the activity, MatchedItems, does have a value, see below: [image] This is the Matches activity panel, have I set it up correctly? [image] Here’s the activ…

If you are using the Regex Builder, don’t use Literal, change it to Advanced. [image] My recommendation is, if you already have the regular expression, then just paste it in the Pattern field in the Properties: [image] The TypeArgument for the For Each activity should be RegularExpressions.Matc…

Hi @ptrobot , I have copied the properties you have set and dragged in a new matches activity, but still the same empty match I had shown above.

When there are no matches, what is the value of you variable line? (Assuming that it’s the input string to your Matches activity.)

The first two lines are blanks, but everything after that is the same format I specified in the initial post. I didn’t add the VAT payment amounts though: [Untitled] Apologies for the data redaction, it may not be as clear now, but this is sensitive information from a client and not made up names …

Are you using Matches with each line as an input string separately? In that case, you won’t get any matches for the first two empty lines and not for the VAT lines either. Have you tested with removing the “For Each line in TableLines” and set the TableLines as input string to the Matches activity …

Ok, that’s is strange. Could you write TableLines (or the string variable that initializes it) to a text file, copy the text file content to the inputString variable in my uploaded example and run it? (Or you could also modify the example to read the file to the inputString variable). If you run my …

Get values from string with only space seperators

Help Studio

william.coulson (Will Coulson) November 24, 2020, 1:40pm 9

I used the string variable which initialises the TableLines variable, and this gave MatchedItems no value either. It skipped straight past the for each item in MatchedItems.

Topic		Replies	Views
How can split value Help activities , question , data_manipulation	13	1714	January 9, 2020
Split a string with no fixed length Help	8	1677	April 2, 2019
Hello team, pls provide solution for this string manipulation.Tq Studio studio , question , activities_panel	8	910	April 1, 2023
How to split unstructured data Studio studio , question , activities_panel	2	1158	February 4, 2021
Get individual value from string Help activities , string , data_manipulation	6	965	December 8, 2019

Get values from string with only space seperators

Related topics