WILT: Visual Studio Code search/ replace case with regex

code wilt common-book

Working on an import script we received from another university (thank you!). Our export was in MySQL, theirs was in another database, using XML as a common interpretter. Issue was, MySQL had fields with _ separating words, wheras theres Uppercased the first letter of each word (e.g. date_of_birth vs. dateOfBirth).

You can actually do find an replaces in Visual Studio Code using case change:

  • Search for _([a-z])
  • Replace with \U$1

So \U says "Make Uppercase The Following". So that's nice. Made fixing the import script much faster. I think it's worth checking out Replacement Text Case Conversion to see what else can be done.

Professor von Explaino