74 View Renamer

From KiwiCodes-wiki
Jump to: navigation, search

Help

Welcome to this demonstration on Bonus Tools – 74 View Renamer. This tool allows you to name Views based on a set of criteria..

  1. To run the tool, navigate to the Bonus Tools Tab and select View Renamer.
  2. Sheet and View Manipulation

    74 View Renamer

  3. The View Renamer dialog will appear.
  4. 74 View Renamer

  5. From the Views section:
    • Select the View Type.

    74 View Renamer

    • Select a Search by Parameter (if you wish to search/filter Views).

    74 View Renamer

    • Enter a Search string.

    74 View Renamer

    • Select the views to Rename.

    74 View Renamer

  6. Choose to any combination of:
    • Rename Views.
    • Rename Views and Rename Title on Sheets.
    • Rename Title on Sheets.

    74 View Renamer

  7. Select a Case Option:
    • No Change.
    • UPPER CASE.
    • lower case.
    • Title Case.
    • Sentence case

    74 View Renamer

  8. Add/Remove rows to build up the new View name using the View Parameters.
  9. 74 View Renamer

  10. Select Text Field to enter manual text.
  11. 74 View Renamer

  12. Select Parameters you want to use in the new View Name like Associated Level.
  13. 74 View Renamer

  14. Building up the new View Name.
  15. 74 View Renamer

    Note: You can use Move Up and Move Down to reorder the selected Parameters.

  16. At the base of the Grid is an example of the new View name.
  17. 74 View Renamer

  18. You can also manipulate the Existing View name if selected by:
  19. 74 View Renamer

    1. Replacing the text ABC with new text DEF
    2. 40 Copy Parameter Values

    3. Cropping the left n Chars 1
    4. 40 Copy Parameter Values

    5. Cropping the right n Chars 1
    6. 40 Copy Parameter Values

    7. Crop at position 2 the next n chars 2
    8. 40 Copy Parameter Values

    9. Insert before Prefix
    10. 40 Copy Parameter Values

    11. Insert after Suffix
    12. 40 Copy Parameter Values

    13. Insert at position 5 the next text Middle
    14. 40 Copy Parameter Values

  20. Once selection are made, click Ok.
  21. 74 View Renamer

  22. You will be prompted with a confirmation of the number of Passes and Fails.
  23. 74 View Renamer

Thank you for viewing this demonstration on Bonus Tools - View Renamer.