This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Not sure what was going on but the fourth line extract answer did indeed follow the same logic:
REGEX_EXTRACT({parsed_delivery-address}, “(?:.\n)(?:.\n)(?:.\n)(.)”)
@Justin_Barrett any ideas on how to build these into ‘IF’ statements that would woul...
Justin_Barrett:
REGEX_EXTRACT({All lines}, "(?:.*\n){2}(.*)")
Thanks @Justin_Barrett - just an update that I had to apply to below changes for it to work in my case:
Second line extract:
REGEX_EXTRACT({parsed_delivery-address}, “(?:.\n)(.)”)
T...
Kia ora from New Zealand @Justin_Barrett,
Reading through the thread you sound like the kind of human that may be able to help me out, I am looking to split each of the lines from a long text field into a separate short text field?
eg
Long Text Field...