Forum Discussion

CharlotteM's avatar
CharlotteM
Qrew Assistant Captain
7 years ago

How can I derive a name in the middle of text?

We have a block of text coming in from Quickbooks. (Description on invoice line item) There is always a line in the description that says  Consultant: First Last Where First and Last are thei...
Ask about Quickbase functionality
Formulas and functions
CharlotteM's avatar
CharlotteM
Qrew Assistant Captain
7 years ago
There could be a lot of colons in some cases.

I'm wondering if there is any way to do this with a code fragment / code page.
  • RobIV's avatar
    RobIV
    Qrew Cadet
    7 years ago
    Absolutely,

    If this parsing is at all complex, and you have the stomach for javascript, I would create a code page that utilizes handy and powerful JS libraries like Lodash to parse the content and return what you need.

    Do you have any specific examples of the data you are looking at?  It would be helpful if you could share some sanitized examples.

    Thanks,