Coding in Apps script and or Google Sheets I have a cell containing the following text: [cid:ec8e3a5e86c372d25aeb9ca2454
Posted: Thu Jul 14, 2022 2:12 pm
Coding in Apps script and or Google Sheets
I have a cell containing the following text:
[cid:ec8e3a5e86c372d25aeb9ca24540:
sales 30 days: 144
sales 60 days: 205upgrade
ON BACKORDER - DISPATCHED/COLLECTION IN: 20-25 BUSINESS DAYS
ON BACKORDER - DISPATCHED/COLLECTION IN: 7-10 BUSINESS DAYS
ON BACKORDER - DISPATCHED/COLLECTION IN: 2-3 BUSINESS DAYS
I need to extract the largest value between the words IN: andBUSINESS DAYS.
Please note that in the cell there are tones of characters andnumbers.
For example between "in:" and "BUSINESS DAYS" you get thefollowing values: {20-25; 7-10; 2-3}.
Once you have those values split it by the "-" {20; 25; 7; 10;2; 3}
The output should only be the largest value {25}
I have a cell containing the following text:
[cid:ec8e3a5e86c372d25aeb9ca24540:
sales 30 days: 144
sales 60 days: 205upgrade
ON BACKORDER - DISPATCHED/COLLECTION IN: 20-25 BUSINESS DAYS
ON BACKORDER - DISPATCHED/COLLECTION IN: 7-10 BUSINESS DAYS
ON BACKORDER - DISPATCHED/COLLECTION IN: 2-3 BUSINESS DAYS
I need to extract the largest value between the words IN: andBUSINESS DAYS.
Please note that in the cell there are tones of characters andnumbers.
For example between "in:" and "BUSINESS DAYS" you get thefollowing values: {20-25; 7-10; 2-3}.
Once you have those values split it by the "-" {20; 25; 7; 10;2; 3}
The output should only be the largest value {25}