none
Replace double qoute in report Designer 3.0

    Question

  • Hello I am trying to create a CSV file in doing so my decription feild has " in it that dont play nice with the software needing that CSV file. I am now trying to use a replace() to remove all " from that field with no luck.
     things I have tried
    =Replace(Fields!EditedDescription.Value,""","")
    =Replace(Fields!EditedDescription.Value,"""","")
    =Replace(Fields!EditedDescription.Value,'"','')
    =Replace(Fields!EditedDescription.Value,"/"","")
    =Replace(Fields!EditedDescription.Value,"chr(32)","")
    =Replace(Fields!EditedDescription.Value,""""","")

     and a few other methods but nothing

    Friday, February 07, 2014 2:18 AM

Answers

  • Hi Marquee,

    The expression:
    =Replace(Fields!EditedDescription.Value,"""","")
    works fine in my sample report.
    What's the error when you use this expression?

    If I have anything misunderstood, please point it out.

    Regards,


    Charlie Liao
    TechNet Community Support

    Monday, February 10, 2014 9:15 AM
    Moderator
  • Hello Phillip,

    What do you mean by 'but nothing'. Error message or do you simply see the text in your report with no replacement at all, or do you see the replaced text in the report but not in the CSv file? Do you export to CSv with the export dropdown in standard report toolbar in the browser?

    have you tried changeing your select statement in the dataset and use a SQL replace statement? (if your dataset is based on a SQL database of course).


    Jan D'Hondt - SQL server BI development

    Monday, February 10, 2014 10:38 AM
  • Hi Phillip,

    Try in backend ( Query ) like below

    select replace('"Production Accounting"','"','') as Department

    it works fine here .

    Try and let me know.


    Regards, Subathra

    Monday, February 10, 2014 12:25 PM

All replies

  • I am trying to create an expression to remove the " from my description field
    Friday, February 07, 2014 2:21 AM
  • Hi Marquee,

    The expression:
    =Replace(Fields!EditedDescription.Value,"""","")
    works fine in my sample report.
    What's the error when you use this expression?

    If I have anything misunderstood, please point it out.

    Regards,


    Charlie Liao
    TechNet Community Support

    Monday, February 10, 2014 9:15 AM
    Moderator
  • Hello Phillip,

    What do you mean by 'but nothing'. Error message or do you simply see the text in your report with no replacement at all, or do you see the replaced text in the report but not in the CSv file? Do you export to CSv with the export dropdown in standard report toolbar in the browser?

    have you tried changeing your select statement in the dataset and use a SQL replace statement? (if your dataset is based on a SQL database of course).


    Jan D'Hondt - SQL server BI development

    Monday, February 10, 2014 10:38 AM
  • Hi Phillip,

    Try in backend ( Query ) like below

    select replace('"Production Accounting"','"','') as Department

    it works fine here .

    Try and let me know.


    Regards, Subathra

    Monday, February 10, 2014 12:25 PM