Need help with removing apostrophe while from data

[AmeenVanakar]

Hi,

I am importing a .csv file with a few columns that contain an apostrophe. These special characters are available at the source hence I need your help with the following 2 points.

1. What is the easiest & a sustainable way to remove apostrophes from the fact table?

2. Is importing data from a .csv file recommended?  as this is the first time I am importing data from a .csv file

[DivkLearner · Accepted solution]

Hello @AmeenVanakar ,

you can add a "Column from Example"

follow the following link: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-add-column-from-example

Best regards,
DivKlearner – A Bit Forward Daily
Join us as we explore and learn IT together.
Discover simplified IT learning on YouTube

[v-aatheeque · Accepted solution]

@Shivu-2000,  @DivkLearner , @Irwan,  Thank you for the prompt response!
Hi @AmeenVanakar ,

Thanks for reaching out to the Microsoft Fabric Community forum.
In addition, To @Shivu-2000 , @DivkLearner , @Irwan Let me also share an additional insight :
1. Once load the data, please refer the below steps :
In the Power Query Editor, select the column(s) that contain apostrophes.

• Use the "Replace Values" feature:
  • Right-click on the column header and select "Replace Values."
  • In the dialog box, enter the apostrophe (') in the "Value to Find" field and leave the "Replace With" field empty.
  • Click "OK" to apply the changes.

    Below is the screenshot for your reference:

    

    2. Here are the results generated using the above approach.

    

    If my response answered your question, feel free to mark it as a solution to help others find it easily! And if you found my reply helpful, don't forget to give a "Kudos" – I’d truly appreciate it! 
    
    Best regards,
    ThankYou.

[v-aatheeque · Accepted solution]

HIi @AmeenVanakar ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque · Accepted solution]

Hi @AmeenVanakar ,

We noticed we haven’t heard back from you regarding our previous response. If it resolved your query, kindly mark it as Accept Answer and click Yes if you found it helpful. Doing so can also benefit other community members.

If you have further questions related to this thread, feel free to let us know, and we’ll do our best to assist you.

For any unrelated issues, we recommend starting a new thread so we can address your query effectively.

Thank you!

[v-aatheeque · Accepted solution]

@Shivu-2000,  @DivkLearner , @Irwan,  Thank you for the prompt response!
Hi @AmeenVanakar ,

Thanks for reaching out to the Microsoft Fabric Community forum.
In addition, To @Shivu-2000 , @DivkLearner , @Irwan Let me also share an additional insight :
1. Once load the data, please refer the below steps :
In the Power Query Editor, select the column(s) that contain apostrophes.

• Use the "Replace Values" feature:
  • Right-click on the column header and select "Replace Values."
  • In the dialog box, enter the apostrophe (') in the "Value to Find" field and leave the "Replace With" field empty.
  • Click "OK" to apply the changes.

    Below is the screenshot for your reference:

    

    2. Here are the results generated using the above approach.

    

    If my response answered your question, feel free to mark it as a solution to help others find it easily! And if you found my reply helpful, don't forget to give a "Kudos" – I’d truly appreciate it! 
    
    Best regards,
    ThankYou.

[v-aatheeque · Accepted solution]

HIi @AmeenVanakar ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[Shivu-2000]

Hi @AmeenVanakar 

The solution  @Irwan  provided you can give it a try but here is more optimized one
1. Simply go to powerquery by clicking on -> transform data tab and -> than under the add column use -> Column by example to have a new column based on your existing one but with removed aposhtrophe
For reference follow https://support.microsoft.com/en-us/office/add-a-column-from-an-example-power-query-cd82c570-8da7-4d...

2. Yes it is good to use cv=sv files as  It's widely used for data management due to its simplicity and compatibility with various software applications, making it ideal for data exchange

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!

[DivkLearner · Accepted solution]

Hello @AmeenVanakar ,

you can add a "Column from Example"

follow the following link: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-add-column-from-example

Best regards,
DivKlearner – A Bit Forward Daily
Join us as we explore and learn IT together.
Discover simplified IT learning on YouTube

[Irwan]

hello @AmeenVanakar 

is "Replace Value" in PQ plausible for your case?

personally i imported .csv and so far there is no issue.

Hope this will help.

Thank you.