Use Replace in Access SQL only when the first two characters of the string match my pattern -

-

i'm working database names apostophes in them (e.g. irish or scottish style names such o’doherty) stored space instead of apostophe (e.g. "o doherty").

in query, want return names in correct format (just in select query, rather changing data), i've used:

 replace([snametemp],"o ","o’")

this works in theory, problem i'm having there matches pattern further along string: e.g., "do not use" returned "do’ not use".

how write replace statement checked first 2 characters of string?

should in access

iif(snametemp "o *", replace([snametemp],"o ","o’"), snametemp)

Comments

Post a Comment

Popular posts from this blog

javascript - How to name a jQuery function to make a browser's back button work? -

-
i'm trying write function ajaxyfy web site, works perfect, except function button. that's have now: function loading() { if (typeof history.pushstate !== "undefined") { var historycount = 0; $('.menu-item, .logo').on('click','a',function(e){ e.preventdefault(); $(this).data('clicked', true); if ($(this).is('.logo a')) { var homepage = $(this).attr('href'); function1(homepage); history.pushstate(null, null, homepage); } else if ($(this).is('.projects a')) { var projects = $(this).attr('href'); function2(projects); history.pushstate(null, null, projects); } else { var pages = $(this).attr('href'); function3(pages); history.pushstate(null, null, pages); ...
Read more

java - gson parse items from comma-separated-value string within a json value -

-
i parsing json string using gson . similar this: { "acode": "aa", "rcode": "rr", "errors": "e1,e2,e3" } i think errors should have been proper json array, don't have control of that. i want errors array or collection in java . easy enough using string.split comma separator. new gson , don't know if ignoring functionality provides parse comma separated string. does know whether gson can handle automatically? i want errors array or collection in java. try one string json = "{\"acode\": \"aa\",\"rcode\": \"rr\", \"errors\": \"e1,e2,e3\" }"; class errorsdeserializer implements jsondeserializer<string[]> { public string[] deserialize(jsonelement json, type typeoft, jsondeserializationcontext context) throws jsonparseexception { return ((jsonobject) json).getasjsonprimitive(...
Read more

Validation in java Error log in register -

-
i trying set validation of confirm password , textfield must have value in it. im beginner sir im practicing build log in , register program. sorry english im not great in speaking english. my problem code not running fine. keeps telling "fill spaces" string username = usernamefield.gettext(); string password = passwordfield.gettext(); string cpassword = cpasswordfield.gettext(); if ((username != null) || (password != null) || (cpassword != null)) { if (password == cpassword) { db.insertdata(username, password); joptionpane.showmessagedialog(null, "data has been entered"); } else { joptionpane.showmessagedialog(null, "please fill spaces"); } } else if (password != cpassword) { joptionpane.showmessagedialog(null, "password mismatch"); } if((username != null) || (password != null) || (cpassword != null) ){ if(password.equals(cpassword)){ db.insertdata(username, password); joptio...
Read more