lotus notes domino designer text field contains special characters? -
my lotus notes field allows special characters stored in text box example franco martínez, josé ramó name has special character í, é, ó how not allow user paste such character ?
also, when create view can convert simple string using method not contain special characters ?
over input validation of field can use @fomular post failure when user use 1 of these characters. use this

@if( @contains(field_1;"í");@failure("no í");@contains(field_1;"é");@failure("no é");@contains(field_1;"ó");@failure("no ó");@success) if change characters of exsitings doc, can use ls agent change characters of marked documents in view.
dim session new notessession dim doccol notesdocumentcollection dim doc notesdocument dim eval variant set doccol =session.currentdatabase.unprocesseddocuments if doccol.count =0 msgbox "please mark docs" ,0, "please mark docs" exit sub end if set doc = doccol.getfirstdocument() until doc nothing eval = evaluate({@replacesubstring(field_1;"í":"ó":"é";"i":"o":"e")}, doc) call doc.replaceitemvalue("field_1", eval) call doc.save(true,false, true) set doc = doccol.getnextdocument(doc) loop to change characters in view column take
@replacesubstring(columnvalue;"í":"ó":"é";"i":"o":"e")
Comments
Post a Comment