none
[URGENT]extract last 4 digit numbers RRS feed

  • Question

  • i have a below infopath form which contains empno field that should get extracted the last 4 digit numbers and display in the below field empno ending field

    Infopath form UI

    empno:3-123-1234-11

    empno ending :3411 //extract empno last 4 digits

    how to set action rule for the empno ending field


    Blitz


    • Edited by sree_23 Friday, November 15, 2019 5:24 AM
    Friday, November 15, 2019 4:44 AM

Answers

  • Hi, Blitz,

    I assume the empo is in a text filed, and the digits are fixed, always in the form x-xxx-xxxx-xx. You can use the following formula to do your work. 


    Field 1 is the filed hold empno, and filed 2 is the empno ending field. The formula is like displayed above. The dot in the substring function means filed 1. You can try to insert by your self.

    Best Regards

    Jerry


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    • Marked as answer by sree_23 Friday, November 15, 2019 8:27 AM
    Friday, November 15, 2019 6:30 AM