Removing the leading spaces/newlines added by the Multi-Select box - InfoPath Dev
in

InfoPath Dev

Removing the leading spaces/newlines added by the Multi-Select box

Last post 08-15-2011 05:36 PM by Patrick Halstead. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-15-2011 01:41 PM

    • wett68
    • Not Ranked
    • Joined on 08-03-2011
    • Posts 8

    Removing the leading spaces/newlines added by the Multi-Select box

    I have a multi-select box with 15-20 values in it corresponding to SharePoint users. The problem I'm having is that for every entry in the Multi-Select box that is not chosen, a new line or blank line placeholder gets placed in the output. So when I'm pulling this stuff into SSRS, I'm getting a bunch of empty lines and Trim, LTrim, RTrim aren't working. Tried replacing VBCRLF with "", and a bunch of other stuff with no luck. Here is what the output looks like: http://i.imgur.com/DUZvM.png
  • 08-15-2011 05:36 PM In reply to

    Re: Removing the leading spaces/newlines added by the Multi-Select box

    Probably, the easiest fix is to just not use a multi-select box. Use a repeating table that looks like one and use eval-eval with concat to create a nice string.

    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.