I am trying to to the a CR separated list of values in a text field but not getting it .. any ideas ... the source and target field look alike .. i thought the list function does that
Substitute ( <YourTextField> ; " " ; "¶" )
Wy dont you use the function List (statistics) to get unique value out of a field
You are making this very difficult.
You will need to provide a lot more detail about what you are trying to do.
Are you dealing with one field? The values in one field across a found set?
I am getting unique values but i want carriage returns after each value
Sorry i didnt give enough info ... its just one fied containing text eg .. "This is a nice day"
I need the list function to give me "This CR"
Note : CR is for carriage return
Retrieving data ...