Virus Scan for Modern CSV

Bradley MacDonald This looks very interesting.
Does it handle fields with Carriage Return Line Feeds in them? By this I mean you might have 5 columns - but the 3 column is a TEXT field that can contain information that was multi-line. This is the bane of almost every CSV editor I have worked with. Most of them consider the CRLF characters as the end of the line - and then start a new CSV row - even though you were in the middle of the column (even if you were inside the "" field boundries...

Dec 30 2022 at 12:50pm Copy Link

2

Evan User As long as the cell has surrounding double quote characters, CRLF or LF will be treated as part of the cell rather than the end of the row. There's an editor pane feature (ctrl+k,ctrl+e or cmd+shift+e in Mac) that you can use to edit cells with newline or tab characters.

Gallium Digital - Dec 30 2022 at 3:26pm Copy Link

3

soo mi Evan, do you have a portable version of Modern CSV, or can the current version be installed on/run from a portable device?

Dec 30 2022 at 10:50pm Copy Link

1

Evan User I'm afraid there is no mobile version. There are versions for Windows, Mac, and Linux, but I don't have any plans for Android or iOS.

Gallium Digital - Dec 31 2022 at 10:40am Copy Link

0

Dan P One of the best pieces of software I've purchased from Bits Du Jour. Highly recommended if you're in need of a CSV editor.

Mar 23 2023 at 3:03am Copy Link

4

naveed Can you do any math like summing a column?

Mar 23 2023 at 9:54am Copy Link

1

Evan User This version does not. Version 2 with a business license will do some math and statistics operations on columns, including summation. I don't have a release date, but it will be in the near future.

Gallium Digital - Mar 23 2023 at 2:04pm Copy Link

2

Henry User I have a delimited document, that is 6.5 gig in size, has 20 million records and 47 fields.Each record is a different person.

I am using a computer with up to date Windows 11 and plenty of memory and disk space.

To my surprise, Moden CSV was able to load and display it. It started by telling me that, due to the size of the document, it would be read only. It took a few minutes to load.

I knew that a certain last name appears in the document about 25 times. So, I did a search of that field for that last name. About 30 minutes have elapsed and the rotating window circle just keeps rotating without any movement away from the first record.

Can you tell us:

1. What does read only mean in this context? I always thought it only meant that the data could not be changed.

2. What are the practical limitations of Modern CSV with regard to file, record and field size?

Mar 23 2023 at 2:41pm Copy Link

0

Evan User 1. In read-only mode, rather than loading the file into memory, the app indexes it and reads it straight off the disk. I enabled a few features that aren't "read-only" strictly speaking. These are sort, hide, and filter.

2. In read-only mode, memory usage is approximately 20% of the file size. It loads the file faster, but sort, filter, and find operations run slower than edit mode.

In edit more, memory usage is 3 to 4 times the file size. It's a bit slower to load, but all the operations are faster.

Assuming you have enough memory, it can handle up to 2 billion rows and columns (2,147,483,648 to be exact). For all intents and purposes, there are no limits to field sizes. People have had several MBs in a single field.

For a 6.5 GB file, if you have 20 to 25 GB free, that might be the better way to go.

If you're searching for just last names, you can select the entire column. Then, in the Find pane, enable the "Match Only in Selected Cells" button (2nd from the right). That way, it will only search that column rather than the entire file.

Gallium Digital - Mar 23 2023 at 4:25pm Copy Link

1

fpi fpi PFOJ Enterprises LLC is an the American author of Modern CSV, but who is Gallium Digital ?

Mar 24 2023 at 3:00am Copy Link

0

Evan User I recently switched corporations, so PFOJ Enterprises no longer exists and it's now run under Gallium Digital. I apologize for any confusion.

Gallium Digital - Mar 24 2023 at 6:15am Copy Link

1

Henry User As far as I can tell., this program is very good for viewing and editing delimited data. files and for searching for the presence of words within files. It can also sort and replace.

It does not perform calculations and does not provide for printing or for the creation of macros that will check or reorganize data.

What it does do, it does well and can do so for huge files.

If I have oversimplified it, perhaps Evan can describe it further.,

Mar 24 2023 at 11:26am Copy Link

0

fpi fpi @Evan User, thanks for the explanation.
But Concerning "Gallium Digital" no details or existence, seems available on the Web.
No mailing address.
Finally, are you the genuine developer ?

Mar 25 2023 at 2:16am Copy Link

0

MK Good grief: two seconds on the Modern CSV website and found they reference Gallium in their license:
https://www.moderncsv.com/license-terms/

Mar 25 2023 at 6:36am Copy Link

3

Richard Blake Can a v1.x personal license purchased through BdJ be upgraded to a business license when v2 is released?

Mar 25 2023 at 1:34pm Copy Link

0

Richard Blake I've tried looking at the https://www.moderncsv.com/documentation/ but find it difficult to follow some of the rapid animations. Please add the capability to examine the table before the action, then play the action at a speed I choose, then pause so I can examine the table after the action has completed. Does look comprehensive, though.
Installed software, running in free mode, looking at Tutorial.csv.
Ctrl+L > transpose (one of the actions I didn't follow in the online documentation)
Doesn't tell me what transpose does, it only says that this feature is only available in the premium version. Well, that certainly convinces me that the premium version is something I want to buy.

Mar 25 2023 at 1:45pm Copy Link

0

Evan User @fpi fpi If it helps, the website is galliumdigital.net (As you can see from the site, I don't anticipate much traffic there). Yes, I'm the developer.

Gallium Digital - Mar 25 2023 at 5:16pm Copy Link

0

Evan User @Richard Blake Yes, licenses bought here are eligible for discounted upgrades, the same as those bought directly from the website. Version 2 will have updated documentation, although most of it will be the same style - more graphics/gifs than words. I find that people (myself included) don't like to read a bunch of words, so I try to get to the point as concisely as possible. I will redo some of the outdated graphics including the transpose commands.

Gallium Digital - Mar 25 2023 at 5:23pm Copy Link

1

Evan User @Richard Blake To answer your question about the transpose commands, they flip the data so rows become columns and columns become rows. One works on the entire table and the other works only on the selected portion of the table. I'll make sure that's clearer in the new documentation.

Edit: I just remembered I made a blog post about transposing: https://www.moderncsv.com...csv-files/

Gallium Digital - Mar 25 2023 at 5:35pm Copy Link

1

Gary User I purchased this in December of 2022. 6 months later they come out with a ew version and want $39 to upgrade. Needless to say I've removed it from my computer and will look elsewhere for a similar program.

Jul 29 2023 at 5:37am Copy Link

0

Tim Parsons @ Gary User the upgrade price seems to be $39 only if you want the business licence. The personal license upgrade is half that, and v1 of the software seems extremely capable as it is.

For what it's worth, I think you'll struggle to find a competitor, feature for feature. Like you, I'm a bit disappointed that we missed out on the upgrade just by a couple of months, but the upgrade policy wasn't sprung on us by surprise.

Jul 29 2023 at 8:07am Copy Link

0

Virus Scan for Modern CSV

View and Edit CSV Files

Download Virus Scan - Modern CSV

Website Malware/Phishing Scan - Gallium Digital

Website 100% Clean Badges

What are people saying about Modern CSV