You are viewing limited content. For full access, please sign in.

Question

Question

TRIM function example for Laserfiche Connector Profile

asked on October 21, 2021

Can someone please provide an example of the syntax to use the TRIM function to modify the token string retrieved by the Laserfiche Connector? The help file indicates that there is a function, but it doesn't provide any details regarding the attributes to use with it.

 

https://www.laserfiche.com/support/webhelp/laserficheconnector/9.0/en-US/userguide/#EditingAProfilesXML.htm%3FTocPath%3D_____6

0 0

Answer

SELECTED ANSWER
replied on October 21, 2021

Ok. I was able to figure this out. It literally needs no attributes. For others, here is what I was able to do:

 

In this application I was only able to grab the Title Bar data. 

Title Bar token: 'Accounting for Organization - MIP - [Department, 910] | Chart of Accounts Codes'

 

Since connector does not have any regular expression support, I was able to parse into this string by modifying the XML profile directly. 

https://www.laserfiche.com/support/webhelp/laserficheconnector/9.0/en-us/userguide/#EditingAProfilesXML.htm

 

Here is the syntax I used to get the 3-4 digit code embedded in this Title Bar:

<Element name="%(Title Bar)">
       <Attributes>
               <Attribute name="Condition" value="/Root[1]/TitleBar[1]" />
               <Attribute name="Property" value="Value" />
       </Attributes>
               <Children>
                    <Child name="SPLIT">
                       <Attributes>
                          <Attribute name="Delimiters" value="," />
                          <Attribute name="IndexToReturn" value="2" />
                       </Attributes>
               <Children />
                    </Child>
		    <Child name="SUBSTRING">
                       <Attributes>
                          <Attribute name="Start" value="2" />
                          <Attribute name="Length" value="4" />
                       </Attributes>
                    <Children />
                    </Child>
		    <Child name="TRIM">
                    <Children />
                    </Child>

                  </Children>
 </Element>

 

0 0

Replies

replied on October 21, 2021

replied on November 2, 2021

Looks like you're referring to the help file in an old version. Below is the newest help file of Connector which includes an example of TRIM:

https://doc.laserfiche.com/laserfiche.documentation/11/administration/en-us/Default.htm#../Subsystems/Connector/Content/Editing-Profiles.htm?TocPath=Connector%257C_____7

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.