I have a field that I am importing using the feeds module, the data is written into a text field and it contains..

CN=Mike Jones,OU=IT,OU=Web,DC=home,DC=web,DC=com

What I would like to do using feeds_tamper (possibly regex plugin within feeds_tamper) is clean up the imported data so that it only shows..

Mike Jones

Using feeds_tamper, I was able to strip out the CN= by adding the "Find replace" plugin and removing it.

Next, I tried to use "Explode" on the , string separator with a limit of 1 hoping to return the "Mike Jokes" value.. but that does not seem to work. Also tried using %s for space and setting the limit of 2 to return first/last name

Anyone know how I would be able to accomplish this using feeds_tamper?

Thank you.