Concatenate adding quote marks

[Matt_Frederick]

This has been asked a few times but I can’t seem to find the solution that works.

I have a formula "CONCATENATE({For Formula},{Market},{Product Management},{Product Category},{Gender})" but its output adds unwanted quote marks like so:

What I really want is to have it be separated by “/” but I’ve exhausted the time I have trying to fix that. How can I get this to output something with consistent quote marks - or comma separation - or preferably the /

Thanks!

[augmented]

Hey Matt, the only way that I can make the double quotes appear is to have the field values inside double quotes.

Otherwise I get this…

And if I use this formula,

CONCATENATE(Text1,"/",Text2)

I get this

Did I miss something from your questions? I must have.

[Matt_Frederick]

Thanks Augmented, yeah have tried that but the formula won’t run at all without the brackets or quote marks. Maybe due to the spaces in the Field names?

[augmented]

Yes. Sorry, I simplified my example field names. Does it work if you put the curly braces back in your new formula?

[Matt_Frederick]

No, have tried every version with and without so maybe its not syntax related?

[Matt_Frederick]

What’s odd is that when it does work with the quotes, even that is not consistent - note there’s no lead-in quote after Photography

[augmented]

No, you always need double quotes around the backslashes. Did you try it with curly braces around the fields and double quoted backslashes?

[Matt_Frederick]

Yes, have tried combinations of quotes, double quotes, single quotes, etc… Out on location the next few days so will try again fresh next week. Thanks for the help and ideas.

[Justin_Barrett]

Regarding the extraneous quotes, what type of fields are these? Something tells me that the field type will provide a clue to the quotes (and the spaces inside the quotes). My gut says that there are some linked records and/or lookup/rollup fields in the mix somewhere.

That aside, you can always strip out the quotes (and their adjacent spaces) after the concatenation is complete by using the SUBSTITUTE() function a couple times. Try this:

SUBSTITUTE(SUBSTITUTE(CONCATENATE({For Formula},"/",{Market},"/",{Product Management},"/",{Product Category},"/",{Gender}), '" ', ""), ' "', "")

[Matt_Frederick]

Thanks Justin, the fields are links to tables that are all set up the same way.