Extracting string betvien two characters

Help Studio
, ,
1

Hi, can somebody help me extract the string between 2 characters?
I need a string between “" and “(” or "” depends witch comes first.

ex.
a) “asglas_1234567_” = 1234567
b) “asglas_1234567(” = 1234567

2

Hi @tomaz ,

Is the Number (1234567) the Output that you require ?

3

Hi you can use regex to extract the desired output from string

use matches activity
image
properties panel
image
and enter regex pattern in matches activity: \d*
image

You will get your output and then convert that to string

Thank you

4

Hello @tomaz
You can use the regex method
YourString= “asglas_1234567_” = 1234567

System.Text.RegularExpressions.regex.Match(YourString,"\d+").toString.Trim

image

5

Yes, but this is only a exemple, the correct string vill not be only numbers.

6

Hi @tomaz,

Check out this regex : System.Text.RegularExpressions.Regex.Match(test,“\w+(”).ToString.Replace(“_”,“”).Replace(“(”,“”)

image
image696×34 3.19 KB

image

Thanks & Regards,
Dibyaprakash

You can mark this as solution if your issue was resolved.

7

@tomaz ,

The above Statement and the example provided creates a bit of confusion as to what is really required ?

Do you want the String between the Double Quotes and Brackets or Just the number between them ?

More samples would help us strict the conditions and therefore build a concrete logic for the problem.

8

HI @tomaz

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=asglas_)\d+(?=_|\()").Tostring

image

Regards
gokul

9

try this

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=\Wasglas\w).*(?=_\W)|(?<=\Wasglas\w).*(?=\W\W)").Tostring

image

10

Hi @tomaz

Instead of \d+ use \S+

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=asglas_)\S+(?=_|\()").Tostring

image

Regards
Gokul

11

You can also try this :
image

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.