Newbie Questions

Re: Infopath Equivalent of left()

mjphelan — Thu, 11 Mar 2010 15:51:43 GMT

A perfect solution to an annoying little problem.. Many Thanks ;o)

Re: Infopath Equivalent of left()

Jimmy — Thu, 11 Mar 2010 14:22:19 GMT

The XPath equivalent of left(field, x) is substring(field, 1, x), and the XPath equivalent of a & b [ & c ...] is concat(a, b [, c...]), so the formula you're going for is something like:

concat(substring(firstfield, 1, 1), secondfield)

Infopath Equivalent of left()

mjphelan — Thu, 11 Mar 2010 11:19:09 GMT

I've spent a few hours searching the forums, and I have a feeling that while it seems very simple it's goign to be otherwise..

I'm looking for a simple Infopath equivalent of the VBA LEFT() function.

Simply put, I need to concatenate the fist character of one field and a second field in an automated manner.

In VBA the code would be

strvalue = left(firstfield,1) & secondfield

If at all possible I'd like to keep this as a "rule" or "Default Value" within the form if at all possible, to make it as easy as possible for others to update/change the form if need be,

Many Thanks

Mark P