4 ms·
(Note) self-promotion I needed cells in Excel to be translated into a list that SQL would like. I copied rows from Excel into VSCode, and would run a series of
by bobblywobbles 5y ago
(Note) self-promotion
I needed cells in Excel to be translated into a list that SQL would like. I copied rows from Excel into VSCode, and would run a series of regex commands to format it into a valid SQL list. I got tired of running this manually, and turned it into an extension.
https://marketplace.visualstudio.com/items?itemName=reZach.listtosql https://marketplace.visualstudio.com/items?itemName=reZach.l...
- yarinr 5y agoFind myself doing that often too (not specifically from Excel, but generally formatting lines to SQL list with regex). Will definitely give your extension a try!
- bobblywobbles 5y agoThanks for trying it out!
- lazyeye 5y agoAlso try NimbleText (windows) which is really useful for translating csv data into sql or whatever other format you require