InfoPath Dev

Hi, My InfoPath SharePoint list has a file attachment and I am able to display the attachment URL in a separate text field after a file attached. I wonder if there is a way to use a concat (substring-before(My URL), substring-after (My URL)) to get a file name of the attachment to be displayed in the text field, is it possible? Any suggestion is greatly appreciated!

 Thank you so much for your help!  

 I'm guessing this is related to your other post - what does the URL look like? This must be a SharePoint list form, right? So the URL will have the item's list ID prior to the name? What's a sample URL?

 Hi Hilary,

 Sorry, other post is slightly different because I realized that the InfoPath form for other post is using the Document Library, which somehow it does not appear the attachment URL as same as the list. Therefore, I was only able to display the attachment URL on the text field for the InfoPath SharePoint list, not the document library and I would like to use a substring for URL (Ex: https://eddnet/sites/TestSite/Lists/TestRequiredFields/Attachments/7/Test Doc5.docx) to get the only file name as Test Doc5.docx. is it possible? thanks so much for your help!

I think you could use substring-after(substring-after(URL Field Here, "https://eddnet/sites/TestSite/Lists/TestRequiredFields/Attachments/"), "/")

 Thank you for your quick response. Let me try it out. Thanks, :)

 By the way, is it possible to get the same solution for the InfoPath document library as it does not appear the attachment URL like the list? How can I make it work? Any suggestion is greatly appreciated.  

 Hi Hilary,

 I just tried to do in the following steps:

Click on Text Box properties and click on "Fx" function > insert function: substring-after(substring-after("Link"), "/")

Prior to "https" you need to select your field that has the attachment URL and add a comma. You'll see in my sample I had placeholder text for that.

Thank you for your quick response, Hilary. The function works now without errors. However, when I use the function "Fx" for a text field, it only shows the file name of the attachment after submission. But I would like to the file name shows right away on the text field after a file attached, is it possible? if yes, how do I make it work? Any suggestion is greatly appreciated. Thanks again, :)

This isn't possible, for the same reason as your other question, except in this case, code isn't an option because we can't add code to list forms. FormsViewer can do this - both for list and library forms, so if this is a feature you need, you may want to check it out. :)

Thank you so much for your great suggestion, Hilary. I appreciated it. You're the best. :-)

Have a great evening!

Best Regards,