I have Ubuntu 24.04.2 LTS. I am using a windows program (using WINE) the output of which is a csv file. I would like to download this output to my computer. At some point I would like to re-load it into the program to compare it with other data. The program recommends Excel. What is the most elegant way around this? Many thanks.
I have a text file that contains passwords and their respective hashes that is formatted as such:
'plaintext password'
'SHA256 hash'
'SHA3-512 hash'
This format continues for several more passwords. Each password and hash has its own line within the file. Each of the hashes below the 'plaintext password' are its respective hashes. I want to create a CSV file that will end up looking like this:
'plaintext password','SHA256 hash','SHA3-512 hash'
Essentially, I want to combine those three fields into one line for each password, delimited by commas for each field. I have tried searching for similar situations to mine but with no avail. I have tried awk as well as tr -s, but I haven't been able to get exactly what I want. I would appreciate the help!
I have a txt file that has either tab or space delimiter. I need to convert it to csv. How do you suggest to do so using command line?
$ perl -F"//" -nlae 'for (@F) {$a{$_}++};for (keys %a){print $_ if ($a{$_}+1==5 && !($_=~/\w/))};undef %a' moth_gt.txt
The above command output nothing.
The file looks like below:
$ head -10 moth_gt.txt
1.0000 494.5551 234.2510 711.6219 274.2668 481.7198 299.5598 311.0864 339.5756
2.0000 494.6552 233.6892 698.5310 237.2043 478.3979 300.0367 285.5068 300.0367
3.0000 496.0657 234.5680 660.4773 182.6485 477.8938 299.0346 279.7346 239.3273
4.0000 498.0948 236.4126 618.2942 142.6347 477.2553 302.2803 298.6309 175.0104
5.0000 499.2109 237.2335 603.7807 120.0112 473.9058 307.5669 323.1914 136.0130
6.0000 497.2581 236.8611 616.7132 115.5453 473.4415 309.7994 336.1240 123.7323
7.0000 497.2588 237.2343 642.7633 126.7104 471.5815 313.1497 329.7984 132.6645
8.0000 499.1200 239.4676 669.9296 159.0866 470.0935 315.7552 312.3086 156.4817
9.0000 498.0675 237.7640 703.4297 201.8367 468.7934 317.1588 292.7054 184.0948
10.0000 498.9722 237.7636 718.0843 248.8523 469.6981 316.7149 282.5214 219.1346
Using the following command also didn't help:
$ cat moth_gt.csv | tr "\\t" "," > moth_comma.csv
I've got a series of CSV files whose second field is dates:
R.OUSE BOURTON MILL,2000-03-22T14:50:00,Ammoniacal Nitrogen as N,0.03,mg/l
How can I change the date format into DD/MM/YYYY for all files? The measurement time is not needed.
Thank you so much
I would like to split a spreadsheet (ods or xlsx) into multiple csv files, one for each sheet in the spreadsheet.
I would like to do this without launching a graphical app and preferably in a one liner.
Any ideas?
Though the linked duplicate provides a possible solution in one of the answers (not in the accepted one) and was helpful. The solution does not work with ODS files as I requested, and I consider the question to be sufficiently different.