Is there a query I can do that will select all the records that start the same?
Example:
Chef Works Baseball Cap Blue
Chef Works Baseball Cap Red
Chef Works Baseball Cap Yellow
Whites Baseball Cap Blue
Whites Baseball Cap Red
Whites Baseball Cap Yellow
Fruit of the loom T-shirt Blue
Fruit of the loom T-shirt Red
Fruit of the loom T-shirt Yellow
Spare Buttons White
So I want a query that would return all the records where the 1st 21 characters match other records in the column, giving me:
Chef Works Baseball Cap Blue
Chef Works Baseball Cap Red
Chef Works Baseball Cap Yellow
Fruit of the loom T-shirt Blue
Fruit of the loom T-shirt Red
Fruit of the loom T-shirt Yellow
I would also like it to create new field that would take the common characters and put these into a new column with dashes instead of spaces. Like this:
Chef Works Baseball Cap Blue │ Chef-Works-Baseball-Cap
Chef Works Baseball Cap Red │ Chef-Works-Baseball-Cap
Chef Works Baseball Cap Yellow │ Chef-Works-Baseball-Cap
Fruit of the loom T-shirt Blue │ Fruit-of-the-loom-T-shirt
Fruit of the loom T-shirt Red │ Fruit-of-the-loom-T-shirt
Fruit of the loom T-shirt Yellow │ Fruit-of-the-loom-T-shirt
Example:
Chef Works Baseball Cap Blue
Chef Works Baseball Cap Red
Chef Works Baseball Cap Yellow
Whites Baseball Cap Blue
Whites Baseball Cap Red
Whites Baseball Cap Yellow
Fruit of the loom T-shirt Blue
Fruit of the loom T-shirt Red
Fruit of the loom T-shirt Yellow
Spare Buttons White
So I want a query that would return all the records where the 1st 21 characters match other records in the column, giving me:
Chef Works Baseball Cap Blue
Chef Works Baseball Cap Red
Chef Works Baseball Cap Yellow
Fruit of the loom T-shirt Blue
Fruit of the loom T-shirt Red
Fruit of the loom T-shirt Yellow
I would also like it to create new field that would take the common characters and put these into a new column with dashes instead of spaces. Like this:
Chef Works Baseball Cap Blue │ Chef-Works-Baseball-Cap
Chef Works Baseball Cap Red │ Chef-Works-Baseball-Cap
Chef Works Baseball Cap Yellow │ Chef-Works-Baseball-Cap
Fruit of the loom T-shirt Blue │ Fruit-of-the-loom-T-shirt
Fruit of the loom T-shirt Red │ Fruit-of-the-loom-T-shirt
Fruit of the loom T-shirt Yellow │ Fruit-of-the-loom-T-shirt
Last edited: