cfml

So I have this data in a column, obviously it has some carriage return line feeds in it. I can't figure out how to change the delimiters to "|".
Administrative Staff
Assistants
Hygienists
Dental Students
Guests
Dentists

#listLen(x, "chr(10)chr(13)")# only returns 2.

`column.listToArray( chr(10) ).toList("|")`

but you should output the column text and see what the actual delimiters are.

<https://trycf.com/gist/81cce6f97eb44258140dcd4f820ff523/acf2018?theme=monokai>

```ArrayToList(column.split("\R"), "|")```

#listChangeDelims(x, ',', '#chr(10)##chr(13)#')#

#listLen(x, "#chr(10)##chr(13)#")# gave me 6

```
newList = ArrayToList(column.split("\R"))```
The split is doing a java regular expression split and the \R is all possible EOL values