topic Re: How to handle quotes in your column name in Discussions

How to handle quotes in your column name

wjalford — Tue, 29 Jan 2019 13:02:46 GMT

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 name

pmroz — Tue, 29 Jan 2019 13:09:55 GMT

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

Re: How to handle quotes in your column name

Jeff_Perkinson — Tue, 29 Jan 2019 14:07:16 GMT

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

wjalford — Tue, 29 Jan 2019 14:18:16 GMT

Thank you. That worked.

Re: How to handle quotes in your column name

wjalford — Sat, 02 Feb 2019 03:22:45 GMT

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 name

pmroz — Tue, 29 Jan 2019 15:42:52 GMT

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

Mark_Bailey — Tue, 29 Jan 2019 16:06:47 GMT

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

wjalford — Tue, 29 Jan 2019 16:43:13 GMT

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

wjalford — Tue, 29 Jan 2019 17:19:44 GMT

I was missing [i] from one of my columns. After correcting it worked perfectly. Thank you so much for the help.