Can you please provide workbook?
I have attached... I am using 2019.1
I tried adding an apostrophe ' and then exporting and changing the delimiter in ms.ex. It was working.
But I need to explain this to my user.
Please help me if you have any other solution...
Thank you so much
Sample_CSV_Issue.twbx 14.2 KB
You have two option to solve your problem.
Option 1: Create one calculated dimension which is as below
STR('=CONCATENATE("') + [S Id] +STR('"," ")')
Option 2: Create one calculated dimension which is as below
' '+ [S Id]
you need to add one Unicode character before [S Id] and you will get that Unicode character to go below path.
If you have Window OS then Press Window Key + R and type 'charmap'
Select 'Yu Gothic' Font and select as below mention special character.
Once you select above Unicode character after then click on select button and copy that Unicode character.
And paste into calculation dimension which is as below
Now export your data into excel and you will get output as below
Let me know if you have any issue.
Please find attached workbook for your reference.
Sample_CSV_Issue.twbx 12.9 KB
Thank you so much Bhadresh.....
Option two suited my scenario...
Option 1 is also working, but it is displaying the Excel formula in server, which is not we expected...
Option 2 works great....