Solved: Extracting a list of Unique IDs from a text field - Page 2

Adm_Tech · 05-10-2020 02:25 PM

Hi Community,

how to extract from a column only IDs of a jobs?

The column value concatenates IDs and descriptions, e.g.:

OifY0Thq: „text1”/ 101e9c50: „text2”/ bc49a497: „text3”/ 89f7bba2:”text4”

I need to extract these IDs, find them in different rows in another table and set up the dates for a specific column.

Suppose that should be possible.

Thank you!

Steve

You might reconsider your schema. Concatenating a raw ID with an arbitrary text value seems impractical, unless the concatenation is a key value.

The easier-but-less-efficient approach would be to add a virtual column to the table containing these concatenated values, with an app formula expression like this:

INDEX(SPLIT([Concatenated Column], ": "), 1)

The resulting value of the virtual column would be the ID component of the concatenated value.