How to use RegEx

[phoebe_90]

How can I use RegEx  to extract "cccca" out?

Text

ORA=cccca OBA

[ShankerV]

Hi @phoebe_90 

One way of doing this.

.+=([a-z]{5}).+

 

Many thanks

Shanker V 

[binuacs]

@phoebe_90 One way of doing this

[phoebe_90]

I want to extract the words in the middle of "ORA=" and" OBA". The words not always are "cccca".

[binuacs]

@phoebe_90 Try 

Trim(REGEX_Replace([Text], 'ORA=(.*)OBA', '$1'))

[ShankerV · Accepted solution]

Hi @phoebe_90 

One way of doing this.

ORA=(.+)OBA

 

Many thanks

Shanker V