![A comma and semicolon per password foils the parsing of most data breach releases. [1029x1050 - 184KB]](https://pic8.co/sh/7xloPu.jpg){kind=link}
csv files can be made to use escape characters and put strings in ' ' brackets.
csv files can be made to use escape characters and put strings in ' ' brackets.
Excel. Control h Replace all, with '' Or wrap all fields as a literal string
Excel.
Control h
Replace all, with ''
Or wrap all fields as a literal string
Trouble is, I would imagine anyway, is doing it to 65,535 rows. In Excel. They'd probably have scores of these files. Maybe there's a more efficient program out there.
Trouble is, I would imagine anyway, is doing it to 65,535 rows. In Excel. They'd probably have scores of these files. Maybe there's a more efficient program out there.
I use notepad++ a lot for text editing millions of lines.
I just like that with excel I can bring in time saving functions like concatenate to convert a price file to sql inserts
I use notepad++ a lot for text editing millions of lines.
I just like that with excel I can bring in time saving functions like concatenate to convert a price file to sql inserts
(post is archived)