Clear data from columns in table

[waltmayo]

I have a large table. I want to clear the data from one or more columns. Can this be done through wildcards in search and replace... or other technique?

Walt

[Bangalore]

Walt,

As I understand you would like to use *, % in the Search and Replace in a Table, I am afraid it is not a standard feature. You may export the Table into Excel, search and replace (modify/delete the columns) and import the Table back into Caspio.

http://howto.caspio.com/tables/exporting-data.html

http://howto.caspio.com/tables/importing-data.html

I hope this helps.

Regards,

[Kurumi]

Hi @waltmayo,

As for the new Caspio features, you can now do this using Task or Trigger.  For more information about Tasks and Triggered Action:
https://howto.caspio.com/tasks/
https://howto.caspio.com/tables-and-views/triggered-actions/
This allows you to create and execute a specified data events (i.e. insert, update or delete) to perform additional data changes and complex data calculations on the same table and other tables.

 

I hope this helps!