cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
wjalford
Level III

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions
pmroz
Super User

Re: How to handle quotes in your column name

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

View solution in original post

pmroz
Super User

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];
);

View solution in original post

8 REPLIES 8
pmroz
Super User

Re: How to handle quotes in your column name

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

Jeff_Perkinson
Community Manager Community Manager

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. 

-Jeff
wjalford
Level III

Re: How to handle quotes in your column name

Thank you. That worked.
wjalford
Level III

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

pmroz
Super User

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];
);
wjalford
Level III

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?

wjalford
Level III

Re: How to handle quotes in your column name

I 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

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")[] );