BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
wjalford
Contributor

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.

0 Kudos
2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
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.

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];
);
8 REPLIES 8
Highlighted
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
0 Kudos
wjalford
Contributor

Re: How to handle quotes in your column name

Thank you. That worked.
0 Kudos
wjalford
Contributor

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

0 Kudos
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
Contributor

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?

0 Kudos
wjalford
Contributor

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.
0 Kudos

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")[] );
Learn it once, use it forever!