Add backslash '\' character between two string?

2

Hi @William_Bell :blush: !

Maybe you could use Format() ? :innocent:

As apparently, the backslash (\) seems to be indeed a bit problematic :thinking: …
But it does seem to work within Format()…

See the formula in quick sample below which looks like this :

Format(
  "{1}:\{2}\{3}",
  thisRow.Drive,
  thisRow.Folder,
  thisRow.File
)

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

  • Character(92) → \ .

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

ListCombine(
  Concatenate(thisRow.Drive,":"),
  thisRow.Folder,
  thisRow.File
).Join(Character(92))

And a simple Concatenate():

Concatenate(
  thisRow.Drive,":",
  Character(92),
  thisRow.Folder,
  Character(92),
  thisRow.File
)

Sorry for the lack of explanations but I hope this will help you a little :innocent:

1 Like