05 Dec 2014 01:24 PM
Hello,
I have this long string "<ROOT><Results><User UserID="187" LoginName="Colleen.Rogers" ActiveFlag="1" NameLast="Rogers" NameFirst="Colleen" Password="7pjy/+ztpV+4oXi1axk+rtfDaDoa9mgT" PasswordChange="0" LastLoginDate="12/5/2014 7:43:55 AM" ProgramID="IrxTcWUY0zbYqpalkEdCoTBQiwRVJnMlvg0TvZLU2mQsCnzoO2zshOCqPZyaE2r+zlPnW8sqWiR79I1kTAJF/g==" WinAuthEnabled="0" ProductDefID="2" TimestampCreate="05/29/2014 18:36:48:760" TimestampChange="10/09/2014 14:54:38" UserIDCreate="109" UserIDChange="159" AuthenticationTypeKey="AD" Pass" in the splittings column of my business transaction.
However, I want to display on the loginName value (ie, ColleenRogers"
How do I do that? I tried from the filter area to no avail
Please find attached the session file and the BT that I am using is BT_ListUsers
Odyssey for Splittings by Usernames.dts
Regards,
Anoh
09 Dec 2014 06:11 PM
I assume this has been handled with a second posting you did? Extract Value from the "Splittings" Column in BT