wpaj1025
02-08-2017, 11:24 AM
Hello,
My goal is to get a final array (list) that is based-on the contents of a description field that is not consistent:
1. Provided file
SKU
Description
4876
1Y Depot + ADP Post Warranty
7598
1Y Depot +SBTY Post Warranty
6247
1Y Onsite + KYD PW (CPN Federate)
3018
PROTECTION 1YR OS 24x7x4 + KYD (RS)
5716
PROTECTION 3Y Onsite + ADP TSS
5723
2Mo Onsite + Priority Support
7270
PROTECTION 3Y Depot + ADP TSS
2. Goal
Extract information from the description field to populate the below table. If the text is not in the description then the field would be blank.
What I have done so far is to Filter the list alphabetically, then create formulas using Left, Mid and Right.
However, due to the size of the file this is time consuming (over 1k rows).
Desired outcome:
SKU
Description
Term (all)
Term Months
Location
Response Time
ADP
KYD
SBTY
4876
1Y Depot + ADP Post Warranty
1y
12
ADP
7598
1Y Depot +SBTY Post Warranty
1y
12
SBTY
6247
1Y Onsite + KYD PW (CPN Federate)
1y
12
KYD
3018
PROTECTION 1YR OS 24x7x4 + KYD (RS)
1y
12
Onsite
24x7x4
KYD
5716
PROTECTION 3Y Onsite + ADP TSS
3y
36
Onsite
ADP
5723
2Mo Onsite + Priority Support
2m
2
Onsite
7270
PROTECTION 3Y Depot + ADP TSS
3y
36
Depot
ADP
My goal is to get a final array (list) that is based-on the contents of a description field that is not consistent:
1. Provided file
SKU
Description
4876
1Y Depot + ADP Post Warranty
7598
1Y Depot +SBTY Post Warranty
6247
1Y Onsite + KYD PW (CPN Federate)
3018
PROTECTION 1YR OS 24x7x4 + KYD (RS)
5716
PROTECTION 3Y Onsite + ADP TSS
5723
2Mo Onsite + Priority Support
7270
PROTECTION 3Y Depot + ADP TSS
2. Goal
Extract information from the description field to populate the below table. If the text is not in the description then the field would be blank.
What I have done so far is to Filter the list alphabetically, then create formulas using Left, Mid and Right.
However, due to the size of the file this is time consuming (over 1k rows).
Desired outcome:
SKU
Description
Term (all)
Term Months
Location
Response Time
ADP
KYD
SBTY
4876
1Y Depot + ADP Post Warranty
1y
12
ADP
7598
1Y Depot +SBTY Post Warranty
1y
12
SBTY
6247
1Y Onsite + KYD PW (CPN Federate)
1y
12
KYD
3018
PROTECTION 1YR OS 24x7x4 + KYD (RS)
1y
12
Onsite
24x7x4
KYD
5716
PROTECTION 3Y Onsite + ADP TSS
3y
36
Onsite
ADP
5723
2Mo Onsite + Priority Support
2m
2
Onsite
7270
PROTECTION 3Y Depot + ADP TSS
3y
36
Depot
ADP