Converting CamelCase to snake_case

We recently had a question about how to convert Camel case to Snake case.

E.g. ‘AccountID’ to ‘Account_ID’

This isn’t a standard transform in the Case transform, but you can do this with Replace transform and a regex:

If you then want to change all the case to lower, use a Case transform.

If you want to do this for column headers, Transpose then first, convert to Snake case and then Transpose back.

3 Likes