Hi,
I have a field which has already contain the product name as :
EnchSG100ml,
EnchSG100ml+RomaSH50ml,
EnchSH250ml+RomaHB100ml,
RomaSG700ml+EnchSH120ml,
RomaHB250ml,
(Where Ench/Roma are product brand, SG/SH/HB are product type & ml is the product volume & "+" means the it banded together as a single product.)
I would like to split this fiels to 2 fields as Product1 & Product2, how should I do so?
I had tried with Right / Left function but it does not work for a records with "+"
Thanks
I have a field which has already contain the product name as :
EnchSG100ml,
EnchSG100ml+RomaSH50ml,
EnchSH250ml+RomaHB100ml,
RomaSG700ml+EnchSH120ml,
RomaHB250ml,
(Where Ench/Roma are product brand, SG/SH/HB are product type & ml is the product volume & "+" means the it banded together as a single product.)
I would like to split this fiels to 2 fields as Product1 & Product2, how should I do so?
I had tried with Right / Left function but it does not work for a records with "+"
Thanks