Validate and correct erroneous folder paths values used by createfolders.py and applyfolderauthorization.py before their processing

[tomstarr]

Hi Gerry,

When you can, could you develop a couple of enhancements for applyfolderauthorization.py and createfolders.py please? It seems that the presence of trailing slashes, spaces and/or hidden chars on the end of folder paths all cause issues when creating folders or applying permissions using the Viya CLI. These enhancements would mitigate those 'gotchas' by regulating the quality of the input data.

Enhancements:

1. createfolders.py
   Scan folder paths being fed in and strip off any surplus spaces and hidden characters between the final char of each folder path and the comma separator.

2. applyfolderauthorization.py
   Scan folder paths being fed in and strip off any surplus spaces and hidden characters between the final char of each folder path and the comma separator.
   Scan folder paths being fed in and strip off any trailing slashes (the same enhancement that was previously implemented in createfolders.py fails to create folders with a trailing slash #179 to createfolders.py)

Many thanks.

[tomstarr]

Update:
Since raising this issue, any CSV's extracted from the ViyaAuthModel project should never need have any issues with the folderpath's again, as a error catching has been pushed to that project.

The enhancement requested above is now simply required by anyone using the createfolders/applyfolderauthorization scripts with CSV files sourced from elsewhere.

[gerrynelson63]

@tomstarr we will definitely do this. Thanks for raising it.