Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The values are not all the same but some are way to long and I would like to split those values are drop the part I do not want.
For Example:
Shipping Code
ShippingDelivery_3rdDay
ShippingDelivery_2ndDay
ShippingDelivery_1stDay
Standard
Returns Gound
Worldwide
Phone_Request
Next Day Air Commercial
Next Day Air Residential
Next Day Air Early
Above I would want to take out "ShippingDelivery" and "Next Day Air" and keep all other values alone. Is this possible?
May be like this:
MappingTable:
Mapping
LOAD * Inline [
Field1, Field2
ShippingDelivery_, ""
Next Day Air, ""
];
Table:
LOAD [Shipping Code],
Trim(MapSubString('MappingTable', [Shipping Code])) as [Shipping Code New];
LOAD * Inline [
Shipping Code
ShippingDelivery_3rdDay
ShippingDelivery_2ndDay
ShippingDelivery_1stDay
Standard
Returns Gound
Worldwide
Phone_Request
Next Day Air Commercial
Next Day Air Residential
Next Day Air Early
];
May be like this:
MappingTable:
Mapping
LOAD * Inline [
Field1, Field2
ShippingDelivery_, ""
Next Day Air, ""
];
Table:
LOAD [Shipping Code],
Trim(MapSubString('MappingTable', [Shipping Code])) as [Shipping Code New];
LOAD * Inline [
Shipping Code
ShippingDelivery_3rdDay
ShippingDelivery_2ndDay
ShippingDelivery_1stDay
Standard
Returns Gound
Worldwide
Phone_Request
Next Day Air Commercial
Next Day Air Residential
Next Day Air Early
];
Thanks so much!