Return
-
Title
Does 'Find and Replace' activity in automation accept wildcards? -
Description
Is there a Find/Replace feature in Automation to replace the same string in multiple files? If the filename is replaced with the path\*.sql, so it will run the find and replace on all the sql files in the directory, the following error occurs.
Could not create activity of type 'Automation.Workflow1'. System.ArgumentException: Illegal characters in path.at System.IO.Path.CheckInvalidPathChars(String path, Boolean checkAdditional)at System.Security.Permissions.FileIOPermission.CheckIllegalCharacters(String[] str)at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList)at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, String[] pathList, Boolean checkForDuplicates, Boolean needFullPath)at System.IO.Path.GetFullPath(String path)at Quest.Toad.Workflow.Activities.FindAndReplaceFileActivity.set_SourceFileName(String value)at Automation.Workflow1.InitializeComponent()at Automation.Workflow1..ctor()Are wildcards accepted in the Find/Replace feature?
-
Resolution
WORKAROUND
none
STATUS
This was originally an enhancement which was introduced in Toad Data Point 3.2, however errors now occur in version 3.4 and 3.5. Waiting for fix in a future release of Toad Data Point
-
Defect ID
QAT-2922