Rename File - Remove Characters

Like (0) Share

Report

Posted on 15 Apr 2024 20:06:51 by marksben32

Hello,

I have over 30 files I download daily into 1 folder that all have different names. I need to remove the last 13 characters on each file name, so from the dash to the end. I just don't know what to put in "text to remove". Everything I've tried gives me an error. Is this possible?

For this example I just need it to be ABCDE Test and FGHIJ Report.

Any help is greatly appreciated. Thanks in advance!

All responses (3)

Answers (2)

Verified answer

SriniK 3,025 Super User 2025 Season 1 on 16 Apr 2024 at 06:48:49

Like (0)

Report

Re: Rename File - Remove Characters

Hi @marksben32

If the above post resolves your issue, then click on ACCEPT AS SOLUTION , so that it will helpful to others

Cheers,

Srini
marksben32 22 on 15 Apr 2024 at 20:55:45

Like (0)

Report

Re: Rename File - Remove Characters

That worked! Thank you so much!
Verified answer

SriniK 3,025 Super User 2025 Season 1 on 15 Apr 2024 at 20:38:12

Like (1)

Report
Re: Rename File - Remove Characters

Hi @marksben32

Try as below

Folder.GetFiles Folder: $'''D:\\Test_String''' FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files3 LOOP FOREACH CurrentItem3 IN Files3 IF Contains(CurrentItem3, $'''-''', False) THEN Text.SplitText.SplitWithDelimiter Text: CurrentItem3 CustomDelimiter: $'''-''' IsRegEx: False Result=> TextList File.RenameFiles.Rename Files: CurrentItem3 NewName: TextList[0] KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles END END

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Cheers,

Srini