UTF-8 special characters "ñ" from Transform Script

Ignition
1

Hi!

I aplied a transform script to a table to subsitute header values for others with special uTF-8 characters,

def transform(self, value, quality, timestamp):
	
	new_headers = [
	    "Equipos de PCI",
	    "Instalacion electrica",
	    "Señalización PCI", 
	    "Iluminación emergencia", 
	    "Salidas y vías evac.",  
	    "Señalización evacuación y",  
	    "Señalización riesgo elect.",  
	    "Caída de personas mismo nivel",  
	    "Escalas fijas",
	    "Escaleras portátiles de mano", 
	    "Iluminación PVD",  
	    "Iluminación resto (no emerg.)",  
	    "Climatiz. (Temp.)",
	    "Climatiz. (Hr)",
	    "Climatiz. (CO2)",
	    "Caída de objetos desprendidos",  
	    "Atropellos",
	    "Tránsito por cubierta",  
	    "Otros riesgos detallar)"
	]
	
	
	def transform_dataset(dataset):
	   
	    py_data = system.dataset.toPyDataSet(dataset)
	    
	
	    new_data = []
	    
	
	    for row in py_data:
	        new_row = list(row)
	        new_data.append(new_row)
	    
	   
	    original_headers = list(py_data.getColumnNames())
	    modified_headers = original_headers[:2] + new_headers[:len(original_headers)-2]
	    
	
	    return system.dataset.toDataSet(modified_headers, new_data)
	
	
	transformed_data = transform_dataset(value)
	

	return transformed_data

image
image846×189 6.84 KB

But the special characters as "ñ" are not showing well. Just happens with scripts because with labels wouldn´t happen.

Wonder if there is a solution.

2

You have used non-ASCII characters in jython string constants that do not support them. Use unicode string constants instead, using the u"Mañana" syntax. That lower-cause u before the first quote tells jython to handle the unicode characters correctly.

https://docs.python.org/2.7/reference/lexical_analysis.html#strings

2 Likes
3

Thanks a lot pturmel, works great!


	new_headers = [
	    u"Equipos de PCI",
	    u"Instalacion electrica",
	    u"Señalización PCI", 
	    u"Iluminación emergencia", 
	    u"Salidas y vías evac.",  
	    u"Señalización evacuación y",  
	    u"Señalización riesgo elect.",  
	    u"Caída de personas mismo nivel",  
	    u"Escalas fijas",
	    u"Escaleras portátiles de mano", 
	    u"Iluminación PVD",  
	    u"Iluminación resto (no emerg.)",  
	    u"Climatiz. (Temp.)",
	    u"Climatiz. (Hr)",
	    u"Climatiz. (CO2)",
	    u"Caída de objetos desprendidos",  
	    u"Atropellos",
	    u"Tránsito por cubierta",  
	    u"Otros riesgos detallar)"
	]

image
image835×117 5.8 KB