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

[indras111]

Hi

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.

[indras111]

Okay. Here i have attached a dummy file. Please look into it and do the needful. I noticed that there is space before but i couldn't cut it by using trim formula.

[Thableaus]

@indras111 

You need to pack your workflow so it comes with your data input.

Options > Export Workflow

Cheers,

[indras111]

Sorry again. I am new to Alteryx and this community. I have attached the package now.

[mceleavey · Accepted solution]

Hi @indras111 ,

It's what I thought.

Try:

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

M.

[Thableaus · Accepted solution]

@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,

[indras111]

Thank you @mceleavey . That solved the problem.