Parse a string using regex

[Kcapron001]

I have a few variations of the string examples below

I am trying to parse

PubScheduleK-1
ScheduleK1extraletters
FormScheduleK-1extraletters
FormScheduleK1extraletters
PubScheduleA
ScheduleAextraletters
FormScheduleAextraletters
FormScheduleAtext


I want to extract the “K1” from the first 4 and “A” from the last four in the list.

I am basically trying to extract the schedule name.

Help?

[Thableaus · Accepted solution]

Hi @Kcapron001 

Would this work? Using Formula Tool, create a column with this formula

REGEX_Replace([Field],"^.*Schedule([^a-z]+).*$", "$1", 0)

This means - get everything that is not a lowercased letter after the word Schedule. Stop when you find a a lowercased letter.

Cheers,