locked
Removing spaces in InfoPath text field RRS feed

  • Question

  • Hi Eveyone,

    Is there a way to take text from an InfoPath field that contains spaces and remove spaces? For example if my users enter "my best project", I want to be able to change it to "mybestproject" and store this in a string in a SD built workflow.

    Thanks for any help!


    LMP
    Thursday, February 17, 2011 2:37 PM

Answers

  • You can use the translate function.  If Field1 is the field that contains "my best project" create a new field (Field2) that has this formula as the default value translate(Field1, " ", "").  be sure check the "Update this value..." checkbox on Field2.  Then promote Field2 so that it is visible to your workflow.

    Hope this helps

    Ed

    • Marked as answer by XRS_Master Thursday, February 17, 2011 2:54 PM
    Thursday, February 17, 2011 2:44 PM

All replies

  • You can use the translate function.  If Field1 is the field that contains "my best project" create a new field (Field2) that has this formula as the default value translate(Field1, " ", "").  be sure check the "Update this value..." checkbox on Field2.  Then promote Field2 so that it is visible to your workflow.

    Hope this helps

    Ed

    • Marked as answer by XRS_Master Thursday, February 17, 2011 2:54 PM
    Thursday, February 17, 2011 2:44 PM
  • Thanks Ed - Works perfectly!
    LMP
    Thursday, February 17, 2011 2:55 PM