Remove Text Before and After

I have a string field that looks like this KJDFKLJHD2381KJAS2018COMPANYNAMEREPORTLJKSDNAEHD.

I want to isolate Company 1 in this example, but the records may have different company names. How do I remove everything from the left up through 2018 and everything to the right up through REPORT?

Datasets

Accepted answers

JessieC

@bsolove

You can use the RegEx tool to parse it out: \w+2018(\w+)REPORT\w+

If you're unfamiliar with RegEx, I find this website very useful in creating the Regular Expression - https://regex101.com/

All comments

Thableaus

Hi @bsolove

Does 2018 change? Is the year dynamic?

If you could show more examples of sample data, it would be good.

Cheers,

bsolove

No, 2018 and REPORT would be consistent between each record, but the characters before 2018 and after REPORT may change.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703