Menu
Welcome, Guest
Username: Password: Remember me
Support for Advanced Open Workflow, Sales, Portal for SugarCRM Community Edition

TOPIC: Need report results with comaseparation

Need report results with comaseparation 2 months 6 days ago #89316

  • Bracon
  • Bracon's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
Hi,
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?

Br
The administrator has disabled public write access.

Need report results with comaseparation 2 months 6 days ago #89325

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 11374
  • Thank you received: 1687
  • Karma: 386
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

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Need report results with comaseparation 2 months 3 days ago #89357

  • Bracon
  • Bracon's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
Hi,
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
Br
Attachments:
The administrator has disabled public write access.

Need report results with comaseparation 2 months 3 days ago #89378

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 11374
  • Thank you received: 1687
  • Karma: 386
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.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Need report results with comaseparation 2 months 2 days ago #89417

  • Bracon
  • Bracon's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
Hi,
Great, se attachment. It is a csv so I had to Zip it.
Br
Attachments:
The administrator has disabled public write access.

Need report results with comaseparation 2 months 23 hours ago #89509

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 11374
  • Thank you received: 1687
  • Karma: 386
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
=SUBSTITUTE(A2,CHAR(10),", ")

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Need report results with comaseparation 1 month 4 weeks ago #89597

  • Bracon
  • Bracon's Avatar
  • Offline
  • New Member
  • Posts: 4
  • Karma: 0
Hi,
Ok, thanks for trying :)
The administrator has disabled public write access.
Time to create page: 0.079 seconds
Powered by Kunena Forum