2

I'm trying to get a delimited string in a single field into a list breaking to a new line at the delimeter. I've played around with the array functions to turn the list into an array based on the delimiter but can't make it into a list within the multiline Text Edit box in a dialog. String is like this: X000053437,2014-07-23,0359171,AA;X000086283,,0392438,BB;X000110251,,APB90P50UU,CC;X000126723,,03094,DD
but I want it to appear like this:

X000053437,2014-07-23,0359171,AA;
X000086283,,0392438,BB;
X000110251,,APB90P50UU,CC;
X000126723,,03094,DD

1 Answer 1

1

Using the Field Calculator, you can replace the delimiter with the new line special character \n:

replace("list_field", ';', '\n')

enter image description here

If you want to keep the semicolon, replace with ;\n

2
  • Thank you Matt - trying to be too clever and forgot to keep it simple!
    – RBCMark
    Mar 3, 2022 at 13:06
  • I am familiar with this struggle. Things are often far simpler than we initially think.
    – Matt
    Mar 3, 2022 at 13:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.