13 September 2019 10:18
I use the report modul a lot. But I have issue when I get results from a dropdown list. The result is separated with an arrow. That makes it hard to work with the result in an excelsheet etc. Is there a solution to get results with comaseparetion insteed?
Anyone who can help?
13 September 2019 12:52
Can you please also post a screenshot of the original field, in the edit view? I want to see what the users see when they are filling that field (not in the report).
I am wondering if this is a multi-select field. Also tell me if you have some add-on for this kind of fields. Thanks
16 September 2019 11:27
Thansk for digging into this :cheer:
Yes it is a multi-select field and I have no add for this field.
Se attached screenshot as asked for, Thansk
16 September 2019 15:54
Can you also attach a small CSV with just a couple of exported records that have that sort of field?
I’d like to see exactly which character is getting generated in the CSV.
17 September 2019 08:13
Great, se attachment. It is a csv so I had to Zip it.
18 September 2019 16:43
That’s just a simple line-feed character (code 10 ascii)
I tried to find the place in the code where that is created, but I couldn’t find it, sorry.
Maybe you can just use a formula to change that when you get to Excel.
For example, if the value is in cell A2, just add a formula somewhere saying
20 September 2019 06:37
Ok, thanks for trying