Hey folks, I hope I’m missing something simple here - I’m developing a table where I’m managing files stored on my various NAS and computer system(s).

I’m simply trying to concatenate strings like a drive letter “D:”, a folder “Documents” and finally a Filename “Testfile.txt”

In my table, I have a formula column [Pathname] where I attempt bring all of these fragments together e.g.:
“D:” + “\” + “Documents” + “\” + “Testfile.txt”

And I get errors in the formula due to the backslash? (…And I’m noticing here creating this post, singular backslashes disappear and I have to double them up just so this message reads correctly!)

I tried escaping the backslash in my formulas using double backslashes “\\”, singular characters: ‘\’ etc., with no joy?

Am I missing something simple?

My NAS drive would be “\\MultimediaNAS\…” with two leading backslashes but all the formulas I attempt to put together just to get my various file path elements merged together all lead to errors within the concatenations.

Any help appreciate on how to accomplish this is appreciated! (Is there a Chr() or other text function I’m missing perhaps??)

Add-on: Apparently you can also obtain a backslash (\) using the Character() formula .
And the Backslash (Reverse solidus) corresponding CharNumber is 92 :

Character(92) → \ .

So I’ve just updated the sample and added 2 other formulas
One using some ListCombine() & Join()