Removing just one quotation mark from a .csv file for row by row comparison
I am having an issue when running the row by row comparison in Tosca BI where I am comparing a database to a .csv file.
The .csv file is using quotation marks to indicate each column's values and therefore I am using Trim[""""] to get rid off the quotation marks so it can be compared with the values in the database. However, I have a value that ends with quotation marks (and therefore in the .csv file it has two quotation marks at the end). Both of these quotation marks get removed and I get an error that the values are not matching.
I have also tried TrimStart[""""] and TrimEnd[""""], however I get the same result.
Is there any way to just remove the last quotation mark and leave the other?