General

Re: Specific data validation with text box

JeffVojtko — Tue, 25 Feb 2014 15:39:33 GMT

I have a business user who would like to do string validation on a text box in an InfoPath form. And, the validation requirements are more complex than I can understand being a newbie at this. I was thinking about using some sort of a template or format. Anybody have any ideas?
DSN FIELD: Validation rules:
DSN cannot be longer than 44 characters- This is easy

If possible:
Character 1 must be ‘P’ ‘A’ or ‘Q’
Characters 6 thru 8 must be ‘SPM’
Character 9 must be a ‘.’
Characters 14 thru 16 must be numeric
Character 17 must be an ‘S’

Re: Specific data validation with text box

Pasu — Tue, 04 Dec 2012 17:59:01 GMT

Hilary, I am still on version 3.4 and will try your solution when I upgrade to 4.2 or greater.

Jimmy, I replaced the existing condition with that of yours. It works great!

Thank you both!

Re: Specific data validation with text box

Hilary Stoupa — Fri, 30 Nov 2012 15:11:07 GMT

Jimmy - you rock. I thought there would be a way to do this in a formula, but could not, for the life of me, figure it out. That is a very elegant solution! Thanks for chiming in!

Re: Specific data validation with text box

Jimmy — Fri, 30 Nov 2012 15:06:17 GMT

You could also use this condition to check whether a field contains any of the characters you're checking for:

Field != translate(Field, '^\:*?"<>|#{}%~&', "")

Re: Specific data validation with text box

Hilary Stoupa — Fri, 30 Nov 2012 02:24:37 GMT

Well, I don't have anything that seems to do any good with custom pattern function in IP. However, I do have something you can do using qRules - what version are you using? This is using the ReplaceString command, that I think I added in v 4.2....

You'd have to store your Result from GetAttachmentAttribute in another field - I'm just using a main data source field, but you could use a 2ds and include the dsnamesrc param:

ReplaceString /xpathsrc=/my:myFields/my:field1 /pattern=[^\\ / : * ? " < > | # { } % ~ &]

If the command returns anything to the Result field, you have one of the special chars listed....

Re: Specific data validation with text box

Pasu — Thu, 29 Nov 2012 21:47:11 GMT

Thanks Hilary. For now, I am using the following expression to validate the filename of an attachment. But, if there is a better way, I would like to adapt that.

Re: Specific data validation with text box

Hilary Stoupa — Thu, 29 Nov 2012 17:37:32 GMT

That's what I get for testing my regular expression outside of InfoPath.... I'll take a look later today & see if I can come up with something that will work for you.

Re: Specific data validation with text box

Pasu — Thu, 29 Nov 2012 17:12:06 GMT

Thanks Hilary. I tried the following, but got invalid pattern error.

Any help is appreciated.

Thanks!!

Re: Specific data validation with text box

Hilary Stoupa — Fri, 16 Nov 2012 01:16:19 GMT

Yes, you should be able to do this. I think this pattern would work:

[^\\ / : * ? " < > | # { } % ~ &]

So, you'd run your rule for GetAttachmentAttribute, then add another rule with a condition that the qRules data source Result node matches this pattern, and you could then clear the node where they attached the file or give them a message or some such....

Re: Specific data validation with text box

Pasu — Thu, 15 Nov 2012 19:42:33 GMT

I am using SaveToSharePoint qRules method to save InfoPath attachments in a SharePoint document library. When we try to attach files with illegal filename characters (\ / : * ? " < > | # { } % ~ &), the SaveToSharePoint method succeeds but cutting off all characters after the first occurence of the illegal character. That leaves the residue in tha document library, with a broken link inside Infopath. To avoid users uploading a file with illegal character, I am trying to validate the filename of an attachment, using the GetAttachmentAttribute qRules method. Is it possible to validate the result of the GetAttachmentAttribute method to check whether it contains any of the illegal characters, using a pattern?

Thanks a lot in advance.

Re: Specific data validation with text box

Jimmy — Sat, 06 Feb 2010 10:16:28 GMT

I also don't understand why you would suggest using a separate textbox to perform this validation. That would give the user a confusing textbox with all the spaces converted to as.

This pattern should work:

[a-zA-Z]([ ]*[a-zA-Z])*

The pattern above will approve strings that meet all of the following criteria:

Contains one or more letters
Contains 0 or more spaces
Begins and ends with a letter
Contains no characters that are not letters or spaces

I know you didn't mention the third criterion, but I would imagine that's what you want. If you don't mind spaces at the beginning and end but still want to require at least one letter, you can use this pattern:

[ ]*[a-zA-Z][a-zA-Z ]*

Re: Specific data validation with text box

Qazi Anis — Thu, 07 Jan 2010 16:02:03 GMT

also one thing " " this is space not a blank

Re: Specific data validation with text box

Qazi Anis — Thu, 07 Jan 2010 16:00:20 GMT

hi,

well if you check properly,

i am setting value of second text box to value of first text box - spaces and alphas

i am validating second text box based on the validation of first text box.

give it a shot

Re: Specific data validation with text box

harasgalt — Thu, 07 Jan 2010 13:10:20 GMT

The pattern does not take into account spaces.

However the alpha words are fine but as soon as i put in trailing and leading spaces it generates a validation error.

Re: Specific data validation with text box

harasgalt — Thu, 07 Jan 2010 13:07:25 GMT

I tried your pattern without the second text box, it seems to work ?

I'll have to do further testing but thank you very much.