I have been tasked to extract the document name and store them in 4 separate columns in SharePoint. The new documents which are .PDF's are named as such : Sam; Smith; 123456; Dental
And the column names on the list after stripping the document name are like below.
*Employee number: 123456
So, I have created the document library list and added the above 4 columns to document library. From link 2 I understand that a workflow using MS Flow is a possible solution but the example they deal with has just one "-" and the documents i am dealing with has two ";". So i am really not sure how to come up with the sub-string expressions that they talk about.
Thank you for all your help and feedback.