Why Multi Field Formula omitting first field name to remove double quotes??

I have been running below workflow and i have used Multi Field Formula to get rid of double quotes for each value. However, when i run workflow the first value is still showing double quotes. Is there any way i can fix this. You can see below screenshot to understand the problem.

Expression

Accepted answers

mceleavey

Hi @indras111 ,

It's what I thought.

Try:

replace([_CurrentField_],'"','')

Thableaus

@indras111

Apparently there's a hidden character before your quotes. And it's the Unicode 65279 character, "ZERO WIDTH NO-BREAK SPACE",, according to this article:

https://stackoverflow.com/questions/9691771/why-is-65279-appearing-in-my-html

I'd remove it this way:

stripquotes(ReplaceChar([_CurrentField_], CharFromInt(65279), ""))

Cheers,

All comments

Thableaus

Hi @indras111

Could you please show full configuration of your Multi-Field formula tool?

Cheers,

indras111

Thank you for quick response. Please find the below screenshot.

DataKyle

Is there any reason in particular that you use the multi field tool to strip the quotes?

There is a StripQuotes function that you can put in a formula tool as long as the data is a string (looks to be the case for your image).

I think you can also use the Trim function within a formula tool to remove quotes.

mceleavey

I imagine it's because they are applying that function across all fields. However, I also think the problem may be because the quotes are not the standard quotes. Remove them using the replace function, but specifically copy and paste the quotes from the results window into the formula to ensure you're using the correct quotes. If they're double quotes make sure you wrap them in single quotes.

indras111

I have this double quotes for all field values. So i have used multi field formula tool to do the same. Please refer my screenshot in my comment.

estherb47

Hi @indras111

+1 on @mceleavey 's comment.

My guess is that they are not standard quotes as well. I'd copy from the results window, and use the Replace function to remove them

Replace([_CurrentField_],'"',"")

If they are double-quotation marks (unicode character 34), StripQuotes would work. If not, add another Multi-Field formula tool, and paste in the offending character in the what to replace part. You might also try single quotes surrounding the character.

Cheers!!

Esther

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703