trying to make a saved search and group by container number. They put the container number at the end of the memo field like this "container: 0111" is there a way to pull out the numbers after container:?

o.0

I don't know how it works, just that it does work.

Thanks @Gregory Jones!

I find this site really useful for understanding regular expressions. https://regex101.com/ Basically it's matching any characters other than a colon at the end of a string. You could also add a space (i.e.

[^: ]+$

) or wrap the whole expression in a TRIM.

only problem is I can't drill down into the formula field

I don't think there's a way to solve that without crazy HTML

Yeah I think you're right, I think we are going to start using the inbound shipment record though so that should solve this problem