InfoPath Dev

hi Folks,  We have a rather complex and usiness essential form that needs to be migrated from MOSS 2007 to SharePoint 2010. The form is designed to use the GetUserProfileByName (thanks Clayton, your Blog was a godsend)  to retrieve various details for the logged in user and his or her manager. edit: For internal reasons we do not ...

 A perfect solution to an annoying little problem.. Many Thanks ;o)

I've spent a few hours searching the forums, and I have a feeling that while it seems very simple it's goign to be  otherwise.. I'm looking for a simple Infopath equivalent of the VBA LEFT() function. Simply put, I need to concatenate the fist character of one field and a second field in an automated manner. In VBA the code ...