Answered

Help Parse Text Action with file name?

(0) Share

Report

Posted on by derb

Hi I need to process all files in a folder. So I used the Get files action and I can see the files. And I found the "part" filename...

Now I want to take that file name and parse the text into three variables. This is an example of a file name 03-18-2021 Erb 15123.pdf. I need to parse three variables - Date which would = 03-18-2021 Last Name = Erb and Employee ID = 15123. Employee ID is always 5 char

What do I put in the fields of the action in order for it to work? Thank you I have no idea what a regular expression is! I will be sooo greatful.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

miketran13 720 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
I assumed that you can have space in the file name which separates the Date, Last name, Employee ID then you can use this solution. It is just using Split text with Space as delimiter then you can get a text list and there will be three elements in the text list for Date, Last name, Employee ID.

If your file name have no format or structure then this should not work and we need to find another way.

Thanks and hope it can help you.
Mike
---------------------------------
Did I answer your question? Please consider to Mark my post as a solution! to guide others

Was this reply helpful? Yes No
derb 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Mike! so what is the syntax for Set Variable ?
I've tried the brackets inside and outside of the varable... I am missing something thank you so much for speedy response!

Was this reply helpful? Yes No
derb 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Figured it out! Thank you again for getting me on the right track

Was this reply helpful? Yes No