General

Re: Function to take peice of text from merged text string ?

justinf10000 — Fri, 28 Aug 2015 21:05:31 GMT

Thanks again :)

Re: Function to take peice of text from merged text string ?

Reema Daga — Fri, 28 Aug 2015 20:53:38 GMT

Attaching the 2010 version.

Thanks

Reema

Re: Function to take peice of text from merged text string ?

justinf10000 — Fri, 28 Aug 2015 20:26:20 GMT

Hey Reema actually we use InfoPath 2010 here at my work so I'm unable to open the file. Could you post the code in notepad or show me a 2010 version? Thanks!!

Re: Function to take peice of text from merged text string ?

justinf10000 — Fri, 28 Aug 2015 19:12:01 GMT

Thank you !

Re: Function to take peice of text from merged text string ?

Reema Daga — Fri, 28 Aug 2015 18:59:20 GMT

Hi there,

I am attaching a sample form with a solution to your problem. Hope this helps!

Kind Regards,

Reema

Reema Daga
Qdabra® Software / InfoPathDev.com / FormsQuo / 425 999 4597 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Function to take peice of text from merged text string ?

justinf10000 — Thu, 13 Aug 2015 14:51:14 GMT

So basically this is how the form works.

I have a multi-selection list box populated from a list.

Whoever is picked from this list gets merged into another field with the function substring-after(eval(eval(Additional_Signoff, 'concat(., "; ")'), ".."), ";")

Everyone selected from this list will receive email notifications that they must sign off on the form.

I need them to be able to do this simultaneously. I'd rather not use an approval workflow and keep all the signing off within the form itself.

so that function above will return a value like us/423424; us/324234; us/23424; us23424 . It can vary anywhere from 1-15+ people.

I need a function that can pull the 1st ID from that string and stick it into Field1

I need a function that can pull the 2nd ID from that string and stick it into Field2

I need a function that can pull the 3rd ID from that string and stick it into Field3

etc.

I need them to be able to ONLY sign the field designated by their UserID and not the other fields.

Any ideas?