Ubuntu :: Using Bash To Sort Csv-files?

Jul 25, 2011

I am in need of sorting the content of a csv-file separated with "#". The file looks the following:

Code:
Descriptive 1#47.5498295127948#35.5365757501888#44.4127802931231#84.0767444257134#0.0416435951243528#0

[code]...

View 8 Replies


ADVERTISEMENT

Ubuntu :: Bash To Sort Files Into Subdirectories?

Sep 4, 2010

i currently have hundreds of files all in a single directory. What I would like to do is create 8 subdirectories and move the files into the subdirectories based on the first character of the file name. Ideally, the script would omit any 'the' or 'a' and use the second word for filing purposes. No filenames have spaces. Instead they use periodsThe subdirectories will be:

0-9
a-d
e-h

[code]...

View 2 Replies View Related

Programming :: Bash Script: Sort Files Into Directory Based On Data In The File Name?

Sep 28, 2010

I have very little linux experience. And need some help with a bash script. I need to a script I can set cron to run to sort files out of a holding folder into final folders. It doesn't necessarily have to be bash, but I think it would be sufficient for this. File names are formatted as such when created: Dest-Date-Time-CID-Destination# I want the files to be moved from a all in one holding folder to a folder structure like this.

.../storage/year/month/day/Destination#/VarX(type)/hour/CID/'File'

I would need an if/else if/else statement to say if Dest = A set VarX = B If for example the file name was

infinity-20100927-17:00-1112223333-4445556666.wav

I would like the above file to end up moved from

.../holding

to

.../storage/2010/09/27/4445556666/Inbound/17/1112223333/infinity-20100927-17:00-1112223333-4445556666.wav

So the script will need to make directories based on information in the file name which is delimited by single dashes. Then move files from the holding folder to the newly created "sorted" folders.

View 15 Replies View Related

Programming :: Bash Shell Scripting / Using The Sort Command To Sort The Top 5 CPU Processes?

Feb 28, 2010

What options should I use when I'm using the sort command to sort the top 5 CPU processes (ps -eo user,pid,ppid,%cpu,%mem,fname | sort ??? | head -5) showing max to min usage?

View 2 Replies View Related

General :: Using Sort And Uniq In Bash?

Feb 18, 2011

I have this file with the first lines as follows:

a
a
ability
able

[code]....

say the file is named file1.txt After i do the following:

sort file1.txt | uniq >> file2.txt

I expect that letter a would only appear once, not in two rows, word about would also appear only once. However, I can't seem to get that result using this. I also tried the sort -f file1.txt | uniq >> file2.txt but to no avail. I actually got file1.txt from a messier file using the -f option in sort command.

View 2 Replies View Related

Programming :: Sort IP Addresses For A Bash Program?

Apr 29, 2010

I have for example the following IP addresses:

24.172.220.218
41.239.36.19
63.215.202.234
66.176.124.22

[code]....

How can I sort those IP addresses? I want to sort them using the first 3 numbers I also want to count the number of times that address is repeated This is a batch program.

View 4 Replies View Related

Fedora :: Bash Hangs When Command Not Found / Sort It?

Dec 9, 2009

I've been using linux for a long time, and I just ran into a problem that has me stumped. Any time I mistype a command, it says "Command not found."... yea, I know that's normal. But it doesn't return me to my # prompt. I have to press Ctrl+C to get back. code...

I know I do have one issue with this computer, I have 2 blown caps on my motherboard. This was a dual boot system, but after a virus with winblows, I decided to switch it to strictly linux. (roommates... *grumble*) I think I was running fc10 before I wiped the hd & installed fc12. Fc12 does seem to be running slower, and I still haven't got my sound card working properly... but that issue is for another topic...
-YungBlood Reborn

View 2 Replies View Related

General :: Bash - Merging Strings (perhaps With Sort | Uniq)?

Nov 16, 2010

I have multiple strings (eg. say two, firstLIST=(0 1 2) and secondLIST=(2 3)) and want to create a single string composed of their unique sorted elements. For the sample strings above, I'd like to build masterLIST=(0 1 2 3).I suppose I could write the elements of firstLIST and secondLIST to files

Code:

echo ${firstLIST[@]} > firstFILE
echo ${secondLIST[@]} > secondFILE

then use

Code:

sort firstFILE secondFILE | uniq > masterFILE

as this gives me a file populated with the elements I'm after, but I'm not sure how to read the elements back into masterLIST... and it doesn't seem "right" to create files to accomplish this. Is there a way to do this by manipulating the strings ${firstLIST[@]} and ${secondLIST[@]} directly? The closest I've come (not close at all) is

Code:

masterLIST=${firstLIST[@]}" "${secondLIST[@]}

but masterLIST built this way has only one element

Code:

$echo ${masterLIST[@]}
0 1 2 2 3
$echo ${#masterLIST[@]}
1

and I don't have access to the individual digits to then try to figure out how to remove duplicates.

View 4 Replies View Related

Programming :: Sort Files In Directories Based On Files Date

Sep 8, 2009

I need a script that will take all the files in a given directory and create new monthly sub-directories and sort all the files based on the creation date into the appropriate directory.For example, all files created between 01/01/09 and 01/31/09 will be placed in 'JAN-2009'

View 5 Replies View Related

Ubuntu :: Need To Correctly Sort Hex Numbered Files

Feb 5, 2011

I have some files, named E000.svg, E001.svg, E002.svg, ... E07D.svg, E07E.svg, E07F.svg . When I open them in Nautilus, and choose the option Sort Alphabetically, they are sorted:

E000.svg
E00A.svg
E00B.svg
E00C.svg
E00D.svg
E00E.svg
E00F.svg
E001.svg
E01A.svg
E01B.svg
and so on.

This is totally useless for me, so I searched for a solution in Google, and found lots of bug reports. It looks like it's a 'feature' for sorting 10 after 9; but clearly they have forgot that many people don't like or don't need that option. Thinking it was a Nautilus thing, I installed Thunar, but it has the exact useless algorithm. And then I installed PCManFM, but it's also the same. If I can install a file manager that correctly sorts my files? Or will I need to switch to Windows to have it fixed? (not joking here, Windows Explorer doesn't suffer from this feature).

View 9 Replies View Related

Software :: Making A Bash Script To Read In Different Files And Rename Output Files?

May 7, 2009

Until now i haven't had to dabble with bash scripts.

I have a program that reads in data files. These are named datafile01_R, datafile01_G, datafile01_B, they then increment, so datafile02_R etc i have about 600 of these. the program reads in 3 data sets at a time from each run, so files_01 r, g, and b.

The program then does its magic, and outputs about 40 different files, depending on the file, they gone to folders named R, G, B, psa, or tracking.

The program itself has configuration files to say where the files should gone when analyzed, there is also the config files that reads in the data sets.

At the moment i have to run one set of data, then go in and manually change the input file location, and run again. But, doing this, even though a different data set, the new set overwrites the old set in one of the output folders. So i need a way to increment the output filenames after they are written and before the program is run again with the new data set.

View 1 Replies View Related

Ubuntu :: Sort Files Into Folders Based On Extension?

Sep 16, 2010

I recovered some 60,000 files with PhotoRec and need a script to sort them into individual folders based on extension. I was able to do this once before but cannot find the script again (sad thing is that I probably saved it on another HD that I'm having partition issues with, but that's another story....).I found this script:

Code:

#!/bin/dash
mkdir "$1"
for file in *.$1; do
mv "$file" "$1"
done

While it does work, I am not looking forward to going through all 132 folders and typing in each extension. The last time I did it, the folder was automatically created based on the extension(s) found.

View 6 Replies View Related

Ubuntu :: Find Files With Directories And Sort By Mod Time?

Dec 4, 2010

what i wanted to do was find all the files with a specific name from a tree, sort them by modification time and have their directory appended to them so that i knew where they were (because they all have the same name). i tried a whole bunch of different things and finally did this:

Code:
find . -type f -name world.sav -exec ls -l '{}' ; > ~/dfsaves.txt; gawk '{$1=""; $2=""; $3=""; $4=""; $5=""; print}' ~/dfsaves.txt | sort -n > ~/dfsavessorted.txt

this did the trick pretty well, but as you can see it is far from elegant and i think i'm doing some things wrong and kludgy

first thing i tried was "ls -lRt | grep world.sav" which worked except i couldnt distinguish the files because there were no directories. that took a lot of looking till i accepted i couldnt make ls print directories as well and append them to the files somehow that their relationship would be clear. i tried piping ls to find, doing it in reverse, passing them from grep etc. etc. until i read some more stuff online that got me using gawk and sort. the questions:

1. is there some other, more elegant and simple way to do this kind of detection and sorting?

2. is there any way to use a pipe after using exec? the semicolon seems to prevent this entirely, forcing me to use an intermediate file as above. i could just remove it later, but i'd prefer a straight piping.

View 8 Replies View Related

Software :: VLC Won't Open OGG Files / Sort It?

Sep 12, 2010

Movie Player will open the same files but VLC will not. VLC will play videos and MP3s though.

View 6 Replies View Related

Programming :: BASH Sort List By End Of Line To X Position In Each Line?

Aug 18, 2010

I'm trying to make another file annotation script a little speedier than it has been by the up-until-now proven method of checking the last four characters in a filename before the "dot" (eg .jpg, .psd) against a list of known IPTC categories and Exiv2 command files. It occurred to me that if one script generated a list of files in directory foo, and the same or another script sorted that list by that four-letter tag,then that list could be used(instead of a for/do/done loop on the real files in the folder) by the command-file-matching script to "vomit out" which annotator file would go with file nastynewfile.jpg, f'r'instance. The script I had been using for this task looks like this:

Code:

while read 'line';
do
sp=$(echo $line)
vc=$(echo $sp | cut -d"," -f1)
cv=$(echo $sp | cut -d"," -f2)

[code]....

Where I seem to be stuck is with how to sort the lines in templist, which may be any number of different lengths, from back to front. sort -k looked promising, except it seems only to work the other way round. I thought of invoking a

Code:

q=$(expr length $line); echo $q
n=$[q-8]; echo $n

kind of thing, but that presented the problems of how to sort by those, how to tell sort where to find them (grep?) and how to "stitch them back in" to the original list, which is what I want to sort in the first place.

View 14 Replies View Related

Ubuntu :: Find / Sort And Produce List Of Files (Photos)

Sep 11, 2010

I have hard drive with several thousand photos. These photos are in different formats, some are tif some jpg some raw (cr2). These files are in dozens of directories. What I want to do is produce a list of all the files, in all of the directories, sorted by the file name (not sorting on the path), listing the location, file name, size and date created.
For instance I may have a file called photo1.jpg in /photos/pics/
I may also have a file called photo1.cr2 in /photos/misc/ and a file called photo1.tif in /photos/processed/summer/.

I would like a text file that would look like this:
/photos/misc/photo1.cr2 2536658 2010-07-09 13:17
/photos/pics/photo1.jpg 320046 2010-07-07 14:47
/photos/processed/summer/photo1.tif 234456689 2010-07-10 09:22
Of course I want it to do this for all of the photos. I pretty sure that there is a way to do this with a minimum amount of work. I have no problem with using the command line.

View 3 Replies View Related

Ubuntu Security :: Secure-delete Won't Work On Larger Files / Sort It?

Sep 16, 2010

I'm trying to clean a hard drive and I'm using secure-delete but it just stands there and takes cpu power but nothing happens, I used -r switch first and nothing, so I tried it on single files, small pictures worked as intended but a simple 50MB MPG file just stands there as well and nothing happens.

I left it running for 24 hours and nothing happened but the cpu was working at 90-100% all the time :/

Any one know what's wrong? I'm using 10.04 UNR

View 9 Replies View Related

Debian Installation :: Can't Download Files From Any Repositories / Sort It?

Apr 29, 2011

I am still having trouble installing Debian 6.0.1a (Squeeze) from either CD #1 (KDE version) or netinst version. I tried for a few months to install Squeeze with KDE desktop; now I am trying to build a server, which seems easier (no X.org and KDE problems to worry about.)

Part of the problem common to all my failed attempts (about a dozen!) seems to be that the installer tries to get packages or updates/upgrades from repos but for some reason fails.

I have a commercial all-in-one dslmodem/router/firewall which has very, very limited monitoring capabalities, just enough to show that the PC in question contacted the expected repos (I tried several in different regions) and also shows that no DNS requests failed during that time frame. I did try decreasing the security of the commercial firewall, but that seems to make no difference. I did try to save the install logs, but they didn't fit on a floppy. Any idea what could be going wrong?

View 5 Replies View Related

General :: Manually Sort Random Text Files?

Jun 6, 2010

I have about 1000 text files and I need to view each, and move it to a folder if it's the correct one. I can only do basic sorting by length/size, and I can't grep because the text is random. How can I do this besides manually openiing + saving each in gedit.I'm on Ubuntu Linux.I've already done all the sorting I can based on ize,wordcount,greps,date,etc. This is what's left over. I'm trying to find an easy way to view +save/ignore the rest.

View 6 Replies View Related

General :: .EXE Files - Cannot Get It To Install After I Double Click / Sort It?

Jan 25, 2010

I just downloaded a .exe file. I cannot get it to install after I double click on it. What should I do to make it work?

View 6 Replies View Related

Software :: Way To Sort A Files Based On Creation Time

Jul 7, 2010

Code...

But I want to get the files in order which they created like file, file1 and file2

Any way to obtain this?

View 6 Replies View Related

General :: Sort Big Files, /tmp/sortA3aLjF: No Space Left On Device

Aug 3, 2010

i'm sorting 8GB text file but came up with this error for an investigation

/tmp/sortA3aLjF: No space left on device

is there anyway that sort won't use /tmp?

View 3 Replies View Related

Software :: Looking For Easy Way To Rename MP3 Tags Then Sort Files Into Directories?

Aug 22, 2010

This might not be the right place to ask this question, but it's software so I'll try this before going to Audio-specific boards. I have a bunch of MP3s (some ogg) with crazy names in crazy directories. I would like to make sure the tags are correct (possibly by hand) and then rename them/move them so that they are in places like

<artist>/<directory>/<songname>.mp3.

So I imagine a magic program where I can edit tags and then push a magic button that makes directories and copies the files as above. Any ideas?

View 3 Replies View Related

General :: Save / Sort Files In Sequential Order Sector By Sectyor

Aug 26, 2010

I have a china phone which has mp3 player and unfortunately it reads the file names in its memory card in sequential order according where the file is saved. The file system is NTFS. cod

**Note: DDD song was last because I saved AAA to EEE songs then later added DDD song

Then suddenly i deleted BBB song and replaced it with FFF song code...

This is kinda lame. but the OS of the phone has no capability sorting the file according to filename in its built in mp3 player.

my question is how can I sort the files sector by sector(is my term right?) so the lame mp3 player would read the files finally in alphabetically sorted order. I Will plug my phone on my PC

I am using ubuntu 10.4

View 1 Replies View Related

Programming :: Sort Oldest 5 Files In A Directory Tree Recursively Based On Timestamp?

Jun 3, 2010

I have a directory listing with many subdirectories having many files. I want to recursively search for the oldest 5 files starting from the base directory and not 5 from each subdirectory. I am writing a shell script which sorts them using ls -lRtur|egrep "txt|jpg" > /tmp/file1 Now from this /tmp/file1 file I want to sort the files same as what the ls -ltr command does that is oldest file time to newest file time first. How do I sort based on Linux time stamp? The files itself also have Linux timestamps embedded in them So I can sort based after extracting them as well if it is easier.
My /tmp/file1 has entries like below.

-rw-rw-r--. 1 usr1 usr1 705 2010-01-22 17:25 sample20100603173659.jpg

I want to get the 5 oldest files and then delete them.

View 1 Replies View Related

Programming :: SORT Command Versus Unix SORT

May 4, 2010

We switched from unix to linux and we have an old report that extracted data from a database, output to an ascii file and then sorted the results in the file based on different arguments. The report now blows up when it runs,and I can only guess it is because the options for sort on linux differ slightly from unix.For example, here is one of the commands issued from within the report app that ran on the old unix box:

if sort-sequence = "descending" then
'sort -t~" -f +3.0f -4.0 +5.0r -6.0 -f '
else
'sort -t~" +3.0f -4.0 +1.0f -2.0 -f'

I will eventually rewrite the report to store the data in a local table, but I can simply adjust the options to suit the requirments of linux. Basically, I need to know if this can be a quick fix for the short term.

View 2 Replies View Related

Ubuntu :: Renaming Files Through Bash

Feb 10, 2011

I'm trying to rename ~11000 files. What has happened is I have files in the following format:

string1_100_string2_200_string3_300.log

now the numbers 200 and 300 are sometimes below 100 and the file looks like this:

string1_100_string2_99_string3_99.log

and I want to rename such files to be like this:

string1_100_string2_099_string3_099.log

I wrote a small matlab script but it seems to take forever so thought I'd try and do it bash and have got near to nowhere....

View 3 Replies View Related

Ubuntu :: Need To Make Bash Script Files

Apr 16, 2010

I need to know what is the best method for teaching yourself how to make bash script files

View 8 Replies View Related

Ubuntu :: Bash Script - Not Duplicate Files?

Sep 1, 2010

I am working through a collection of many thousand photographs in many collections, spanning decades. One of the folders is a "Selected_images" folder which should only contain copies of images from the collections.

How can I check that the files in "Selected_images" are all indeed copies and have an identical counterpart somewhere in the collections hierarchy, not necessarily with the same name?

At present I am scanning the output of fdupes -r collection, which is tedious (although, in fact, no photographs should ever be duplicated except in "Selected_images").

View 4 Replies View Related

Ubuntu :: Bash Copying Files From One Drive To Another?

Nov 15, 2010

I've got two external hard drives, a 2TB and a 320GB. I've recently come from Windows 7. On Windows 7 I wrote a batch file which checked whether both hard drives existed and then copied a couple of folders from the 2TB to the 320GB without overwriting. I've been trying to work out how to do the same under Linux without much luck. I've tried rsync but it looks like it overwrites. Does rsync overwrite?

If it helps, the batch file I wrote in Windows

if exist D:320GBDrive (if exist H:2TBDrive (xcopy H:2TBDrive* D:320GBDrive /I/E /-Y < C:decline_copy.txt))

Which basically checks for drive D:, checks for drive H: and then copies the contents of the folder on drive H to drive D and says no every time it asks to overwrite.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved