So here is my current set up thus far.

I plan on setting up a scheduled Task on our SharePoint server to run every minute and go out to a shared network drive to see if there are any new XML files (in email format”) and transfer them to a SharePoint library that has a workflow on new, that will create a new list item.

One of the fields in the XML (userName) file comes across as a text field in this format “LastnameFirstInital” eg: JohnD , we would like the workflow to translate that to the following format in th elist item “LastName FirstInitial” eg: John D; how can I make that happen?

Lastly, we have a Scanner gun that we want to be able to scan a barcode and it append data to the list, is there a tutorial to make a barcode scanner work within a SharePoint list/workflow/form?

Thank you in advance