Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF(
- OR({Package Quantity} > 0, {NUMBER OF Items} > 0),
- MAX({Package Quantity}, {NUMBER OF Items}),
- IF(
- OR(
- REGEX_MATCH({Amazon Title}, "(?i)\\b(\\d{1,2})[ -]?pack\\b"),
- REGEX_MATCH({Amazon Title}, "(?i)\\b(\\d{1,2})[ -]?pk\\b"),
- REGEX_MATCH({Amazon Title}, "(?i)pack of (\\d{1,2})\\b"),
- REGEX_MATCH({Amazon Title}, "(?i)packs of (\\d{1,2})\\b"),
- REGEX_MATCH({Amazon Title}, "(?i)multi[-]?pack of (\\d{1,2})\\b"),
- REGEX_MATCH({Amazon Title}, "(?i)case of (\\d{1,2})\\b"),
- AND(
- REGEX_MATCH({Amazon Title}, "(?i)(\\d{1,2}) piece[s]?\\b"),
- NOT(REGEX_MATCH({Amazon Title}, "(?i)\\bset\\b"))
- ),
- REGEX_MATCH({Amazon Title}, "\\((\\d{1,2})\\)"),
- REGEX_MATCH({Amazon Title}, "(?i)\\b(\\d{1,2})ct\\b"),
- REGEX_MATCH({Amazon Title}, "(?i)(\\d{1,2}) ?[xX] ?packs?\\b"),
- REGEX_MATCH({Amazon Title}, "(?i)x (\\d{1,2}) packs?\\b"),
- REGEX_MATCH({Amazon Title}, "(?i)total[-]?(\\d{1,2})[-]?packs?\\b")
- ),
- VALUE(
- IF(
- REGEX_MATCH({Amazon Title}, "(?i)\\b(\\d{1,2})[ -]?pack\\b"),
- REGEX_EXTRACT({Amazon Title}, "(?i)\\b(\\d{1,2})[ -]?pack\\b"),
- IF(
- REGEX_MATCH({Amazon Title}, "(?i)\\b(\\d{1,2})[ -]?pk\\b"),
- REGEX_EXTRACT({Amazon Title}, "(?i)\\b(\\d{1,2})[ -]?pk\\b"),
- IF(
- REGEX_MATCH({Amazon Title}, "(?i)pack of (\\d{1,2})\\b"),
- REGEX_EXTRACT({Amazon Title}, "(?i)pack of (\\d{1,2})\\b"),
- IF(
- REGEX_MATCH({Amazon Title}, "(?i)packs of (\\d{1,2})\\b"),
- REGEX_EXTRACT({Amazon Title}, "(?i)packs of (\\d{1,2})\\b"),
- IF(
- REGEX_MATCH({Amazon Title}, "(?i)multi[-]?pack of (\\d{1,2})\\b"),
- REGEX_EXTRACT({Amazon Title}, "(?i)multi[-]?pack of (\\d{1,2})\\b"),
- IF(
- REGEX_MATCH({Amazon Title}, "(?i)case of (\\d{1,2})\\b"),
- REGEX_EXTRACT({Amazon Title}, "(?i)case of (\\d{1,2})\\b"),
- IF(
- AND(
- REGEX_MATCH({Amazon Title}, "(?i)(\\d{1,2}) piece[s]?\\b"),
- NOT(REGEX_MATCH({Amazon Title}, "(?i)\\bset\\b"))
- ),
- REGEX_EXTRACT({Amazon Title}, "(?i)(\\d{1,2}) piece[s]?\\b"),
- IF(
- REGEX_MATCH({Amazon Title}, "\\((\\d{1,2})\\)"),
- REGEX_EXTRACT({Amazon Title}, "\\((\\d{1,2})\\)"),
- IF(
- REGEX_MATCH({Amazon Title}, "(?i)\\b(\\d{1,2})ct\\b"),
- IF(
- VALUE(REGEX_EXTRACT({Amazon Title}, "(?i)\\b(\\d{1,2})ct\\b")) > 20,
- "1",
- REGEX_EXTRACT({Amazon Title}, "(?i)\\b(\\d{1,2})ct\\b")
- ),
- IF(
- REGEX_MATCH({Amazon Title}, "(?i)(\\d{1,2}) ?[xX] ?packs?\\b"),
- REGEX_EXTRACT({Amazon Title}, "(?i)(\\d{1,2}) ?[xX] ?packs?\\b"),
- IF(
- REGEX_MATCH({Amazon Title}, "(?i)x (\\d{1,2}) packs?\\b"),
- REGEX_EXTRACT({Amazon Title}, "(?i)x (\\d{1,2}) packs?\\b"),
- IF(
- REGEX_MATCH({Amazon Title}, "(?i)total[-]?(\\d{1,2})[-]?packs?\\b"),
- REGEX_EXTRACT({Amazon Title}, "(?i)total[-]?(\\d{1,2})[-]?packs?\\b"),
- "1"
- )
- )
- )
- )
- )
- )
- )
- )
- )
- )
- )
- )
- ),
- 1
- )
- )
Advertisement
Advertisement