Tuesday, 13 December 2016

Infopath substring function - use it to remove semi-colon

Doing some InfoPath and used the substring function with a nested string length function to remove the trailing semi-colon from a username

The username was stored in a list column called Workflow_To Notify

The substring function takes three arguments

1 - The text string which in this case is defined in the @workflow_ToNotify attribute

2 - The starting point - InfoPath starts counting at 1

3 - Use this with string-length and -1 to remove the last character - in this case the semi-colon


Happy SharePointing... InfoPathing... you know... whatever's your ing


No comments:

Post a Comment