I have thousands of records in a single field within a table in the following format
\\SERVERNAME\C$\DOCUMENTS AND SETTINGS\USERNAME
The actual data has different values for SERVERNAME AND USERNAME then shown above. I would like to extract the SERVERNAME and USERNAME values into their own fields.
How to do?