This is probably a very simple operation but I can’t seem to get it to work.
I am changing many files to new formatting, and as such will be trying find and replace methods as well as rearranging text. One that I can’t quite figure out is like this:
Which the format should now be :
FirstName LastName - JobTitle
While I can easily add the Job Title, I am having issue with parsing the Name part - rearranging them and removing the comma, as I don’t know how long the name is and for some of them, there is no comma to divide by (only a space). I can’t seem to use Find and Replace as I don’t know the name itself (I want to get it from the document) and just change the arrangement of the text.
There are a few other things to do (replacing parts of the document, rearranging text) but if I can get this to work, I can surely get the rest.
Is there some example code for taking text and rearranging? I feel like it should be obvious but I can’t figure it out.
Thanks for your assistance.