Trim Double Quotes from All of My Data

[Anonymous]

So I am loading CSV data in using the SharePoint Folder option. However, all of my data is loading into one column - it is not getting delimitted. 

So I used the Split Column option to delimit by a comma with a quote character of double quotes. However, one of my columns has a few rows with a double-quote in the data which is messing up my formatting.

I changed by Split Column option to not have a quote character setting but now all of my data is contained within double quotes. Is there any easy way to remove all of the double quotes? 

I tried to use text.trim in the M code but I cannot figure it out so any help would be greatly appreciated. Thank you!

[JakeInUK]

Text.Replace([field],Character.FromNumber(34),"")

[HotChilli · Accepted solution]

You could right-click a column and choose 'Replace Values' . Replace " with nothing