Hi Tony Bomerato,
Like Mike Kumpf said, you can extract the text after this (\) by using String functions. For your reference, I have shared those functions here. Here, I used two string functions, One is substring () – To trim or remove the text from the given string, the return type will be string datatype. Another function is find () which will be used to identify the index value (Integer datatype) of given input string (\). In our case, the find function will execute first to locate the (\) position in that string. By using the substring function, it will trim before (\) string [Mit_AB6641.City] and will return after (\) string [Employee Name]. I hope, it will work for you!
Thanks and regards,
Vijayabharathi V
Tony,
You can create a microflow that uses the Substring function to isolate the part of the string you want. That microflow can run either during the import or afterwards in a data validation / cleanup process. String function documentation can be found here: https://docs.mendix.com/refguide/string-function-calls/
Hope that helps,
Mike