Trim Login IDs

[jmonroe918]

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

[sunny_talwar]

Try this:

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

[jmonroe918 · Accepted solution]

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