Today we’ll see how we can move files that contain a particular word, a specific directory/subdirectories, recursively. Sometimes we may need to move files that meet a certain pattern to a particular folder.

For example, imagine that we have a directory/subdirectories with thousands of audio files, with metadata in the filename and we want to make an automatic selection of all the audio files that contain the word SALES in the name tag. We could go directory to directory looking for the word SALES and cutting and pasting in a folder or we could use the Windows search and give us the results, but sure that the following command can be more than useful.

Copy this code, save it in a bat file and run it. It will automatically dump all mp3 audio files containing the word SALES in the C:\SALES_AUDIO\ folder.

From here we can apply this small code to any example you can think of.

I hope it will help you;)


MicroStrategy allows us to link documents to other documents/reports and create a navigation between them. Depending on our needs, the default way of Microstrategy to make links couldn´t be enough for our purposes, for this reason I will talk about API URL, which allow us to create custom links to other reports, documents, pages, exports … from objects such as text labels or images:

Continue reading