Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- JMP User Community
- :
- Discussions
- :
- JSL - How to remove formula from column?

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jul 13, 2014 1:27 AM
(16837 views)

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Below is another option:

dt = Open

("$SAMPLE_DATA/Bank Loan.jmp");:Time <<

Delete Formula;

Wendy

5 REPLIES 5

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: JSL - How to remove formula from column?

Try the Delete Property() message to the column.

dt = Open

("$SAMPLE_DATA/Tiretread.jmp");:Pred Formula ABRASION <<

delete property(Formula);

-Jeff

-Jeff

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Below is another option:

dt = Open

("$SAMPLE_DATA/Bank Loan.jmp");:Time <<

Delete Formula;

Wendy

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: JSL - How to remove formula from column?

I just found it at this BBS:

Column(dt, "Values From Formula") << deleteFormula;

Column(dt, "Values From Formula") << deleteFormula;

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: JSL - How to remove formula from column?

This is perfect for column names that have special characters in them, thanks!!

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: JSL - How to remove formula from column?

Or by using the :Name() function form

`:Name("Values From Formula") << deleteFormula; `

Jim

Article Labels

There are no labels assigned to this post.