List Consolidation

 

SCENARIO

A web producer has collected about 100 tag lists from different post pages, which contain a total of 500 to 600 tag phrases. He needs to consolidate all tags’ phrases into one list, with repeated tags removed and the remaining unique tags sorted. The task will certainly be time consuming, tedious, and error-prone if he were to do it manually.

 

SOLUTION

Use a WorkWaltz custom automation tool to get all lists consolidated, with repeated tags removed, the remaining tags sorted, and the final list outputted to a text file and the clipboard, in 1 second.

E-Book Editing

 

SCENARIO

An ebook editor-in-chief is working on a foreign language masterpiece with 120 long chapters. In the .xhtml files he received from a content vendor, his editorial staff has identified 3,000+ distinguished global errors ranging from single corrupted characters and incorrect formatting codes to incorrect text of all sorts and all lengths. The editorial staff has worked out a correction for each error, and has listed these 3,000+ error-correction text pairs in a spreadsheet. The task now is to implement these corrections globally, which means performing a global find-replace action for each of the 3,000+ errors in all 120 chapters, or to repeat the find-replace operation a total of 360,000+ times. Assuming a speed of 30 seconds per action using the text editor’s built-in find and replace-all feature, it will take 3,000+ work hours, or more than a year and four months for one person, to implement all corrections by manual operation.

 

SOLUTION

Use a WorkWaltz custom automation tool to complete the global find-replace operations for all 3,000+ errors, in all 120 .xhtml files, in less than an hour.

UI Key Isolation

 

SCENARIO

A web application UI producer has a spreadsheet of 20,000+ keys and values. He needs to update the values of the keys with a name containing a specific string. Using the search feature of the spreadsheet application to find each of these keys and update them one by one in their original place in the spreadsheet is obviously too time consuming; besides, keys with different names may have identical values, and updating these keys separately may result in inconsistency. The best way, therefore, will be to isolate the object keys from the rest, then sort them so that keys with identical values are clustered together. However, the spreadsheet application doesn’t have a convenient feature for this purpose, and doing it manually will take many hours.

 

SOLUTION

Use a WorkWaltz custom automation tool to work on a copy of the file to remove all keys with names that do not contain the tag string, then sort the keys as desired, in a total of one minute.