Formating Field

[Anonymous]

Hi! I have a Supplier Number field that is including invisible quotes when exported to Excel (see screenshot below). How can I get these quotes removed?

The field is pulled in as text(Supplier_Number) as Supplier_Number

and displayed in a chart as a dimension: SubStringCount('|' & Concat(distinct %Dimensions, '|') & '|', '|Supplier Number|')

The field does contain alphanumeric values.

[Anil_Babu_Samineni]

Can you try this?

Trim(Replace(Text(Supplier_Number), Chr(34), ' ')) as Supplier_Number

[Anonymous]

Hi Anil, thanks for the suggestion! But, I'm still getting the same issue.

[Anil_Babu_Samineni]

Can you provide sample to demonstrate the issue?