EmberKrumwied
4 years agoQrew 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
------------------------------