I am working with a table that has a field name System where the values are like this:
DNA-Data
Oracle_DIMDW
I only need to capture the values just before the "-" and the "_". What i am expecting is "DNA" and "Oracle".
I have managed to capture the string "DNA" using the code below:
How can I include another Left function within the same code to capture "_" or "Oracle"?
Thanks in advance
Ray
DNA-Data
Oracle_DIMDW
I only need to capture the values just before the "-" and the "_". What i am expecting is "DNA" and "Oracle".
I have managed to capture the string "DNA" using the code below:
Code:
System_Name: Left([System],(InStr(1,[System],"-"))-1)
How can I include another Left function within the same code to capture "_" or "Oracle"?
Thanks in advance
Ray