Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
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.