InfoPath Dev

What are the options for extracing repeating section data out of a Microsoft SharePoint Form Library and then displaying that line item data neatly (exportable to Access/Excel) for analysis?

Final formula for combining concat and substring was concat(substring(@PATIENT_LAST_NAME, 1, 1), @Last_4_of_Patient_SSN) This allowed me to choose the first letter of the patient's last name and the last 4 of patient's SSN.   "@Last_4_of_Patient_SSN" is a data field.  In other words, I did not have to use a ...

I want to create a formula that will take the first letter of the patient last Name field and merge it with the patient’s last 4. Can anyone help with this? I'm trying to do something similar to this post http://www.infopathdev.com/forums/p/21539/97116.aspx#97116. This is the formula I am using: ...

I'm trying to do something similar.  I would like to get the result of First Initial of Last name combined with a seperate field of last 4.  This is the fomula I am using:  concat(substring(@PATIENT_LAST_NAME), 1, 1) @Last_4_of_Patient_SSN  This is the error I receive: Expected value type: end-of-string Actual value: ...