cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Data_Mike
Level I

% in Column Name

Hello All,

 

There is an auto generated report which has the column name as % Adapter Bases. 

 

I want to update from this report, however when I use the column name it gives me an error since % is in the beginning. Is there any workaround to this?

 

Data Table( "all data" ) << Update (
With( dtv ),
Match Columns( :SampleID = :sampleID),
Add Columns from Update table( :% Adapter Bases ),
);

 

Thanks!

Mike

1 REPLY 1
jthi
Super User

Re: % in Column Name

 Try following syntax

:"% Adapter Bases"n

Scripting Guide > JSL Building Blocks > JSL Syntax Rules > Names 

-Jarmo

Recommended Articles