Re: Extracting last 5 characters

Samir Farid — Fri, 08 May 2009 14:03:23 GMT

Hi Dean,

You can get the last five positions of the Employee number by using a combination of substring and string-length:

Example: substring(EmployeeNumberfield; string-length(EmployeeNumberfield) - 4; 5)

If you only want to show the employee number that are 5 positions long, then it will be much easier to do that in code with an if-statement.

Hope this helps,

- Samir -

Extracting last 5 characters

dlgross — Fri, 08 May 2009 13:35:26 GMT

I am using the GetUserProfileName webservice to the UserName (which in our case is the NetworkID). we have some employees with a network ID that is 5 digits (xxxxx=their employee number) and other employees have a network ID that contains a 3 character prefix before their employee number (P00xxxxx). I want to show the 5 digit employee number on my form. I thought that I'd be able to use the substring functoin, but I can't figure out how to do this. I thought that this would be simple, but I'm having a brain cramp and would appreciate some help.

Thanks

Dean

Code

Re: Extracting last 5 characters

Extracting last 5 characters