Help me to create regex to only get numbers

Help Activities
, ,
1

Hi All ,
need ur help to only extract data using the regex with some use cases as below:

**Use case **
LOREM LS8515, WEN+ FEED, WATER (E570)
LOREM IPSUM 8515
LOREM IPSUM-8515
LOREM IPSUM8515
LOREM IPSUM8515 WATER2570

OUPUT NEEDED : 8515

Guys please note Lorem Ipsum can be any words or symbol thank you

Thank you guys

1 Like
2

@StevenIsRobotOnline

(?<=LOREM IPSUM\s*-*)\d{4}

3

Hi @StevenIsRobotOnline

(?<=LOREM LS|LOREM IPSUM-|LOREM IPSUM|LOREM IPSUM )\d+

image
image823×494 21.8 KB

4

Hi @StevenIsRobotOnline

Matches= System.Text.RegularExpressions.Regex.Matches(yourstringinput,"((?<=[A-Z]+\s+[A-Z]+\s*\-?)\d+)")

Datatype of Matches is IEnumerable(System.Text.RegularExpressions.Match)

image
image1339×590 37.7 KB

Hope it helps!!

5

Hi @StevenIsRobotOnline

You can use the regular expression to get the required output 8515

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=\w+\s+)\d{4})”)

image

Hope it helps!!

6

hi @StevenIsRobotOnline

can you try this

system.text.regularexpression.regex.match(“\d{4}”).value

7

Hello @StevenIsRobotOnline ,
You can try this:
(?<=LOREM IPSUM\s*-*)\d+
I hope this Helps you.
Regards;)

8

Guys please note Lorem Ipsum can be any words or symbol thank you

9

Guys please note Lorem Ipsum can be any words or symbol thank you

10

@StevenIsRobotOnline

you try mine it works for any context!!

Hi @StevenIsRobotOnline

Matches= System.Text.RegularExpressions.Regex.Matches(yourstringinput,"((?<=[A-Z]+\s+[A-Z]+\s*\-?)\d+)")

Datatype of Matches is IEnumerable(System.Text.RegularExpressions.Match)

image
image1339×590 37.7 KB

Hope it helps!!

11

@StevenIsRobotOnline Try with this one :
(?<=.\s-*)\d{4}

12

@StevenIsRobotOnline

SavingRegex
SavingRegex947×382 25.9 KB

13

Hi @StevenIsRobotOnline

You can use the following code to get the desired output:

[A-Za-z ]*(\d{4})(,|[a-zA-Z]+|\s)

image
image942×288 20 KB

Hope it helps! :smiley:

14

Hey,
Try With This Pattern:(?<!(WATER))\d{4}
image

15

System.Text.RegularExpressions.Regex.Match(str_,“\d{3,}”)

Hope it will help you!!

16

Hi @StevenIsRobotOnline

Check the below expression

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“((?<=(^[A-Z]+\s+[A-Z]+)|([A-Z]+\s+[A-Z]+)|[A-Z]+\s+[A-Z]+\s+|[A-Z]+\s+[A-Z]+\-)\d{4})”)

image
image1086×393 25 KB

17

hi im not really familiar with regex ,

so how do i get the output caused when i use it on my script it shows
System.Text.RegularExpressions.MatchCollection

i only need : 8515 in a string as an output

18

@StevenIsRobotOnline

Str_output=System.Text.RegularExpressions.Regex.Match(INputString,“8[0-9]+”).Value

19

Okay @StevenIsRobotOnline

=> Assign -> StrOutput = System.Text.RegularExpressions.Regex.Match(yourstringinput.ToString,“((?<=(^[A-Z]+\s+[A-Z]+)|([A-Z]+\s+[A-Z]+)|[A-Z]+\s+[A-Z]+\s+|[A-Z]+\s+[A-Z]+\-)\d{4})”).Value

Store the Input data in a String variable and in above expression pass the variable in the place of yourStringinput place.
The StrOutput is also a String Variable.

Hope you understand!!

20

Hi Its working now but still not perfect
image

it still have missing value

the use case is this
1.WILDUN DUMA 8515 → 8515
2. WILAN DC1218 → 1218
3. WILAN DC0818H ->0818
4.WILEN DC1218H ->1218
5. WIILENUN EN997, RSPO MB, GEM+ FOOD, FEED (E436) ->997

THANK YOU