Forum Discussion
Advocate IIPulling a value from multiline text into a custom column
Jays_D Or alternatively create three calculated column,
//checks if the column has checked value
HasChecked = CONTAINSSTRING(jobs[jobcomments], "**Checked**")
// for date
Date =
IF(
jobs[HasChecked] = TRUE,
LEFT(jobs[jobcomments],10),
BLANK()
)//for user name
UserName =
IF(
jobs[HasChecked] = TRUE,
MID(
jobs[jobcomments],
12,
SEARCH(":", jobs[jobcomments], 12, LEN(jobs[jobcomments])) - 12
),
BLANK()
)
Community ChampionJays_D Or alternatively create three calculated column,
//checks if the column has checked value
HasChecked = CONTAINSSTRING(jobs[jobcomments], "**Checked**")
// for date
Date =
IF(
jobs[HasChecked] = TRUE,
LEFT(jobs[jobcomments],10),
BLANK()
)
//for user name
UserName =
IF(
jobs[HasChecked] = TRUE,
MID(
jobs[jobcomments],
12,
SEARCH(":", jobs[jobcomments], 12, LEN(jobs[jobcomments])) - 12
),
BLANK()
)
Advocate IIThis has worked brilliantly. I was haalf way there with the first 2 columns (I could do that) I just wasn't sure how to use the delimiter to extract the Username.
Thank you so much, truly aappreciated - I've learned something new today 🙂