Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Monday, 09 August 2021
  0 Replies
  1.7K Visits
0
Votes
Undo
Hi 

I have a excel column with the sample below that I am trying to extract the data each in a separate column. The problem is that the order of each category is not consistent in some Dimond color is first and others the diamond weight.

appreciate your help.

Mehran
Material=14K Solid Gold;Diamond Weight=2.4;Diamond Color=G-H;Diamond Clarity=SI 1-2;Material=14K Solid Gold;Diamond Weight=10.4;Diamond Color=G-H;Diamond Clarity=SI 1-2;Material=14K Solid Gold;Diamond Weight=0.24;Diamond Color=G-H;Diamond Clarity=SI 1-2;Color Stone Weight=2.47;Material=14K Solid Gold;Diamond Weight=0.51;Diamond Color=G-H;Diamond Clarity=SI 1-2;Color Stone Weight=3.09;Material=14K Solid Gold;Diamond Weight=7.9;Diamond Color=G-H;Diamond Clarity=SI 1-2;Material=14K Solid Gold;Diamond Weight=2.5;Diamond Color=G-H;Diamond Clarity=SI 1-2;Material=14K Solid Gold;Diamond Weight=0.35;Diamond Color=G-H;Diamond Clarity=SI 1-2;Color Stone Weight=2.24;Material=14K Solid Gold;Diamond Weight=0.37;Diamond Color=G-H;Diamond Clarity=SI 1-2;
There are no replies made for this post yet.