Answered

Remove last 13 characters from file name

(0) Share

Report

Posted on by KAM

Hi Everyone,

I am very new to Power automate and I am trying to build a flow to get files in a folder and rename them as they all have 13 characters at the end that I need to get rid of

I just need them to say Daily_Sales_-_Bath_2024-05-29 and Daily_Sales_-_Bath_2024-05-30

I need to get rid of the_06_00_00_065 bit and _06-00-00-049 bit in this instance but I have another 27 of them every day with different numbers at the end. A detailed flow would be much appreciated as I am still learning.

Thank you.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (12)

Answers (1)

Sort by

CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@KAM

You have the option to utilize the "Get Subtext" action, specifying the desired number of characters you wish to keep. This action will remove any excess characters beyond that specified length.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
KAM 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Deenuji, thank you for your swift reply, the only thing is that the file name varies i.e. instead of Bath within the name it could say Australia therefore the number of characters at the beginning is not always going to be the same?

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@KAM

So you are saying instead of "Bath" each file name contains any country names or only Australia?

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@KAM

Let's go with regex for your use case:

Regex used: ^(.*?)_\d{4}-\d{2}-\d{2}

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
KAM 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Deenuji. sorry if i did not explain it correctly these are are couple of the other files in the same folder

Would that work on what your last reply was? Once again thanks for helping out.

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@KAM

It should work please check and let me know in case of any issues

Was this reply helpful? Yes No
KAM 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Deenuji

Sorry this is all very new to me, is this correct or am I missing steps

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@KAM

Please follow the below approach:

Code(follow the below gif how to copy/paste the below code into your power automate desktop):
Folder.GetFiles Folder: $'''C:\\Deenu\\Json\\csv''' FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files LOOP FOREACH CurrentItem IN Files Text.ParseText.RegexParseForFirstOccurrence Text: CurrentItem.Name TextToFind: $'''^(.*?)_\\d{4}-\\d{2}-\\d{2}''' StartingPosition: 0 IgnoreCase: True OccurrencePosition=> Position Match=> Match Display.ShowMessageDialog.ShowMessage Title: $'''Info''' Message: Match Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed END

How to copy/paste the above code into your power automate desktop:

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
KAM 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi
I followed the steps above and they all come up with the correct file name but when I go into the folder where they are stored the names have not changed, could you tell me what I need to do now.

Was this reply helpful? Yes No
Verified answer

CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@KAM
You can add "rename file(s)" action next to parse text and configure like below:

Now full flow looks like this:

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No