How to mask { and } in a string

More
2 weeks 3 days ago #1 by wriedmann
How to mask { and } in a string was created by wriedmann
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.

More
2 weeks 3 days ago - 2 weeks 3 days ago #2 by FFF
Replied by FFF on topic How to mask { and } in a string
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?
Last edit: 2 weeks 3 days ago by FFF. Reason: bs

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

More
2 weeks 3 days ago #3 by wriedmann
Replied by wriedmann on topic How to mask { and } in a string
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.

More
2 weeks 3 days ago #4 by robert
Replied by robert on topic How to mask { and } in a string
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.

More
2 weeks 3 days ago #5 by wriedmann
Replied by wriedmann on topic How to mask { and } in a string
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.

More
2 weeks 3 days ago - 2 weeks 3 days ago #6 by Jamal
Replied by Jamal on topic How to mask { and } in a string
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
Last edit: 2 weeks 3 days ago by Jamal.

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

More
2 weeks 3 days ago #7 by wriedmann
Replied by wriedmann on topic How to mask { and } in a string
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.

More
2 weeks 3 days ago #8 by Chris
Replied by Chris on topic How to mask { and } in a string
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.