• 5 Posts
  • 769 Comments
Joined 3 years ago
cake
Cake day: July 4th, 2023

help-circle


  • The best part of vba is you can record a Macro then edit it. I think you should start by adding a button that shows a message box when you press it, then record a Macro and throw some message boxes in it to see what values are used. Beware, office 365 has some other thing besides vba that I’m not familiar with, you may be better off learning that.







  • If you’re writing a program, definitely multiple threads or processes that each scan a chunk of the file, which basically means seek to the start of the chunk, read lines into the scan code until you hit the end of the chunk. For jsonl each chunk will need an alignment step to not break the jsonl.

    For command line trickery, maybe the file could be chunked up by running multiple dd instances with an offset parameter piped into grep. This has many synchronization issues and all the outputs should be captured separately then combined afterwards. I can’t think of a good way to align this method to line edges but maybe you can put some fancy regular expression magic into the grep step to ignore malformed json at the beginning and end and overlap the chunks?

    Grep is fast already, maybe test the simple approach and see how long it takes.






  • If you can see how the other machines on the network access the drives, like with net use in the windows command prompt, then you will know the protocol and address and share name to connect to.

    If it’s something like \\computername\a\path\here that’s a windows file share which you can connect to with samba. On modern Linux desktop systems you can sometimes get away with opening a file browser and typing in a location like smb://computername/a/path/here and it may just work

    Keep in mind computername could be an IP address instead, and some file browsers are sneaky about letting you type in a path (nautilus/gnome, which I think is Ctrl+L) if smb://… Doesn’t work smbfs:// may be worth a try