Text Tools

text tools are ideal for automating data extraction of single text strings at a high level, they work by looking for a string of text that matches the pattern specified once the tool finds a string that matches, it extracts the data and assigns it to a field there are two types of text tools that help you extract text simple mode and advanced mode simple mode allows you to locate a known value on the page, either with the aid of surrounding context or not advanced mode allows you to use regular expressions (regex) to flexibly identify text based on its format and potential surrounding context data inbox uses python based regex this means that you designate commonly seen surrounding text and symbols (e g “name ” or “date ”) and common formatting (“ @ ” or “commission file no ”) to identify the value you want to extract if you are unfamiliar or require more practice with using regex, it is recommended that you use an external regular expression builder in order to build and test the expression then copy and paste the expression into the query field to create a text tool within the kit associated with the schema you'd like to work with, locate the field you want to place data into in this case, we are working with our primary schema, performance report (refer to pattern creation and editing docid\ jjgd058ld kkhafjahuom for a refresher) click "add tool" and select "text tool" select whether you would like to use a simple or advanced text tool to extract your data simple mode enter the value that corresponds to your target please note that values are located as is; if you require the ability to locate a value via format, please use the advanced text tool designate whether you want to locate your target value by just the target value alone or with the aid of additional values that precede or succeed the target advanced mode in the text tool, enter a regex that would locate the target text specify any preceding text that would help identify the value you’d like to extract (e g “office phone ” or “statement period ”) use the following to designate the target text/ value you’d like to extract text pattern format \[preceding text here]\(?p\<target>\[your regex here])\[succeeding text here] insert a regex into the statement defined above leverage any special characters or recurring text that you know would appear in your target text as an example, a number rounded to the tenth place “54 8%” would correspond to the regex “\[0 9]+ \[0 9]\[%]” this example’s regex can be broken down as follows for our example, we will combine the regex “wildcard” to mean any character, the dot ( ) symbol with the regex symbol for repetition, the asterisk ( ) symbol, meaning “repeating for any number of times” this flexibility will allow us to capture any name, date, or performance number warning please do not use the wildcard dot ( ) symbol on its own without any surrounding context this will create numerous records that will prevent you from being able to successfully navigate your values this includes using the wildcard in other queries on their own, such as " " or " " or " +" or " ?" repeat this process for as many fields as you need to extract via text tools you now have automated text extraction!