Substring – XpressDox

Use the substring function to extract a portion of a string in your XpressDox template

 

Extract from a position in the string until the end

The following example will begin extracting the value of GivenString from position 5 until the end.

«substring(GivenString,5)»

 

Extract a portion of the string for a given length

The following example will begin extracting from the position of the first numeric value (i.e. the beginning of the string in this example), and will extract for the length supplied by the second numeric value (3 characters).

«substring(GivenString,1,3)»

Remember that XpressDox does have an ExtractInitials function so you could use that for Names.

 

Extract one character at a time

Building on the above example you might have a situation such as in the image below, where you are required to insert one character at a time into a table. Instead of asking the user to insert one character into a field on the interview, rather ask for one value and break it up into several parts with the substring function.

«CaptureDataElement(MatterCode)»
«Comment(the following fillpoints would go in individual cells)»
«substring(MatterCode,1,1)»
«substring(MatterCode,2,1)»
«substring(MatterCode,3,1)»
«substring(MatterCode,4,1)»

 

XpressDox Document Automation software. Extract a portion of a string in your template