).

Is the match case-sensitive?

By default yes. Toggle case-insensitive matching if needed.

Can I combine prefix and suffix matching in one rule?

Use regex mode and write: ^q1_|_date$ to keep columns starting with 'q1_' OR ending with '_date'.

What if I want to keep columns by their index position rather than name?

Use the Select or Remove Columns tool and manually tick the columns by position.

Related tools

Reshape

Transpose CSV

Flip a CSV matrix by turning rows into columns and columns into rows.

Open Tool →
Reshape

Pivot a CSV

Summarise long-format CSV data into pivot tables grouped by row and column keys.

Open Tool →
Reshape

Group By and Count

Aggregate CSV rows by one or more group-by columns with count, sum, mean, min, or max.

Open Tool →
)." } }, { "@type": "Question", "name": "Is the match case-sensitive?", "acceptedAnswer": { "@type": "Answer", "text": "By default yes. Toggle case-insensitive matching if needed." } }, { "@type": "Question", "name": "Can I combine prefix and suffix matching in one rule?", "acceptedAnswer": { "@type": "Answer", "text": "Use regex mode and write: ^q1_|_date$ to keep columns starting with 'q1_' OR ending with '_date'." } }, { "@type": "Question", "name": "What if I want to keep columns by their index position rather than name?", "acceptedAnswer": { "@type": "Answer", "text": "Use the Select or Remove Columns tool and manually tick the columns by position." } } ] }