question

Anoh B. avatar image
Anoh B. asked ·

Capture Specific Value in the splittings column

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

business transaction
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

1 Answer

Andreas G. avatar image
Andreas G. answered ·

I assume this has been handled with a second posting you did? Extract Value from the "Splittings" Column in BT

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.