How to get my variable to replace all spaces with underscore

Matra · **Posted:** June 5th, 2015, 2:29 pm

Good day,

I am trying to create a table with the users name and idnumber as the name of the table, the code works fine except when the user's name got a space somewhere then no table will be created in MSACCESS (I don't know why), do anybody know the solution to this problem, or how can I force the "loginuser" to leave out all the spaces or be replaced by a underscore

Code:

var myDB = new Database("FILEDSN=C:\\Backup\\CBT\\Published\\J281 Ross Operators\\Data\\database.dsn");
myDB.ExecuteSQL("CREATE TABLE " + loginuser + "_" + loginidnumber + "  (street varchar(15))");

Please help.

Lar_123 · **Posted:** June 6th, 2015, 11:28 am

Very hard to follow or solve when you have 3 different threads started on basically the same problem. Replies and attempts to understand and help.... get fragmented quickly. I for one will lose interest here.

Digital Workshop

How to get my variable to replace all spaces with underscore

Who is online