topic Re: Trim Login IDs in QlikView

Trim Login IDs

jmonroe918 — Wed, 14 Oct 2015 23:29:37 GMT

I am loading data from a field that lists a user Last and First Names and then their login id's in parentheses. See below:

Orginator:

Monroe, Jeff (jmonroe)

Smith, John (jsmith)

Johnson, Edward (ejohnson)

I want to strip out the UserID; the name in parentheses. As you can see they are of varying length so I can't use the standard 'Left' command with a number. I need to determine the length of the UserID and then subtract from the Length of the string, etc.

Thanks.

Jeff

Re: Trim Login IDs

sunny_talwar — Wed, 14 Oct 2015 23:36:05 GMT

Try this:

Trim(SubField(Orginator, '(', 1)) as UserID

Re: Trim Login IDs

jmonroe918 — Wed, 14 Oct 2015 23:40:41 GMT

Sunny:

Just as you sent your solution I figured out how to use:

Left(Originator, index(Originator, '(')-1) as Orig

Yours worked, too.

Thanks.

Jeff