Jump to content
  • 0

Extract Data to Populate Table Columns



I have raw data fields that contain many values that need to be extracted to their own columns on a table.  In Excel, I was using a nested If(isnumber(search function to extract the various values to their respective columns.

How do I do this in Caspio?  The attached file shows a couple of examples of before and after.




Help on Data Extraction.xls

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Hi Sheila,

This can be done in multiple ways:

  1. JavaScript: You might take a look at my other forum post below, although you might need to tweak the JavaScript a bit.  See the REFERENCES section below for the link.
  2. Triggers: This is a new feature in the 9.9 release. See below for the link.


  1. Multiple Values Separated by Commas Input: https://forums.caspio.com/topic/6770-multiple-values-separated-by-commas-input/?do=findComment&comment=21222
  2. Triggered Actions (aka Triggers Feature): https://howto.caspio.com/tables-and-views/triggered-actions/

Hope this helps.


Link to comment
Share on other sites

  • 0

Thanks to both of you.  My file is not comma delimited, so can't separate that way.  Also, the data has many variations.  I want 3 columns to be populated, but the values for each column are many.  For instance, column 1 only has 3 variations that could be populated, but column 2 has as many as 15 and column 3 has over 20 variations.

Here is an example of the function I use in Excel to populate column 1:

ActiveCell.FormulaR1C1 = _

The result is column 1 only contains the values of Mens, Womens or Kids, even though the raw data may contain other values.

The other two columns work the same way, but with more and different variables.  Hope I'm explaining this right.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...