108195_en-US

liliconcom

How to handle quotes in your column name

I have a column name Substance "x".  I need to sum the column but I am having an issue with the quotes.  How do I use the column x with the quotes? I have tried :substance \!"X\!".  That does not work.

Re: How to handle quotes in your column nameI was missing [i] from one of my columns. After correcting it worked perfectly. Thank you so much for the help.Re: How to handle quotes in your column name

I used your suggestion and still get the error it "Cannot convert argument to a number [or matrix]{1} in access or evaluation of 'Add'.  I have checked all of my columns and they are all numeric.  Any idea why I would get this error?

Re: How to handle quotes in your column name

Or add empty square brackets after the Column() function if you want to use For Each Row() to iterate.

 

For Each Row( Column("Total Sum")[] = Column("Dimer [Cl5Si2-O-Si2Cl5]")[] + Column("Silicon Tetrachloride(SiCl4)")[] + Column("Trichlorosilane(SiHCl3)")[] + Column("Hexane")[] + Column("Hexachlorodisiloxane(Si2Cl6O)")[] + Column("Substance \!"X\!"")[] + Column("HCDS")[] + Column("Mixed Dimer [Cl5Si2-O-SiCl3]")[] + Column("OCTS")[]
+ Column("GC Column Product")[] );

Re: How to handle quotes in your column name

This code will work.  I've only included the first two columns you want to add.

dt = current data table();
for (i = 1, i <= nrows(dt), i++,
 Column(dt, "Total Sum" )[i] = Column(dt, "Dimer [Cl5Si2-O-Si2Cl5]" )[i]
 + Column(dt, "Silicon Tetrachloride(SiCl4)" )[i];
);

Re: How to handle quotes in your column name

On the same subject.  The compiler likes the syntax, but I am getting the following error.  

 

My Code is:

 

 

Thank you in advance.

 

Wayne

Re: How to handle quotes in your column nameThank you. That worked.Re: How to handle quotes in your column name

As @pmroz points out, the Name() function is used to handle names that have special characters in them. 

Re: How to handle quotes in your column name

Try :Name("substance \!"X\!""), or column(dt, "substance \!"X\!""), where dt points to your table.