I'm looking to map a value that contains a specific string.
Example: I have a CSV column that contains the value "DWFs", ("Eagle Point DWFs", "West Lake DWFs). I'd like to map any value that contains the substring "DWFs".
Thank you in advance
Question
SchemaMapper and wildcards
+4Is it possible to use wildcards within the SchemaMapper: Mapping Table?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi,
I don't think it's possible to use a wildcard in the Schema Mapper setting, you will have to consider other ways.
Is "DWFs" the attribute name?
You need to map the source string values (e.g. "Eagle Point DWFs", "West Lake DWFs") to what kind of strings?
Takashi
+4I have a list of 95,000 full path file names that need to be copied to a new standardized folder structure and I plan to generate the Robocopy scripting using schemamapper
The string containing "DWFs" are folder names.
I'll be creating standardized OUTPUT folder names for any INCOMING folder containing the word "DWFs".
Thanks Takashi,
Have a good day!
I guess the StringReplacer is fit to your requirement.
How do you need to standardize the path strings?