Apologies for the long subject title!
I have a field that I need to extract data from.
Sometimes, the field value would be “ABC1234, A Short Description Here”. I can extract the “ABC1234” successfully to use as a reference to find and update a record in another system.
However, on occasion, the reference may be “ABC1234, DEF1234, GHI1234, A Short Description Here”.
Is there any easy way to collect all the references without the “A Short Description Here”, then loop through these references to find the records in another system, and subsequently update them all with their own values?
So, in the above case I would need to find and update ABC1234, then find and update DEF1234, and finally find and update GHI1234.
Thank you!