nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Regex: Remove everything except a specific pattern

Pablo_Sahonero

Hi i been looking for some hours in internet but i didn't figure out this problem yet

i have some records like this:

Random KEY1 Text KEY3

Blah Blah KEY10

Hello World KEY5

KEY22 another text KEY1

And my desired result is this:
KEY1 KEY3

KEY10

KEY5

KEY22 KEY1

basically i want to remove everything in a string except these KEY ID's

Thanks

Regex

Accepted answers

binu_acs

@Pablo_Sahonero Are you looking for something like below

Regex_0919.yxmd

All comments

ChrisTX

Can you provide some actual input data, mocked up if necessary? Does the text you want actually include the work KEY in all caps, followed by one or more numbers?

Chris

Emmanuel_G

Hi @Pablo_Sahonero ,

Find attached the way of doing this with simple Regex expression : (KEY\d+?)

Let me know if there is any issue.

Please do not hesitate to mark this answer as solution if it helped.

Regex - Remove everything except a specific pattern.yxmd

binu_acs

@Pablo_Sahonero Are you looking for something like below

Regex_0919.yxmd

Pablo_Sahonero

yes KEY is always going to be in capital followed by a number

Pablo_Sahonero

thanks for the responses
the solutions indeed "works" but the problem is i can have more than 2 occurrences within a single record
you may say ok split it in more columns BUT i don't know how many occurrences can be
it's there a way of using regex replace instead of tokenize?
EDIT: i tried using replace with the regexs provided but i get the opposite that i wanted:

screen

binu_acs

@Pablo_Sahonero Try the below regex

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15908

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703