Hello,
I am running ubuntu 14.04. My purpose is to sort below file according to value of id even though it contains alphanumeric strings inside double quote. File is not tab separated. I am not sure that can be done...
mydata
Expected output:
What I tried:
Thank you
Boris
EDIT:
Hello,
I have solved somehow with a bit long way but it's okay now.
Then with grep and while read -r line loop.
Thanks
Boris
Last edited by baris35; 06-02-2019 at 06:40 PM..
Reason: solved
I wrote script in bash which generates this report:
User1,admin,rep,User2,shell,path1,x1,r1
User2,admin,rep,User7,shell,path1,x1,r1
User3,admin,rep,User4,shell,path1,x1,r1
User4,admin,rep,User3,shell,path1,x1,r1
User5,admin,rep,User1,shell,path1,x1,r1
User6,admin,rep,User5,shell,path1,x1,r1... (6 Replies)
Hi Guys,
I need help in modifying a large text file containing more than 1-2 lakh rows of data using unix commands. I am quite new to the unix language
the text file contains data in a pipe delimited format
sdfsdfs
sdfsdfsd
START_ROW
sdfsd|sdfsdfsd|sdfsdfasdf|sdfsadf|sdfasdf... (9 Replies)
Hi pls help me out to short out this problem
rm PAB113_011.out
rm: PAB113_011.out: override protection 644 (yes/no)? n
If i give y it remove the file.
But i added the rm command as a part of ksh file and i tried to remove the file. Its not removing and the the file prompting as... (7 Replies)
Hello all -
I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files... (3 Replies)
I have 2 files,
file01= 7 columns, row unknown (but few)
file02= 7 columns, row unknown (but many)
now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there
e.g.
file 01
James|0|50|25|10|50|30... (1 Reply)
Hi Experts,
I have a filelist collected from another server , now want to sort the output using date/time stamp filed.
- Filed 6, 7,8 are showing the date/time/stamp.
Here is the input:
#----------------------------------------------------------------------
-rw------- 1 root ... (3 Replies)
Hi I'm a UNIX awk and sed novice at best. I'm trying to creat a .csv file so it can be graphed in Excel. Tried various xargs, awk, sed and paste but just can't seem to get the data to line up. Not sure if this is beyond for a question in these forums. Any help would greatly be appreciated.
Have... (4 Replies)
Hi I would like to move the first 1000 rows of my file into an output file and then move the last 1000 rows into another output file.
Any help would be great
Thanks (6 Replies)
Hello!
I have a tab delimited file with values in three columns. Some values occur in all three columns, other values are present in only one or two columns. I would like to sort the file so that rows with no missing values come first, rows with one missing values come next, and rows with two... (9 Replies)
Discussion started by: MBarrett1213
9 Replies
LEARN ABOUT DEBIAN
fatsort
fatsort(1) General Commands Manual fatsort(1)NAME
FATSort - FAT filesystem sorting utility
SYNOPSIS
fatsort [options] device
DESCRIPTION
FATsort sorts directory structures of FAT filesystems. Many MP3 hardware players don't sort files automatically but play them in the order
they were transmitted to the device. FATSort can help here.
OPTIONS -c This option causes FATSort to ignore the case of filenames (e.g. 'example.mp3' is equal to 'EXAMPLE.MP3').
-f Force sorting even if the device is mounted or if FATSort cannot determine if the device is mounted.
-h Shows some help information.
-i Prints some file system information of the specified device.
-l FATSort will not sort directory structures, but just print the current order.
-o type
This options specifies how FATSort will sort files and directories. type can be 'd' for directories before files (which is the
default), 'f' for files before directories, or 'a' for no differentiation between files and directories.
-n Uses natural order to sort directory structures instead of alphanumeric order. For example, an alphanumeric order would be
file123.mp3
file21.mp3
file3.mp3
and the corresponding natural order would be
file3.mp3
file21.mp3
file123.mp3.
-q FATSort will work quietly without printing additional information messages.
-r Sorts the directories in reverse order (Z-A).
-R Sorts the directories in random order.
-v Shows version information only.
The following options can be specified multiple times:
-d directory
Sort directory only
-D directory
Sort directory and all subdirectories
-x directory
Don't sort directory
-X directory
Don't sort directory and all subdirectories
-I prefix
Ignore filename prefix prefix during sorting. For example, passing option -I "the " tells FATSort to sort 'The Beatles.mp3' like
'Beatles.mp3'.
EXAMPLES
Sort FAT filesystem on an USB stick:
fatsort /dev/sda1
Sort FAT filesystem in a file:
fatsort /home/user/fat16_fs.img
Sort directory /dir1 and all subdirectories except /dir1/dirA:
fatsort /dev/sda1 -D /dir1 -x /dir1/dirA
Ignore prefixes 'a ' and 'the ' during sorting:
fatsort /dev/sda1 -I "a " -I "the "
AUTHOR
Boris Leidner <fatsort(at)formenos.de>
SEE ALSO mount(8)fsck(8)NOTES
FAT12 is not supported yet.
REPORT BUGS
Please report bugs to fatsort(at)formenos.de. Thanks.
FATSort 0.9.15 2011 fatsort(1)