Languages
[Edit]
EN

Regex - convert from camel case notation to underscore

14 points
Created by:
Root-ssh
68440

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
Native Advertising
50 000 ad impressions - 449$
🚀
Get your tech brand or product in front of software developers.
For more information contact us:
Red dot
Dirask - friendly IT community for everyone.

❤️💻 🙂

Join