I am trying to remove extra " marks that are around my data.
I would like to see if there is a calculation that removes the " mark from both the first and last character space in a field. It is a text field that stores check numbers. When the data was exported from the old system the "" was added around all of the values.
I tested the RIGHT() function and was able to remove the left hand side one, but I can't get both.
Thanks for the help!
Start Free Trial
