Jul-21-2018, 07:30 AM
Hi everyone,
I am looking at extracting name titles and putting them into their own column in a dataset.
The names are in this format: grant-perice, Mr. Owen Harris.
Can I start a string search from the , and end at the . and extract into a column and delete any white space? Perhaps with the extract method?
Thanks
I am looking at extracting name titles and putting them into their own column in a dataset.
The names are in this format: grant-perice, Mr. Owen Harris.
Can I start a string search from the , and end at the . and extract into a column and delete any white space? Perhaps with the extract method?
Thanks