InfoPath Dev

Solved it . . . substring-before(substring-after(Team_x002f_Team[ID =Team_x0020_Experience_x0020], "-  "), "-")

Looking for a way to grab everything between character . . .  Example data: ABCS -  Bulls-12/12/2012 I would like to return "Bulls" to a textbox.  Is there a way to use substring-before and substring-after in conjunction?  Thanks! Travis  

I created an action rule with the following: Condition - Lookup field dropdown (greater than 1) Action Set a Fields Value - Team = substring-before(string(Lookup dropdown field), string(" -  ")) But whenever I run this nothing actually populates in the Team field  Any thoughts? Thanks!

Hey everyone . . .  Looking for the equiv. of the left function with a find " - " in it  . . . any thoughts?  Thanks

Solved It ! . . . Rule: region/date/time field > 1 Action: Set Field - Team = substring-before(string(Region_x002f_Team), string(" - "))  Where region is the region/date/time title field not the ID field - I had a " - " in the string that i searched for

So, I will admit, I do not fully understand the capabilities of InfoPath, or the best way to achieve what I want.  All I know is, I have been struggling with this for a while now. So any help is greatly appreciated. Basically, I have a lookup field (dropdown named region/date/team).  What I want to do is when this look up field contains ...

Hey everybody, New to InfoPath (working on 2010), and I was suprised to find that there doesn't seem to be if logic functionality built into the tool.  I was looking for a little help, here are the details of my dilemma: I have a form that contains a dropdown (Team) for example purposes let's say the values are: a - I want this ...