EmberKrumwied

3 years agoQrew Assistant Captain

# Extracting Text

I've ready a few posts and have been able to get a formula to almost work, but I'm missing something. I have a field that will contain a text string like the following:

B100 - C212 - M12777 - I10020

B100 - C213 - MLV5064-01202 - I10021

The data will always present in this format. I need to pull out each section into its own field, but only the data that follows the letters "B", "C", and "M". I had this working until I added the last section (starting with "I").

My formula to pull out the data after "M" returned everything after M, including the new section "I".

I am wondering if there is a formula to search for "M" and extract everything up until " - I".

This formula will extract some of the "M" section but not all. If the M section starts with LV5064, that is the only part extracted, but I need the full LV5064-01202.

Trim(Left(Right([Time Entry Link],"M"), "- I"))

Any suggestions?

Thanks

------------------------------

Ember

------------------------------

B100 - C212 - M12777 - I10020

B100 - C213 - MLV5064-01202 - I10021

The data will always present in this format. I need to pull out each section into its own field, but only the data that follows the letters "B", "C", and "M". I had this working until I added the last section (starting with "I").

My formula to pull out the data after "M" returned everything after M, including the new section "I".

I am wondering if there is a formula to search for "M" and extract everything up until " - I".

This formula will extract some of the "M" section but not all. If the M section starts with LV5064, that is the only part extracted, but I need the full LV5064-01202.

Trim(Left(Right([Time Entry Link],"M"), "- I"))

Any suggestions?

Thanks

------------------------------

Ember

------------------------------