Languages
[Edit]
EN

Regex - convert from camel case notation to underscore

14 points
Created by:
Root-ssh
6550

To convert from camel case to underscore notation we can use below regex.

Regex:
([a-z])([A-Z0-9])

Replace with:
\L$1_$2

// BEFORE:
dbColumnName

// AFTER:
db_column_name

Tested with notepad++.

Notes:

  • ensure to have 'Match case' radio button checked,
  • ensure to have 'Regular expression' radio button checked.

Motivation:
     Why I like to use it?
     Because I don't need to convert SQL field names manually and it saves my time.

Screenshots

Screenshot before:

Regex to convert from camel case to underscore notation - before replace
Regex to convert from camel case to underscore notation - before replace

Screenshot after:

Regex to convert from camel case to underscore notation - after replace
Regex to convert from camel case to underscore notation - after replace

More complex example

// BEFORE:
pictureId
pictureHashId
pictureFilename
userId
pictureUploadTime

// AFTER:
picture_id
picture_hash_id
picture_filename
user_id
picture_upload_time

See also

  1. Regex - convert from underscore to camel case notation
Hey 👋
Would you like to know what we do?
  • Dirask is a friendly IT community for learners, professionals and hobbyists to share their knowledge and help each other in extraordinary easy way.
  • We welcome everyone,
    no matter what the experience,
    no matter how basic the question is,
    this community will help you.