In the words of Freddy Mercury - I think I’m going slightly mad.
I have a field which holds more than one value, so its a text list. I have a view used for exporting to Excel & such, on which we want this field to appear as one value & only one row per document otherwise you get blank lines on exporting. Therefore I have @Implode(fieldname) or @implode(fieldname;“|”) as the column formula.
Up until recently this worked perfectly. Now the @Implode doesn’t seem to be able to tell that it has a text list to work on & we get commas between each value in the field.
So far I assumed it must be some sort of corruption and have tried Fixup & UPDALL against the database with no effect. (Oh, I took a copy & pushed that to my home notes domain & it happened there too).
Before I completely lose my mind has anyone got any bright ideas that I can try.
Your data might be messed up. Have you checked field values in document property to make sure that the data is represented as a text list? If you have not I would suggest look at the document property from the view without opening the document to make sure you are passing a text list.
After various varieties of creating subsets of the original database I got really creative and made a totally new view. I added in one of these multi-value fields & imploded it and it worked. Added a few more, also worked. Tried putting this nice shiny new view into the orignal databse & it worked there too!!
I therefore guess that the column has got mangled in the orignal view & I have to rebuild (all 95 columns) from scratch.
Sue, That is great you were able to solve the problem.
There is usually unpredictable behavior in views when copying and pasting columns and more than one column ends up having the same programmatic name. Not sure if this was the problem with your view but just something to be aware of in case you didn’t know.