Forum Discussion
SystemAdmin7
Qrew Cadet
There may not be a good answer for this...
The fields that I am combining in to one are a rich text field, so when I create a combined text it's changing all the "&" to & and all the line breaks to " " The problem I am now running in to is that the Trim(Part($value,1,";")) is using the first semicolon in the text to break it up, which is sometimes contained in the " " etc. Do you know if there's a way around that? Looks like that is the ticket to getting it to sort new - old.
------------------------------
Amanda Luna
------------------------------
The fields that I am combining in to one are a rich text field, so when I create a combined text it's changing all the "&" to & and all the line breaks to " " The problem I am now running in to is that the Trim(Part($value,1,";")) is using the first semicolon in the text to break it up, which is sometimes contained in the " " etc. Do you know if there's a way around that? Looks like that is the ticket to getting it to sort new - old.
------------------------------
Amanda Luna
------------------------------
SystemAdmin7
5 years agoQrew Cadet
Figured out a work around for anybody in the future:
1. Append a not commonly used character to the end of the field that you are going to create a combined text out of. I used "|".
2. Then use theList(", ",
Trim(Part($value,1,"|")),
Trim(Part($value,2,"|")),
Trim(Part($value,3,"|")),
Trim(Part($value,4,"|")), Etc
Formula posted by Mark, but instead of using a semicolon, you're going to use the special character you appended to the field above. I did warn everybody on staff that that character will break up the text weird if used, and they said they never use it anyway. That's the best I could work out.
------------------------------
Amanda Luna
------------------------------