I'd like to remove the model code , MHCQ3VC/A and the sku 104813 - How can I go about this?
Spacing is not always consistent, but they always come at the end of the string.
regex_replace([description],"(.*)(\w{7}.*)","$1") should work.
This assume that the product code contains the first unbroken string of 7 alphanumeric characters in a row.
This appears to nuke me if I have Samsung, I've made it just apple.
Second, if I only have a sku how should I go about it, tone down to 6? -- this is a samsung only thing
SAMSUNG GALAXY A51 64GB BLACK 105161
It starts getting pretty complicated because of the fairly unique syntax each phone company uses. I can get you half-way there but it'll require substantial work to finish off what you need for brand/color info.
I revised to
regex parse (\w+\s+\w+)
gives me "Samsung S21" and should suffice with some renaming of some phones with weird naming. Thanks for your help.
Thank you, i have the same problem like this
@davidlan - can you post a data sample (either here or in a new thread)?
@apathetichell Thank you, I will post a new thread
