General

Re: Is it possible to retain spaces at the beginning of a field?

Samuel Hagaman — Wed, 18 Nov 2009 15:42:09 GMT

You are correct! The spaces are there even though they aren't displayed in the field's text box. When i finally tracked it down the problem with the web service actually had to do with a security logon issue to the SQL database.

Thanks for the help! :)

Re: Is it possible to retain spaces at the beginning of a field?

Jimmy — Tue, 17 Nov 2009 15:04:40 GMT

Are you sure that the space is actually being removed? If I type a value with spaces at the beginning in an InfoPath field and submit it to a web service, the spaces at the beginning of the value disappear in the form's text box, but they are still transmitted to the web service.

If you have verified that the spaces actually are being stripped away, you could try using a rule in the form to append spaces at the beginning [concat(' ', /my:myFields/my:field), or something like that. This would probably be a good practice anyway, as it doesn't require the user to enter the space into the form manually.

Is it possible to retain spaces at the beginning of a field?

Samuel Hagaman — Tue, 17 Nov 2009 13:47:21 GMT

Does anyone know if it's possible to retain spaces at the beginning of a field? I am trying to submit a field to a web service as a parameter but the field needs to be in the format of a space followed by a two digit number (i.e. - " 41"). This is necessary because that's the way the data is stored in the SQL database and if at all possible I don't want to write a web service that concats a space and the two digits and then submits that as the parameter. In InfoPath if I set a field to " 41" the space is automatically removed and I am left with only "41". I know that in Excel you are able to keep the spaces in a cell by formatting the cell as text or entering an apostrophe in front of the string but this doesn't seem to work in InfoPath.

Thanks in advance for any help,

Sam