topic Re: Table Split: how to move the suffix before the original column names? Temperaruer Step 1 vs. Step 1 Temperature in Discussions

Table Split: how to move the suffix before the original column names? Temperaruer Step 1 vs. Step 1 Temperature

Fruit325 — Tue, 24 Sep 2024 08:31:44 GMT

Hello, I want to get some advice for splitting table. Thank you!

I have two columns A and B

A: Temperature

B: Step 1 / Step2 / Step3

I split column "temperature" by column "steps". The final column names are "Temperature Step1", "Temperature Step2"...

How could I make final column name starts with suffix steps? like "Step1 Temperature", "Step2 Temperature"? I got a lot of columns so it is difficult to edit manually.

Thanks!

Re: Table Split: how to move the suffix before the original column names? Temperaruer Step 1 vs. Step 1 Temperature

jthi — Tue, 24 Sep 2024 13:50:37 GMT

You can edit your B column (or create new) in your original data table before split (change formula to "Temperature " || :B)

Or you can use recode column names with regex for example

With ^ you can "replace" start of the string and then replacement text is "Temperature "

Or you can write a script

Re: Table Split: how to move the suffix before the original column names? Temperaruer Step 1 vs. Step 1 Temperature

Fruit325 — Tue, 24 Sep 2024 14:36:20 GMT

@jthi Thanks! That's exactly what I am looking for and it works very well!