Skip to main content
  • EN
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
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
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!
I guess the StringReplacer is fit to your requirement.

 

How do you need to standardize the path strings?

Reply


Community Stats

30,108
Posts
114,295
Replies
37,745
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.