Changing type using Multi-field formula? (Or other tools)

[OF_Kimbo]

Hi all,
I am trying to change the type of the data in certain columns of my table, it the most dynamic way.

My table looks like this: (sorry I’m typing from the phone)

| Name | Cause | Date1           | Con1 | Date2          | Con2 |

| Joe     | sport   | 2020-03-12 | 15      | 2020-04-16 | 32      |

all the rows are similar. No patterns, nothing special, just records. The number of columns DateN and ConN is variable, generated through a dynamic workflow, that’s why I am looking for a dynamic solution.

Now, all the values are V_String, and I need a formula that ‘identifies’ the column (Contains should do the job) and replace/assign/edit the Type of the data in that column.

Specifically: DateN should have date format (yyyy-mm-did) and the ConN should be Double (with two decimals).

Do you have any idea how to do it with formulas? Or with any other tool?

Thank you all.

[OF_Kimbo]

@Yoshiro_Fujimori

yes, they are selected

[Yoshiro_Fujimori]

I increased the columns but cannot recreate the issue.

Sorry, it seems I cannot help...