cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

Delete files in a folder

vishwasanj
Level V

Hi All,

 

Is there a way to delte all .txt,.csv,.jrn and .png files in a folder before running a script to repopulate everything?

 

I do want to keep my. json file in the same folder.

 

Thank you so much. I really appreciate your time and effort.

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User


Re: Delete files in a folder

Oops, the word() functions reference should have been

If(word(-1,Y[i],".") == "txt"

negative values indicate to count from the right, positive values count from the left

Go to

     Help==>Scripting Index==Functions==>Character==>Word

for documentation and example

Jim

View solution in original post

3 REPLIES 3
txnelson
Super User


Re: Delete files in a folder

You can use

Y = Files In Directory( <Path"=> );

to get the files, and then loop through the list of files and determine if the file is of the type you want to delete, and then delete it 

If(word(=1,Y[i],".") == "txt",
    r= Delete File(<path> || Y[i]);
);
Jim
vishwasanj
Level V


Re: Delete files in a folder

Is there a way to count from the left as I have "." in the name also?
txnelson
Super User


Re: Delete files in a folder

Oops, the word() functions reference should have been

If(word(-1,Y[i],".") == "txt"

negative values indicate to count from the right, positive values count from the left

Go to

     Help==>Scripting Index==Functions==>Character==>Word

for documentation and example

Jim

Recommended Articles

No recommendations found