I have a table in which there is a field that a part of the value in this field needs to be extracted and saved in another column. How can I achieve this? The value always starts with:
CG: and it can be in the middle where it ends with "," or the last value
For instance:
GG:American Value Entered, CG:Startup, MG:Advanced
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Master
I have a table in which there is a field that a part of the value in this field needs to be extracted and saved in another column. How can I achieve this? The value always starts with:
CG: and it can be in the middle where it ends with "," or the last value
For instance:
GG:American Value Entered, CG:Startup, MG:Advanced
or
GG:American Value Entered, CG:Startup
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.