How to get my variable to replace all spaces with underscore

Matra · **Posted:** June 5th, 2015, 2:27 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.

pc_amethyst · **Posted:** June 15th, 2015, 2:20 pm

Your question has been sitting here for a while so I thought that I would resolve it today. The attached example is self-explanatory and shows two solutions to your 'no spaces in the name problem':

1. let the user enter the text naturally, then remove with a tiny amount of script as shown in the example when you press the button.

2. in the input box untick the 'allow special characters option'. The disadvantage is that hyphenated names won't show either, but if the user knows that no spaces are allowed in the user name this should only result in mild grumblings from those with double-barreled names. :roll:

It is good practice to put an instruction to the user asking them not to enter spaces, then you simply trap for the typing errors they will inevitably make.

If you have any further queries please post them here and we'll be happy to help.

Paul

Digital Workshop

How to get my variable to replace all spaces with underscore

Who is online