I have to connect two sets of data, the link are users details which the two systems read differently
The record in system one is first and last name which is simple enough and I can concentrate to get
The second system returns two types of result
Basic, Billy (CORP\XXXXXXXX)
Basic, Billy (CORP\billy.basic)
The X’s are a unique user id all user have, some users here log on by name some by thier id,
Where the result is the latter it doesn’t record the id at all, I think the easiest way to proceed is a formula that maps,
Basic, Billy (CORP\XXXXXXXX)** to billy.basic but I’m struggling to do it so any guidance appreciated.