Regex Help - how to split the string with numbers and special characters into columns

[cici0608]

Hello,

I have a column looks like "[A-BCD] 1234.05 - /EFG-HIJK.LMN - OPQ (RST) UVW - [XYZ] - ABC

I would like to split the string into 3 columns - 1234, 05, and [XYZ] from above column. 

Could you please help?

Thank you! 

[MarqueeCrew]

@cici0608 ,

I've invited you to a private ZOOM to review your needs and help you.

Cheers,

Mark

[echuong1]

Try this: .+(\d{4})\.(\d{2}).+(\[\u{3}\])

[MarqueeCrew · Accepted solution]

@cici0608  (Crystal)

Here is our formula:

.*(\b\d{4})\.(\d\d).*\[(.*)\].*

Used in a RegEx tool (configure to PARSE), you immediately get your desired fields:

The helper web page for learning RegEx that I recommended:  https://regex101.com/ 

My YouTube for RegEx beginners is here:

Cheers,

Mark