Question

SchemaMapper and wildcards

  • 6 November 2015
  • 3 replies
  • 5 views
B
Badge +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
Rank
Userlevel 2
Badge +17
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
B
Badge +4
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
Rank
Userlevel 2
Badge +17
I guess the StringReplacer is fit to your requirement.

 

How do you need to standardize the path strings?

Reply


Community Stats

28,670
Posts
109,364
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.