BookmarkSubscribeRSS Feed
wjalford

Contributor

Joined:

Jan 16, 2019

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

Joined:

Jun 23, 2011

Solution

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

Joined:

Jun 23, 2011

Solution

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
pmroz

Super User

Joined:

Jun 23, 2011

Solution

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

Joined:

Jun 23, 2011

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

Contributor

Joined:

Jan 16, 2019

Re: How to handle quotes in your column name

Thank you. That worked.
wjalford

Contributor

Joined:

Jan 16, 2019

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

Joined:

Jun 23, 2011

Solution

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

Joined:

Jan 16, 2019

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?

Highlighted
wjalford

Contributor

Joined:

Jan 16, 2019

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.
markbailey

Staff

Joined:

Jun 23, 2011

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!