Get first letter of a field - InfoPath Dev
in

InfoPath Dev

Get first letter of a field

Last post 09-11-2006 08:06 AM by bslaght. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 09-01-2006 09:04 AM

    Get first letter of a field

    I have a form that should construct the email address in a text box using an expression.

    bascially in my expression box I have:

    concat(FirstName,LastName,"@mydomaim.com")

    However what I really want is to only get the first letter of the first name as our email addresses look like this: [email protected]

    How would I acomplish this?
  • 09-01-2006 10:13 AM In reply to

    Re: Get first letter of a field

    Hey,

    You can use the substring function to parse the first letter....something like concat(substring(Firstname,1,1),LastName,"@mydomain.com")

    The syntax may not be 100% correct.

    MB
  • 09-11-2006 08:06 AM In reply to

    Re: Get first letter of a field

    Perfect! It worked great!
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.