When I use apoc.text.replace, I often wish to extract several values at once and immediately assign each to its own variable. I normally set up an assignment per variable like this:
UNWIND ["John Smith - Consultant",
"Willy Brown - Teacher",
"Jen Mack - Radiologist"] AS person
WITH apoc.text.replace(person, '(\w+)\s(\w+)\s-\s(\w)', '$1,$2,$3') AS extract
WITH split(extract,',')[0] AS first,
split(extract,',')[1] AS last,
split(extract,',')[2] AS role
RETURN first, last, role
...and that works fine, but I wish I could make that less verbose. I am open to any solution.
For example it would be great if I could do something like load the results directly into a map of named parameters like this:
UNWIND ["John Smith - Consultant",
"Willy Brown - Teacher",
"Jen Mack - Radiologist"] AS person
WITH apoc.text.replace(person, '(\w+)\s(\w+)\s-\s(\w)', {first:$1, last:$2, role:$3}) AS p
RETURN p.first, p.last, p.role
I'm open to anything that will make the code more concise.
