Greetings,
I would like to construct one or more functions that will allow me to extract each string element from a dot notation populated field. An example of the content of such a field (perhaps named [Org_Structure]), would be:
Organization.Division Name.0001 - Region Name.123456 - Area Name.A Rather Long Location Name
In populating the [Org_Structure] field, I'll be able to strip out all special characters between the "." (dot) delimeters except the "-" (hyphen) character.
So what I need to be able to do is then use a function to strip out each of the values between the dot notation delimeters into separate fields.
I have a feeling that this can be done using the "instr" function in conjunction with perhaps the "left" function or some other combination, but I'm not sure what would be the best way to approach this so that I can easily create a separate function for each element to be extracted to a separate field.
Can anyone help me figure out the best way to approach this?
Any assistance would be most appreciated.
Cheers,
Wayne