I have a field with values that I would like to split up. However, not all the values are the same. Only some of them I want to split up then drop the first part of the value.

[neena123]

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?

[sunny_talwar · Accepted solution]

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

];

[neena123]

Thanks so much!