I have a rather large data set that is requiring quotes (") to be placed at beginning and end of the line only if the line includes a comma somewhere within the line (could be different places depending on the line - for example not always the 5th character). Is there a way to automate this a bit instead of manually reviewing each line and typing the quotes in?
-
1What have you tried so far? FAQ Desk: Where to find REGEX documentation? - Notepad++: A guide to using regular expressions and extended search mode - Regular Expressions Tutorial– DavidPostill ♦Sep 16, 2022 at 17:39
-
1This is really basic, what doesn't work with your attempts?– TotoSep 16, 2022 at 17:52
Add a comment
|
1 Answer
You can use this regex:
(.*,.*)
(search for one or more symbols) and replace with
"\1"