InfoPath Dev

Hi Hilary. I have Qrules already FYI. I really just need validation. I have tried regex but cant seem to get it 100 percent correct. So the possible values are as follows: 1-48 example: 1,2,3-10,15-20 the same is valid if you do it this way 1,2,3,4,5,6,7,8,9,10,15,16,17,18,19,20 and 1/1-48 2/1-48 3/1-48 and 4/1-48 a comma is a ...

I have a field that will have values separated by a comma. i.e 1/1,2/2,3/3 I need to be able to take each of these values and place them in a repeating table so that i can run validation on each of them. A

that + is throwing it off.....scrap everything...... make the set a fields value : concat(substring(translate(., "()-. ", ""), 1, 2), "(", substring(translate(., "()-. ", ""), 3, 3), ") ", substring(translate(., "()-. ", ""), 5, 3), "-", ...

also change the phone number pattern to a custom pattern: \+\d\(\d\d\d\) \d\d\d\-\d\d\d\d

concat(substring(translate(., "()-. ", ""), 1, 2), "(", substring(translate(., "()-. ", ""), 3, 3), ") ", substring(translate(., "()-. ", ""), 6, 3), "-", substring(translate(., "()-. ", ""), 9, 4))

do it like this....

should look like this.... see attached

That didnt come out too user friendly not sure why. I spaced everything out but it all came together when i submitted it. private message me your contact info if you dont get it..

on the field you want to format put a rule: conditions: "Field you are formatting" does not match pattern "Phone Number Pattern" AND The expression "string-length(translate(., "()-. 0123456789", "")) = 0" AND Then run these actions: Set a fields value: The field you want ...

Yes I just got your message. I have your solution. Give me a few to get it out to you.. :)