Split Strings 2

[susiesunshine]

I would like to grab the name from an email address:
CN=John Doe/OU=CLE/OU=MS

How do I split it so I only display John Doe?

 

[bdreed35]

Something like like this will work for you:

stringvar myString := "CN=John Doe/OU=CLE/OU=MS";
split(replace(myString,"=","/"),"/")[2]

~Brian

 

[synapsevampire]

Or use:

mid({table.field},instr({table.field},"=")+1,
instr({table.field},"/")-instr({table.field},"="))

Or if the CN= is static:

mid({table.field},4,instr({table.field},"/")-3))

The split is the way I would normally do it just cuz it's fun, but if you've an old version of CR it doesn't support it, either way works in newer versions though.

Please post the version of your software when requesting technical assistance.

-k

 

[susiesunshine]

Thank you both! I am on a roll now!