Building a list of file names

(1) Share

Report

Posted on by ME-14102049-0

I need to build a list of file names by scanning through an existing folder of files. The folder of files contains file names like aaaa123_C0001_aaaaa.pdf and bbbbb_C0003_ccccc.pdf. I need to create a list that would look like C0001,C0003. Can Power Automate find the pattern that begins with "C" followed by 4 numerics and then write each of the occurrences to a new file.

Thanks, Mark

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

abc 123 789 Moderator on at

Like (1)

Report
Copy link

Link copied!

The IndexOf() function can find the "_C", then you can assume the next 4 chars.

From there, Left(), Right(), Mid(), Substring(), etc functions can help with string manipulation.

Was this reply helpful? Yes No
ME-14102049-0 43 on at

Like (1)

Report
Copy link

Link copied!

This seems about what I want to do but I'm working from files on a Windows server, Can this be modified to work in that environment?

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,960 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

So when you write, you should clarify 2 things always

1) what platform. this question is clearly for Desktop (imho), but you do not explain or state that. There is a specific Community forum for PAD :-)

2) share your flow and steps. Please write these as steps, not sentences and definitely not paragraphs.

Was this reply helpful? Yes No