topic Parse Name from String in QlikView

Parse Name from String

Anonymous — Wed, 20 Oct 2010 16:27:15 GMT

Hello everyone. I need a little help extracting a name from a text string (Active Directory DN). Here are a couple of examples.

I have: CN=Flintstone\, Fred,OU=Users,OU=Bedrock,OU=Enterprise,DC=na,DC=company,DC=com

I need: Flintstone, Fred

I have: CN=Jackson\, Samual L,OU=Users,OU=Hollywood,OU=Enterprise,DC=na,DC=company,DC=com

I need: Jackson, Samual L

Wed, 20 Oct 2010 16:32:26 GMT

Something like this:

=MID( YOUR_DIMENSION_NAME, 1, index( YOUR_DIMENSION_NAME, 'OU' ) )

Wed, 20 Oct 2010 16:35:33 GMT

First, index( YOUR_DIMENSION_NAME, 'OU' ), you take a position fisrt OU....

Second you take a piece, start at 1 position of string......and finish before fisrt OU (fisrt expression give this position)

Anonymous — Wed, 20 Oct 2010 16:48:22 GMT

Thanks Erico, that gets me close.

Actually, either of these yeilds the same result:

=MID( UserDN, 4, index( UserDN, ',OU' )-4 )

TextBetween(UserDN,'CN=',',OU')

The problem is that both of these still leave the "\" character after the last name: Flintstone\, Fred

Wed, 20 Oct 2010 16:51:15 GMT

You can use Replace (your result, '\', '')

Anonymous — Wed, 20 Oct 2010 16:54:50 GMT

Perfect!

The final answer: Replace(TextBetween(UserDN,'CN=',',OU'),'\','')