Using the Part and List functions from here:
https://login.quickbase.com/db/6ewwzuuj?a=q&qid=12, your formula would look like this:
List("",
Part([Job Number],1,"-"),
Part([Job Number],2,"-"),
Part([Job Number],3,"-"),
Part([Job Number],4,"-"),
Part([Job Number],5,"-")
)
You could also keep the pattern going for however many sections you expect to need to combine together. If there are other delimiter characters you want to split on, you can also add those to the hyphen area.
------------------------------
Eric Mohlman
------------------------------
Original Message:
Sent: 09-13-2019 14:40
From: Amanda Torrisi
Subject: Extract a portion of plain text
I am simply trying to extract a portion of a regular text field.
So if the field [Job Number] is 12345-345-12-3456, I just want a formula that just extracts the 12345-345 into another field.
I feel like it is something simply I just cant wrap my head around it.
Thank you.
------------------------------
Amanda Torrisi
------------------------------