Match text in cell arrays and copy values to another

Question

AHMED FAKHRI 2021-6-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/861405-match-text-in-cell-arrays-and-copy-values-to-another

回答： Image Analyst 2021-6-21

Hi

I have a cell array (one of many) that looks like this: on the left is the sector name. On the right is the emission value of that sector.

Let us assume the name of the cell array is E30

'Coal Mine (open)'	0.016182475
'Food & Drink'	    0.004392493
'Gas Platform'	    0.00377076
'Gas Terminal'	    0.023197913
'Glass'	            0.031353608
'LNG Terminal'	    0.027425894
'NRMM'	            0.421852383
'Oil Terminal'	    0.093687465
'Other Iron and Steel'	0.004623789
'Other Minerals'	    0.004241753
'Other industry'	    6.61E-05
'Paper'	                0.002562681
'Vehicles'	            0.000265986
 

I want to copy the values only to the cooreponding exact row (sector name) and E30 column in the new array below (leaving the empty sectors as they are)

Sector	                   E25	      H25	     CCS25	  E30
'Coal Mine (open)'				
'Food & Drink'				
'Gas Platform'				
'Gas Terminal'				
'Glass'				
'NRMM'				
'Oil Terminal'				
'Other Chemicals'				
'Other Iron and Steel'				
'Other industry'				
'Paper'				
'Vehicles'				
'Ammonia'				
'Refining'				
'LNG Terminal'				
'Non ferrous metal'				
'Iron (Port Talbot Scunthorpe)'				
'Lime'				
'Oil Platform'				
'Other Minerals'				
'Cement'				
'Ethylene'				
'Compressor Station'				
'Construction'				
'Other Fuel Production'				
'Waste Processing'				