Replace " and ' characters

I am working with data submitted by field personnel. Very often our questions ask for lengths and measurements, and naturally they use " and ' symbols to designate feet and inches, which causes issues in our data and reports later on. I am needing to replace these ' and " characters with "ft" and "in" respectively. For some reason the following will not work for me. I can't just use the StripQuotes() function either because units are pretty important information.

Replace([FIELD], '"', 'ft')
Replace([FIELD], "'", "in")

Does anyone have any other suggestions? Thanks!

Regex

Help

Expression

Accepted answers

JosephSerpis

Hi @Larissaah I worked out the issue your " and ' are slightly different in the examples your provided. Therefore I had to copy and paste them from the examples into the formula to work. In the amended workflow attached you see that I have added extra arguments to deal with them. I also came up with a third approach you might find easier to use. Let me know what you think?

Replace_05112020_V1.yxmd

All comments

JosephSerpis

Hi @Larissaah I mocked up a couple of ways to do this utilising your formula and its working for me.

Replace_05112020.yxmd

Larissaah

Hi @JopsephSerpis

You're right, your example does work for me - what the heck! But it will not work for my strings. I added a couple of examples from my data to this. Let me know if I'm just missing something obvious here or what you think. Thanks!

Replace_05112020_LH.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703