File Delete Operations

Azure Data Expert provides advanced file delete operations allowing one to delete data blobs from one or more Microsoft Azure cloud storage accounts. In order to perform a simple delete operation, select one or more storage containers, directories or data blobs in the storage navigator view, press the 'Delete' button located on the main toolbar and press the 'Delete' button.

Azure Data Expert Delete Files

In addition, advanced users are provided with the ability to control the number of parallel delete threads, the performance mode of the delete operation, the network connect timeout and the network data transfer timeout. Azure Data Expert allows one to specify one or more subdirectories to be excluded from the delete process. In order to configure one or more exclude directories, open the advanced delete options dialog and select the 'Exclude' tab.

Azure Data Expert Delete Options

Finally, the user is provided with the ability to delete specific types of files or groups of files selected using one or more file matching rules. For example, the user can delete all types of images that where modified more than 6 months ago and exclude all other files from the delete process. The product provides a large number of different types of positive and negative file matching rules allowing one to precisely select which files to delete and which files to exclude from the delete process. In order to configure one or more file matching rules, open the advanced delete options dialog and select the 'Rules' tab.

Deleting Specific Types of Files

Azure DEX Pro provides the ability to delete specific types of files or groups of files by the file type, category, size, name, extension, last modification date, etc. The user is provided with the ability to configure a number of file matching rules for each file delete operation allowing one to delete the required files and precisely focus on the required data. For example, the user can delete all types of images with the file size more that 10 MB that were modified during the last month.

Azure Data Expert File Delete Rules

In order to configure one or more file matching rules for a file delete operation, open the file delete command dialog, press the 'Options' button, select the 'Rules' tab, press the 'Add' button and select the required rule type. During the file delete process, Azure Data Expert will evaluate the existing files using the specified file matching rules. Files matching the specified rules will be deleted and files not matching the specified rules will be excluded from the file delete process.

Azure Data Expert Negative File Matching Rules

In addition to positive file matching rules allowing one to include specific files in the file delete process, Azure Data Expert provides negative file matching rules allowing one to exclude specific files from the file delete process. For example, in order to exclude all types of images from the file delete process, add a file category rule, select the 'Images, Pictures and Graphic Files' file category and select the 'Not Categorized' rule operator. During the file delete process, Azure Data Expert will evaluate the processed files and skip all types of image files.

Excluding Directories From the File Delete Process

Sometimes, it may be required to exclude one or more subdirectories from the file delete process. For example, if you need to delete files from a storage container excluding one or two special directories, you may specify the entire storage container to be deleted and add the directories that should be skipped to the exclude list.

Azure Data Expert File Delete Exclude Directories

In order to add one or more directories to the exclude list, open the file delete command dialog, press the 'Options' button, select the 'Exclude' tab and press the 'Add' button. All files and subdirectories located in the specified exclude directory will be excluded from the file delete process. In addition, advanced users are provided with a number of exclude directories macro commands allowing one to exclude multiple directories using a single macro command.

Azure Data Expert provides the following exclude directories macro commands:

  • $BEGINS <Text String> - this macro command excludes all directories beginning with the specified text string.
  • $CONTAINS <Text String> - this macro command excludes all directories containing the specified text string.
  • $ENDS <Text String> - this macro command excludes directories ending with the specified text string.
  • $REGEX <Regular Expression> - this macro command excludes all directories matching the specified regular expression.

For example, the exclude macro command '$CONTAINS Temporary Files' will exclude all directories with 'Temporary Files' at any place in the full directory path and the exclude macro command '$REGEX \.(TMP|TEMP)$' will exclude all directories ending with '.TMP' or '.TEMP'.