Skip to main content
Question

SchemaMapper and wildcards


Forum|alt.badge.img+4
Is it possible to use wildcards within the SchemaMapper: Mapping Table?

 

 

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

3 replies

takashi
Evangelist
  • November 7, 2015
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

Forum|alt.badge.img+4
  • Author
  • November 7, 2015
I 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!

takashi
Evangelist
  • November 7, 2015
I guess the StringReplacer is fit to your requirement.

 

How do you need to standardize the path strings?

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings