General

Re: Get Extension from Phone Number

claire — Fri, 19 Aug 2016 07:54:04 GMT

Thanks Hilary, this works fine, I was missing the string-length.

Re: Get Extension from Phone Number

Hilary Stoupa — Thu, 18 Aug 2016 20:14:37 GMT

Something like this: substring(Value[Name = "WorkPhone"], string-length(Value[Name = "WorkPhone"]) - 3)

Get Extension from Phone Number

claire — Thu, 18 Aug 2016 14:38:13 GMT

Good afternoon,

I wonder if anyone could please help. I have an InfoPath list form and a text box which using the User Profile Service returns the staff's full phone number. I have used Value[Name = "WorkPhone"] which is returning the right result, but what I'd like to do is only return the last four digits which would be the extension number. Would someone be able to help with the formula.

Many thanks