Forum Discussion
Need help with removing apostrophe while from data
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
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 YouTubeShivu-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.
- Use the "Replace Values" feature:
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!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!
6 Replies
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 YouTubeHi 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-4d70-91a1-3827b5995eab2. 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!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.
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!
- Use the "Replace Values" feature:
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.
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!
