fbpx
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: How to mask { and } in a string

How to mask { and } in a string 4 months 2 weeks ago #1

  • wriedmann
  • wriedmann's Avatar Topic Author
  • Away
  • Posts: 1339
  • Karma: 6
  • Thank you received: 6
Hello,

I'm trying to build a connection string like this:
String.Format( "Driver={Microsoft access Driver (*.mdb)};Dbq={0};Uid=Admin;Pwd=;", cDatabase )
But it gives a runtime error because of the parentheses { and }.

Is there any possibility to mask them?

TIA

Wolfgang

Please Log in or Create an account to join the conversation.

How to mask { and } in a string 4 months 2 weeks ago #2

  • FFF
  • FFF's Avatar
  • Offline
  • Posts: 462
  • Thank you received: 4
Wolfgang,
FUNCTION Start() AS VOID
LOCAL c AS STRING
c:="Driver={Microsoft access Driver (*.mdb)};Dbq={0};Uid=Admin;Pwd=;"
Console.WriteLine(c)
RETURN

works for me.
Seems i miss the point ;)
EDIT Obviously.
BTW, there should be a "Delete" button for own posts...

Adding an "i" wouldn't be of use?

Please Log in or Create an account to join the conversation.

Last edit: by FFF. Reason: bs

How to mask { and } in a string 4 months 2 weeks ago #3

  • wriedmann
  • wriedmann's Avatar Topic Author
  • Away
  • Posts: 1339
  • Karma: 6
  • Thank you received: 6
Hi Karl,

if you add a String.Format() and a parameter, it fails.

The same is occurring when using the prefix "i".

Wolfgang

Please Log in or Create an account to join the conversation.

How to mask { and } in a string 4 months 2 weeks ago #4

  • robert
  • robert's Avatar
  • Offline
  • Posts: 798
  • Karma: 6
  • Thank you received: 15
Wolfgang, you can escape the { and } characters by adding two of them in a row, so you will have to write:

"Driver={{Microsoft access Driver (*.mdb)}};Dbq={0};Uid=Admin;Pwd=;"

Robert
XSharp Development Team
The Netherlands
This email address is being protected from spambots. You need JavaScript enabled to view it.

Please Log in or Create an account to join the conversation.

How to mask { and } in a string 4 months 2 weeks ago #5

  • wriedmann
  • wriedmann's Avatar Topic Author
  • Away
  • Posts: 1339
  • Karma: 6
  • Thank you received: 6
Hi Robert,

thank you very much! This works.

Thank you again.

Wolfgang

P.S. this is used in a X# monitoring service that will go into production on Monday

Please Log in or Create an account to join the conversation.

How to mask { and } in a string 4 months 2 weeks ago #6

  • Jamal
  • Jamal's Avatar
  • Offline
  • Posts: 43
  • Thank you received: 1
I don't know about X#, but in C# whenever you want certain characters like \ in a string, I used the @ sign prefix.

For example: @"\programs files\test"

otherwise I have to write @"\\program files\\test"

Jamal

Please Log in or Create an account to join the conversation.

Last edit: by Jamal.

How to mask { and } in a string 4 months 2 weeks ago #7

  • wriedmann
  • wriedmann's Avatar Topic Author
  • Away
  • Posts: 1339
  • Karma: 6
  • Thank you received: 6
Hi Jamal,

normally this works also in X# (but with the prefix 'e' instead of '@'), but this does no worked for the '{' character.

The answer from Robert helped, doubling the '{' and the '}' character solved the problem.

Wolfgang

Please Log in or Create an account to join the conversation.

How to mask { and } in a string 4 months 2 weeks ago #8

  • Chris
  • Chris's Avatar
  • Offline
  • Posts: 898
  • Thank you received: 11
Hi Jamal,

In X#, it's the opposite of c#. c# uses escaped strings by default and you need to use @ in order to make them "regular" strings. In X#, literal strings are "regular" by default, and you need to prefix them with e to make them escaped.

Chris
XSharp Development Team
chris(at)xsharp.eu

Please Log in or Create an account to join the conversation.

  • Page:
  • 1