We help IT Professionals succeed at work.
Get Started

How do I check for length of a field in InfoPath with respect to padding?

zintech
zintech asked
on
604 Views
Last Modified: 2012-05-09
In my database here at work, the columns I am attempting to check in InfoPath are padded in the database to the maximum length of the field, which is 30 characters.  Any entry under 30 characters in the field will be padded with enough spaces to have the field length equal 30.  My question is how would I go about adding these extra spaces when checking for equality in InfoPath?  I am checking the entry in a textfield that the user enters in InfoPath against the entry in the database, therefore the entry that the user enters into the textfield in InfoPath needs to be 30 characters long, with spaces filling in any field length shorter than 30 characters.  I have already tried using the trim(), Rtrim() and Ltrim() functions when bringing the data in from tbhe data source, but this does not work.
Comment
Watch Question
Director of Business Integration
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE