Questions tagged [multiple-matches]

70 questions
1
vote
1 answer

How to use query function to exclude names based on criteria from another sheet?

How to use query function to exclude names based on criteria from another sheet ? Thank you https://docs.google.com/spreadsheets/d/1Yl-oBui4ji6AzGg47FAe68fi2PqHTUC08kYhBMtB2DY/edit?usp=sharing
1
vote
2 answers

Compare two strings in powershell, regex * match, output DataSpace_ID field from string1 based on match, into switches listing string in own column

I have a list of switches in CSV and a list of data spaces where these switches are. In my list of Data Spaces, I have a DataSpace_ID field which represents its associated DataSpace_Name. My list of switches has a Host_Name and IP_Address fields.…
1
vote
3 answers

Return matches from array if contains specific words

I have an array that contains several countries followed by an option and a number. 0 " UK One 150 " 1 " Switzerland Two 70 " 2 " China Two 120 " 3 " Switzerland One 45 " 4 " China One 90 " 5 " UK Two 50 " This is how I get the array using xpath: …
Joe Berg
  • 381
  • 3
  • 16
1
vote
1 answer

Storing Python RegEx multiple groups

I'm webscraping a site using python. The returned results have the following format, ( https://regex101.com/r/irr14u/10 ), where everything works ok apart from the last occassion where i get 2 matches for the dates (1st match:Thur.-Sun., Tue., Wed.…
sotokan80
  • 49
  • 8
1
vote
1 answer

Conditional If with REGEX

I'm working on a function to try some regex. Let me explain. function traitement { if ($Matches.NAME -match "^A_(?[\w{1,6}]{1,7})") { [void]($memberOfCollection.add($Matches.test1)) } elseif ($Matches.NAME -match…
P0werSh3ell
  • 103
  • 1
  • 6
1
vote
4 answers

Find all repeating strings between a start and a stop and with a separator

I'm trying to get one or more substring from a string like this : "theSTART:param1:param2:paramN:theEND" or "theSTART:param1:theEND" or any number of parameter saparated by ":" and delimited by "theSTART:" and ":theEND". I'm using Python3 regex…
Zdiode
  • 13
  • 4
1
vote
3 answers

Counting number of pattern matches in Perl

I am VERY new to perl, and to programming in general. I have been searching for the past couple of days on how to count the number of pattern matches; I have had a hard time understanding others solutions and applying them to the code I have…
Ashley
  • 413
  • 3
  • 8
  • 17
1
vote
1 answer

matches between two arrays by position and value in php

Suppose I have two arrays with the same size. for example: array1 = array(5, 8, 6, 4); array2 = array(5, 8, 7, 8); and I need to know the matching between them in percents. But the matching have to be by the position and value. In this example, the…
pey22
  • 137
  • 2
  • 6
  • 13
1
vote
1 answer

Outlook 2010 VBA - Using RegEx to return multiple matches within email body

I receive multiple emails daily that have the following string within the body: [Spool File No. #### where #### is an integer anywhere from 1 to 2000 Sometimes, there is only one such string within the body, sometimes there are more with the only…
airjavier
  • 21
  • 3
1
vote
1 answer

Match and concatenate vba

I have data like this A B C D 1. Customer T/C NET VAT 2. Sandy T1 3. Sandy T5 4. Sandy T1 5. Sandy T5 6. Candy T1 7. Candy T5 8. Dandy T5 9. Dandy T1 Where NET and VAT contains $Amount & 1,2 etc are…
1
vote
1 answer

Servlet mapping with multiple matches

I have a question according the mapping behaviour. If there are these mappings given: ServletA *.xml ServletB…
firsti
  • 93
  • 1
  • 7
1
vote
0 answers

php regular expression extract strings

i have test it for hours using php preg_match_all to extract data, but with no luck. original…
1
vote
4 answers

Better way to write this regex to match multi-ordered property list?

I've been whacking on this regex for a while, trying to build something that can pick out multiple ordered property values (DTSTART, DTEND, SUMMARY) from an .ics file. I have other options (like reading one line at a time and scanning), but wanted…
Andrew Philips
  • 1,950
  • 18
  • 23
1
vote
1 answer

Returning partial address matches and mismatch position using L2S or SQL

I need to implement a method that takes an address split up into individual parts and returns any matching items from an address table. If no matches are found, I want to be able to return a value indicating where it failed. Each input param has a…
peter3
  • 1,074
  • 13
  • 22
1
vote
2 answers

Powershell Regular Expressions getting values out of a -replace match

I want to take each number in a string and replace it with its doubled value. For instance "1 2 3 4 5 " should become "2 4 6 8 10" or "4 6 10 " should be "8 12 20" I think I'm nearly there, however, I can't seem to get the value out of the…
Trevor Tiernan
  • 392
  • 1
  • 3
  • 9