Extract and Concat

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bryan Hughes - 01 Sep 2004 00:50 GMT

Hello,

How do I get the first letter in Field1, concat it with Field2 then put that
into field3?

-TFTH
Bryan

Reply to this Message

Andrew Ma [MSFT] - 01 Sep 2004 05:43 GMT

For Field3, create a function which has this Xpath:

concat(substring(field1, 1, 1), field2)

Signature

Andrew J. Ma
Software Test Engineer
Microsoft Office InfoPath
http://blogs.msdn.com/ajma
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias if for
newsgroup purposes only.

> Hello,
>
[quoted text clipped - 3 lines]
> -TFTH
> Bryan

Reply to this Message

Matthew Blain \(Serriform\) - 01 Sep 2004 06:44 GMT

To enter a function, right-click on field 3, then click the f(x) button to
the right of default value.

--Matthew Blain
http://tips.serriform.com/

> For Field3, create a function which has this Xpath:
>
[quoted text clipped - 7 lines]
> > -TFTH
> > Bryan

Reply to this Message

Bryan Hughes - 01 Sep 2004 19:09 GMT

Mathew and Andrew,

I have used a rule a created this concat(substring(field1, 1, 1), field2)
usung the function button, but it is not working.
I have not tried using XPath. I will give that a try.

-TFTH
Bryan

"Matthew Blain (Serriform)" <matthewblain@nospam.serriform.com> wrote in
message news:unf%23gc%23jEHA.2764@TK2MSFTNGP11.phx.gbl...

> To enter a function, right-click on field 3, then click the f(x) button to
> the right of default value.
[quoted text clipped - 19 lines]
>> > -TFTH
>> > Bryan

Reply to this Message