Strip Text out of String
SummaryI need to move data from on string of text to multiple columns
I have a string of text (User Group Name), that includes a lot of details that I'd like to strip out into multiple columns. Here is the string:
Store1234 (SVU 810 BU01 D15)
Here are the columns that I need:
|Oracle Store #||SVU Store #||Business Unit||District|
I know how to strip data off the end or off the beginning, but figure there has to be an easy to way to pull out of the middle. Any thoughts?