Working with Text
Manipulating text using Text Blaze to find the information you need
Note: This GIF shows how to copy snippets to your dashboard so that you can use them and customize them to fit your needs.
Text Blaze allows you to read text from multiple sources: form fields, the clipboard, the current page, or loading other webpages. The snippets below show how you can manipulate any text and find the information you need.
Split full name to get the last name
The snippet below uses a Form Text to capture a full name, then splits (by space) the name and uses the second word as the last names.
Split full name to get the last name
Dear {formtext: name=fullname; default=Sherlock Holmes},
I'm currently researching the genealogy of the {=split(fullname, " ")[2]} lineage.
I'm currently researching the genealogy of the {=split(fullname, " ")[2]} lineage.
_
Split {clipboard} from spreadsheet
This snippet splits (by tab) the content of your Clipboard (what you copied most recently) into a list and places items from that list in various places in the snippet
Find information from the clipboard
{note}{parts=split({clipboard}, "\t")}
{if: count(parts)<4}{parts=["Jon Snow","Guard","North wall","Alice"]}{endif}
{name=parts[1]; trim=yes}{profession=parts[2]; trim=yes}{address=parts[3]; trim=yes}{referrer=parts[4]; trim=yes}
{endnote: trim=yes}
Dear {=name},
You were referred to us by {=referrer} as a person of trust.
We require your services as a {=profession} in a certain delicate matter.
You were referred to us by {=referrer} as a person of trust.
We require your services as a {=profession} in a certain delicate matter.
_
[Advanced] Using Regex to find patterns in text
The snippet below captures text in a Form Paragraph field and extracts information by looking for patterns of text using regular expressions (Regex) and the extractregex command.
Finding patterns in text using regex
{formparagraph: cols=60; rows=8; name=text; default=Richard Wolff (born 12 June 1976 in Prague, Czechoslovakia)[1] is a motorcycle speedway rider who first rode in the UK for the Trelawny Tigers in the Premier League. He stayed with the Tigers until their closure in 2003. He then spent the 2005 season with the Reading Racers.}
Extracting the date of birth: {=extractregex(text, "\d\d\s\w+\s\d\d\d\d")}.
Extracting the first two words and the date of birth, and putting them inside a sentence: {=extractregex(text, "\w+\s\w+")} was born on {=extractregex(text, "\d\d\s\w+\s\d\d\d\d")}.
Extracting the first two words and the date of birth, and manipulating the date, and putting everything inside a sentence: {=extractregex(text, "\w+\s\w+")} was born on {date=extractregex(text, "\d\d\s\w+\s\d\d\d\d")}{time: dddd, MMMM Do YYYY; at={=date}; pattern=DD MMMM YYYY}.
Extracting the date of birth: {=extractregex(text, "\d\d\s\w+\s\d\d\d\d")}.
Extracting the first two words and the date of birth, and putting them inside a sentence: {=extractregex(text, "\w+\s\w+")} was born on {=extractregex(text, "\d\d\s\w+\s\d\d\d\d")}.
Extracting the first two words and the date of birth, and manipulating the date, and putting everything inside a sentence: {=extractregex(text, "\w+\s\w+")} was born on {date=extractregex(text, "\d\d\s\w+\s\d\d\d\d")}{time: dddd, MMMM Do YYYY; at={=date}; pattern=DD MMMM YYYY}.
_
[Advanced] Title capitalize the content of your clipboard
This snippet splits the content of your Clipboard into words. It then iterates through the list using the Repeat command. If the word is a known connector (e.g. and, but, so) it inserts it in lowercase using the Lower command. Otherwise, it inserts it properly capitalized using the Proper command.
Title capitalize your clipboard
{words=split({clipboard}, " ")}{repeat: for word in words}{if: contains("and, or, but, nor, yet, so, for, a, an, the, in, to, of, at, by, up, for, off, on",{=lower(word)})}{=lower(word)}{else}{=proper(word)}{endif} {endrepeat}
_
