The text to Columns tool allows you to split a text field into multiple fields or rows by specifying a delimiter to split on. Below are some delimiters you can specify to split the field: You can also specify the delimiter as any single character (like a period or a dash). The data...
Another option to get the last word in a string with Regex is: (\S+)$ This will capture the last consecutive non-white-space characters in the string. If you wanted to ensure there is at least one white-space character in the string, eg not capturing anything when...