Parsing data from less than/greater than brackets

[atjhsieh]

I was wondering if anyone knew the best way to parse out a long string like the below?

"<Session xmlns=\"blablabla.com/bla/bla/bla\ "><Parameter Name=\"bla\"><Value>12345</Value></Parameter><Parameter Name=\"bla_bla\"><Value>bla</Value></Parameter><Parameter Name=\"bla_bla_bla\"><Value>bla</Value></Parameter></Session>"

I'm pulling from a Cosmos DB with thousands of lines like this, and I ultimately want something in the format below. 

bla	bla_bla	bla_bla_bla
12345	bla	bla

In addition, I'm running into an issue where the data is getting truncated when I bring it in from the input data tool, even after I throw a browse on afterwards. 

Any suggestions on either of the issues is welcome. Thank you! 

[FilipR · Accepted solution]

Please see attached. 

[Brian32]

Good Afternoon - 

Another method is Regex Tool to Tokenize the String.  Use the syntax: (><[[:alpha:]]+\s[[:alpha:]]+.\\"\w+\\"><\w+.\w+)

From there just Parse and use a Replace Function to get down to your values.  Hope this helps!

[atjhsieh]

Thank you both for the help!