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.
TIA!
S.
Help on Data Extraction.xls