Forum Discussion

MarkoKrajinovic's avatar
MarkoKrajinovic
Qrew Trainee
6 years ago

Formula to extract a part of text from one field to another.

Hi all, I want to extract a piece of information from one Rich Text field into a simple Text field, or multiple fields by using a formula. So, as an example, from [Intro] "Hi, my name is Marko, ...
Formulas and functions
TabathaGarrett's avatar
TabathaGarrett
Qrew Member
5 years ago
This is very similar to an issue that I am having. I need to separate multiple pieces of data from a multi-text field so that I can add a value to each piece of data. Do you know anyway to accomplish this?

------------------------------
Tabatha Garrett
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
If you convert your multi select field to a text field lie this

ToText([my multi select field])

then if will be like curley ; larry ; moe

ie separated with a space semicolon space.

so then you can make a new field for the 1st part (form the left)

Trim(Part(ToText([my multi select field]),1,";"))

Then the 2nd part would be 
Trim(Part(ToText([my multi select field]),1,";"))





------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------