Forum Discussion

PatrickPatrick1's avatar
PatrickPatrick1
Qrew Trainee
9 years ago

I want to extract a specific piece of text from another multi line text field.

Say the multi-line text field is called [Data] and it contains the following lines of text: Name: QuickBase Move Date: 9/15/2016 Phone: 000-000-0000 The info before the colons will always be t...
Tables and fields
RicardoTsai's avatar
RicardoTsai
Qrew Member
9 years ago
QuickBaseCoach...  I think it should be TRIM(NotRight(Part([Basic Data], 2, ":"),9)) to get rid of the spaces between the colon and the value. If doing Trim(Right([Basic Data],":")) will only remove leading (before Name)and ending spaces (last phone digit..). At the end, it would look like:
TRIM(NotRight(Part([Basic Data], 2, ":"),9))
TRIM(NotRight(Part([Basic Data], 3, ":"),5))
TRIM(Right([Basic Data],":"))