Forum Discussion

DanPark1's avatar
DanPark1
Qrew Cadet
9 years ago

How to Capture Parts of a Long String

I have a string "FirstName_John_LastName_Smith_Job_Programmer" I would like to capture with formula text fields First Name: "John" Last Name: "Smith" Job: "Programmer" I've tried playing ar...
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
9 years ago
>... I suspect that is going to be very difficult and likely impossible with native QuickBase. 

It is simple:

Formula for [First Name] =
If(
  Part([String], 1, "_") = "FirstName", Part([String], 2, "_"),
  Part([String], 3, "_") = "FirstName", Part([String], 4, "_"),
  Part([String], 5, "_") = "FirstName", Part([String], 6, "_")
)
Formula for [Last Name] =
If(
  Part([String], 1, "_") = "LastName", Part([String], 2, "_"),
  Part([String], 3, "_") = "LastName", Part([String], 4, "_"),
  Part([String], 5, "_") = "LastName", Part([String], 6, "_")
)

Formula for [Job] =
If(
  Part([String], 1, "_") = "Job", Part([String], 2, "_"),
  Part([String], 3, "_") = "Job", Part([String], 4, "_"),
  Part([String], 5, "_") = "Job", Part([String], 6, "_")
)
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    9 years ago
    We were both working on this at the same time.