Help RegularExpressions.Regex

Help Studio
1

Hi,

I need a subject, sometimes Extral, sometimes something else.

This my Code

System.Text.RegularExpressions.Regex.Matches(Currentitem.Subject.toString,“(?<=LCM-)(.)(:)(?=Extral)”)(0).ToString.Replace(" “,”")

image
image1530×632 44 KB

2

Hi @punnipah

Can you share the sample Input and expected output?

3

the sample
Memo number STO 00835/2022(1) Subject LCM-C Extralxxxxx
Memo number STO 00835/2022(1) Subject LCM-C Starxxxxx

expected output
LCM-C Extral
LCM-C Star

5

HI @punnipah

How about this following?

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=Subject\s)\S.*(?=x{5})").Tostring

image

Regards
Gokul

1 Like
6

Sorry I might misunderstand you.

I want the C value in the middle.

Ahead is LCM-behind is Extral Or Star

7

HI @punnipah

Check out this expression?

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=LCM\W)\S.*(?=\sExtral|\sStar)").Tostring

image

1 Like
8

If there is no Extral or Star next time, will it work?
I can’t say that I’ll always have these two words.

9

Every time it will be a Single Letter? @punnipah

Like C

10

try this @punnipah

(LCM-C [A-Za-z]+)

e.g. input is
Memo number STO 00835/2022(1) Subject LCM-C Extral

output of
System.Text.RegularExpressions.Regex.Match(Currentitem.Subject.toString,"(LCM-C [A-Za-z]+)").Groups(1).Value
is
LCM-C Extral

1 Like
11

Not Single Letter

12

image

Try with this : (?<=LCM\W)\S.*(?= |\sExtral|\sStar)

@punnipah

1 Like
13

image
image1869×735 105 KB

need C value

Or Next :LCM-A Extral ,LCM-B Extral

14

Hi @punnipah

Try this one : (?<=LCM\W)\S.*(?=\sExtral|\sStar)|(?<=LCM\W)\S.*

image

1 Like
15

Thank you So much ^^

16

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