Help

Remove double quotes and comma from MID

Topic Labels: Formulas
871 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Susan_Martin
4 - Data Explorer
4 - Data Explorer

Hi there - I’m trying to create a formula that will remove the double quotes and comma from the middle of a string, and although it works on one field, it doesn’t work on another.

IF(LEFT({Text}, 1)=’"’, MID({Text},3, LEN({Text})-2), {Text})

That works for one field, but not another. What am I getting wrong, or is there another, better way?

Thanks!

0 Replies 0