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.