How to use "is match" in this case?

Learning Hub Academy Feedback
1

Hello,

I have a list of strings and i want to use the activity “is match” to check (true/false) if the next rule is contained in such strings:

house - NUMBERs

So the following examples would be true:

fdsfsd house - 2 fdfsfsdf
fdsfsd house-1 fdsfsd fdsfsd
fdsfsd house - 4 fdsfsd
fdsfsd house - 3232 fdsfdsdssd fdsfsd fdsfsd

The following examples would be false:

fdsfsd hous-1 fdsfsdsfsd
fdsfsd house -$1 fdsfsd
fdsfsd house_2

Thank you.

2

Will some matches have no spaces between house, the dashes, and the number? Or will they all match the pattern from the 1st, 2nd, and 4th line?

3

The idea is that every string contains the structure “house-number” without considering the spaces between them. So a correct solution would be “house - number” or “house- number” as well.

“House” and “-” can be separated by whatever number of blank spaces, as well as “-” and “number”.

edit: i need sth similar to HOUSE /n+ - /n+ number

where number is a integer number between 1 and infinite

4

“house[\s-]*\d+”

use this as pattern and check

1 Like
5

Hello,

It does work, thank you very much.

How could I remove such a structure contained in the string if it exists?

For instance, if the string is " fdsfsd house - 3232 fdsfdsdssd fdsfsd fdsfsd " then I would like to remove house - 3232 so that the final string will be:

fdsfsd fdsfdsdssd fdsfsd fdsfsd

Regards

6

let’s consider StrVariable = " fdsfsd house - 3232 fdsfdsdssd fdsfsd fdsfsd "
the
NewStrVariable = StrVariable.Replace(“house - 3232”,“”)

7

Hi @EngAnalyst

Try this

(?=house).+

Thanks
Ashwin.S

8

Hello,

Yes, it works in that particular case, but every case will be different. “house” followed by a “-” and a number will be common in all cases, but such a number will be different.

9

Hi,

Thank you. How can I implement it?

10

“house” and “-” is fixed?

11

Hi @EngAnalyst

Use this pattern within ismatch activity and check

Thanks
Ashwin S

12

Hello,

Yes, the word house and “-” symbol appears all the time.

The structure is: house-number where number is a integer number.

The thing is that house, “-” and the number can be separated by blank spaces. For instance:

  1. house - 1
  2. house-43453
  3. house- 3

Edit: i just want to delete it when it is contained in a string.

For instance: “kfjdskfdjsk house- 4” should be converted into “kfjdskfdjsk”

13

Thanks. I already implemented “house[\s-]*\d+” and it worked. The thing now is that i just need to remove such a structure contained in a string.

For instance: “kfjdskfdjsk house- 4” should be converted into “kfjdskfdjsk”

14

fdsfsd house - 2 fdfsfsdf
fdsfsd house-1 fdsfsd fdsfsd
fdsfsd house - 4 fdsfsd
fdsfsd house - 3232 fdsfdsdssd fdsfsd fdsfs

use this “house[\s-]*\d+” in matches to extract and then get output like outRegex
and use for each loop and get pass this variable to it and use assign activity like this
NewStrVariable =“fdsfsd house - 3232 fdsfdsdssd fdsfsd fdsfs” .Replace(item.ToString,“”)
cheers @EngAnalyst

15

here is a sample workflow
i tried let me know if this what you are lookin for
cheers @EngAnalystRegex.xaml (6.3 KB)

1 Like
16

Thank you very much. This is the solution.

What if the occurence is higher than 1?

For instance: “kfjdskf house-1 kjdsifjsiodfi house -2”

Would there be any possibility to remove all the patterns so that the text will be "kfjdskf kjdsifjsiodfi "?

17

good,close this thread by marking it as a solution!
well you can do! without loop thats!

18

Regex.xaml (5.1 KB)
cheers @EngAnalyst
try this!

1 Like
19

Thank you very very much for your help.

I wish you have a nice day.

Kind regards!

1 Like
20

you too cheers
@EngAnalyst