Categories
Conflict-Resolution

How to file alphabetically

This article was co-authored by Caitlin Jaymes. Caitlin Jaymes is a Closet Organizer and Fashion Stylist based in Los Angeles, California. With a background in Fashion PR and Fashion Design, she specializes in creating wardrobes for her clients with pieces they already own. She has experience working with celebrities, editorial shoots, and men and women of all ages. Caitlin uses fashion and organization to help instill and influence confidence, ambition, and stress-free lifestyles for all her clients. She runs her business by two guiding principles: “fashion has no rules, only guidance on how to look and feel your best” and “life has too many stressors, don’t let clutter be one of them.” Caitlin’s work has been featured on HGTV, The Rachael Ray Show, VoyageLA, Liverpool Los Angeles, and the Brother Snapchat Channel.

There are 7 references cited in this article, which can be found at the bottom of the page.

wikiHow marks an article as reader-approved once it receives enough positive feedback. In this case, several readers have written to tell us that this article was helpful to them, earning it our reader-approved status.

This article has been viewed 320,783 times.

Alphabetic filing is a fundamental way to organize documents that allows you to quickly store, access, and manage your personal and business files. By implementing alphabetical filing in your life, you will ensure all documents are protected and readily available. There are many rules on how to file alphabetically in English to preserve a sensible filing system. Luckily, it’s simple to get started with new documents and still is not a difficult change to make if you need to reorganize!

an admin’s blog about office stuff

NOTE: I’ve closed comments on this post due to the fact that it’s from 2012 and I’m tired of revisiting it. As many commenters have pointed out, filing practices vary depending on industry and different business preferences. You should not take anything I say as iron-clad rule; it’s based solely on my own experience. Your employers will have their own way of filing. Do it the way your boss wants. 🙂

As an admin, I’ve often had to do filing for the companies I’ve worked for. Various places may have very specific rules, such as medical files, which I haven’t been privy to, or filing by number either ascending or descending.

But there are standard alphabetical systems that most people use for client files. The most common—and the easiest—is unit-to-unit, which takes each part of the header into consideration. Generally, this process has some basic rules.

Everyone knows their alphabet, right? If you get confused (don’t worry, it can happen after a long night!), you can sing the little song:

Let’s say you have some folders with these headers:

  • 88 Company LLC
  • Bob Anders Corporation
  • W. L. Logistics
  • Plant Management Co.
  • Planters Welding
  • W. W. Lampe
  • The Camdenton Association

How in the world do you file these?

Numbers go first

88 Company LLC will go first. Don’t go by what the WORD begins with (i.e. eight, with an E). Searchers will look for the file header itself, not some hidden message there. So your system will start with numerical headers.

If you’re using an alphabetical system, you’ll file numbers in ascending order, that is smallest to largest, the same way you would proceed through the alphabet.

When you get to letters, initials go first within their letter designation.

W.L. Logistics and W.W. Lampe both begin with the letter W. Which one goes first? Well, L comes before W in the alphabet, so look at the initials first.

If you had W.W. Logistics and W.W Lampe, then you look past the identical letters to the first different one. Thus W.W. Lampe would go first, because La comes before Lo. The same is true for Plant Management Company and Planters Welding. E comes before M, so Planters Welding is first.

If a person’s name is part of the title, use the first letter of the first name

Bob Anders Corporation would be filed under B, not A. It’s part of the title. When someone refers to this company, they’ll say “Bob Anders Corporation,” or maybe just “Bob Anders.”

If you’re filing by the actual person’s name instead of a company, most systems will do it by the last name. So the header would look like this: Anders, Bob. Then he would go under A. Name-based files would look like this:

  • Acton, Catherine
  • Anders, Bob
  • Arrrrggghh, The Boss

NO NO JUST KIDDING DO NOT PUT THAT IN YOUR FILE SYSTEM IF YOU WANT TO KEEP YOUR JOB!

Ignore the article “the”

Where does The Camdenton Association go? Not under T, although I’ve seen people do this many, many times. File headers typically don’t begin with A or An, although technically if it’s part of the name, such as An Excellent Cupcake Baker, it would go under A.

Most systems ignore The because it’s so common. Pretend it isn’t there, and file them under C for Camdenton.

So how should the completed file batch appear?

  • 88 Company LLC
  • Bob Anders Corporation
  • The Camdenton Association
  • Planters Welding
  • Plant Management Co.
  • W. L. Logistics
  • W. W. Lampe

Easy peasy, lemon squeezy.

These are very simplified rules, and no doubt your company will have its own quirks. But the basics will usually apply, whether you’re using paper files or electronic ones.

When setting up a filing system, remember that everyone who needs to access it should know how to find whatever they need. So keep it simple, intuitive and smart.

For more detailed information, check out this cool .pdf from the McGraw-Hill Higher Education website.

Disclaimer: Before you start following these rules in the office, it’s a good idea to double-check with your employer about the alphabetizing rules followed in your company. There are different versions of filing rules so filing practices differ from company to company.

It’s important for every business to have their employee information, company records, and other important data maintained in a proper and systematic manner. The way most companies do this is by alphabetization. The process has quite a few benefits as well. For instance, having a standardized filing practice means documents will be easier to find, you can add or remove new entries without disturbing other entries, and alphabetization is an intuitive process so people other than employees can understand it as well.

There are three versions of alphabetical filing rules:

  1. Letter by letter: In this version, spaces between the words are disregarded.
  2. Word by word: Here, each word is filed on the basis of the first letter.
  3. Unit by unit: Here, each word, abbreviation, and initial is considered as a separate unit.

For this article, we’ll be focusing on the unit by unit version simply because it covers pretty much all the rules. Here we go:

Rule #1: File numbers first

Numbers go first. Arabic numbers (0-9) are indexed numerically before alphabetic characters. However, keep in mind that they are NOT spelled out. For instance, 21 Horses Inc. will come before 4 Horsemen Pvt Ltd. because we disregard the t and f in twenty and four respectively.

You’ll file numbers in the same way you would file alphabets – in ascending order – that is, smallest to largest.

If the numbers are spelled out, they’ll be treated as normal words and filed alphabetically.

Rule #2: Initials go next

Initials are considered separate units and are also filed alphabetically. So, if you have to file J.K. Smith and K. Nyugen, J.K. Smith would be filed first.

But what if the initials are same, like this: J.K. Smith and J.K. Nyugen. In this case, J. K. Nyugen will go first because we are looking at each letter (including the initials) by their designation. That means if the first letter of their surnames were same as well, we would then look at the second letter in their surname. So by that logic, J.K. Night would come before J.K. Nyugen.

Rule #3: Filing hyphenated names

How does one treat hyphenated names? It’s pretty simple – you treat hyphenated names as one unit. Whether it’s the first name, middle name or the surname that is hyphenated, it will be treated as one unit. However, the symbol in this case (the hyphen) is not considered a separate symbol and should be ignored.

Rule #4: Ignore the articles

Articles are words that describe the noun. In the English language, there are three articles: the, a, and an. You must ignore these while alphabetizing.

Example: When alphabetizing A Face and The Arm, The Arm will become before A Face.

Make sure you do not confuse the article “a” with an initial.

FYI: You can ignore articles when alphabetizing a list using the alphabetizer.

Rule #5: Spell out symbols

When symbols are part of a unit such as a name, they are spelled out. So $ is seen as Dollar and ! is seen as Exclamation Mark.

Alphabetize them as you would normal words.

Interested about learning more about how alphabetization works? Check out our article on History of Alphabetization.

The 12 Rules of Filing (Information organization & management)
(Based on Established Rules of ARMA)

Alphabetic Indexing Rules and Procedures

Define purpose of filing, and the importance of following filing rules.

Identify terms such as unit, indexing, alphabetizing, and case

Index and alphabetize data according to established ARMA rules

Every business must develop and maintain an organized way to store written communication, such as reports, letters, memorandums, order forms, invoices, and other such information so that it is available for efficient retrieval or reference. This method of storing records is called filing. While there are a number of different methods for storing or filing information � alphabetic, subject, numeric, and geographic – the most common method is the alphabetic filing system.

Procedures for storing records alphabetically will vary among organizations and even among departments within an organization. Therefore, the filing procedures to be used in any one office needs to be determined, recorded, approved, and followed, without exception. Without written rules for storing records, procedures will vary with time, changes in personnel, etc. These changes could cause difficulty in future retrieval of records or even in the loss of records.

The Association of Records Managers and Administrators, Inc. (ARMA) is an organization designed to help professionals in records management perform their jobs easier and better. ARMA has published a list of Alphabetic Filing Rules, containing standard rules for storing records alphabetically. The 12 rules you will learn in this chapter follow the same principles as the ARMA rules.

Basic Filing Terms

Before learning the 12 filing rules, an understanding of filing terms is necessary.

Alphabetizing Unit by Unit. The first step in alphabetizing is to alphabetize Unit by Unit. If the names in Unit 1 are exactly the same, then continue to alphabetize by Unit 2. If the first and second units are the same, the next step is to alphabetize Unit 3, and so on.

  • ‘)” data-event=”social share” data-info=”Pinterest” aria-label=”Share on Pinterest”>
  • ‘)” data-event=”social share” data-info=”Reddit” aria-label=”Share on Reddit”>
  • ‘)” data-event=”social share” data-info=”Flipboard” aria-label=”Share on Flipboard”>

Related

  • What Type of Attorney Is Needed When Starting Up a Nonprofit Organization?
  • How to Write a Cover Letter for a Radiology Technologist
  • How to Format a Header for a Two Page Resume
  • How to Design a Signature
  • What Is Open Punctuation in a Business Letter?

Business information that arrives in digital form requires no manual processing rules since the information can be sorted and accessed with various software applications. Paper documents, such as letters, purchase orders and reports, must occupy a physical location. Clerks must follow consistent filing rules and procedures storing written documents if they want to find the information again. The University of Idaho lists 12 rules on its website established by the Association of Records Management and Administration (ARMA). They answer most questions about filing rules and procedures.

Alphabetical Order Rules for Names

The names of individuals are indexed alphabetically by using their last names first, their first names or initials, and finally their middle initials or names. An initial or name using just one letter comes before a complete name starting with the same letter. If a last name consists of two or more words, divided by a space, as in “Van Owen,” index the name as if were one word, such as “VanOwen.”

As explained in the Chicago Manual of Style, you ignore the hyphen when filing a name such as “Cruz-Smith.” Simply file as you would if the name were spelled “Cruzsmith.” Index by titles, such as “MD” or “Father,” only after indexing through the last, first and middle names.

Alphabetical Order Rules for Businesses

Unless names are government oriented, index the names of organizations as they are written on letterheads; however, ignore punctuation marks. Abbreviations are not spelled out, and personal titles remain in the first position. For example, “Dr. Johnson’s Repair” is filed under “Dr” and not “Doctor,” which is considered the first part of the title. The word “Johnson’s” should be filed as “Johnsons.” Definite and indefinite articles such as “The” are considered the last word of the title. “The Dachshund Store” is indexed as “Dachshund Store The.” Single letters separated by spaces are indexed as individual words so “A K Company” is filed before “Ace Office.” Acronyms, such “IBM” or “GE” are filed as one word.

Non-Alphabetical Filing Rules and Procedures

Smead, a manufacturer of filing and organization supplies, points out that numerical filing can be a more efficient method for very large filing systems, since there are less possibilities for mistakes compared to alphabetic systems. Files can be indexed according to account numbers; transaction numbers; product, part, SKU or UPC numbers; or case numbers.

Arabic numbers (such as 0 through 9) are not spelled out but are indexed numerically before alphabetic characters. Roman numerals (I, V, XIX) are indexed after all Arabic numbers but before words. Spelled out numbers are treated as ordinary words. The following example combines these rules: “1 Stop Shopping,” “XXI Theater” and “Twenty Second Repair.”

The filing rules and procedures for symbols require that those which are part of names be indexed as if they were spelled out. For example “&” is indexed as “AND” and “$” is seen as “DOLLAR.” When appearing with numbers, the symbol is spelled out and attached to the number, so that “#1” becomes “NUMBER1.”

Things You’ll Need

  • Alphabetic separators
  • File folders
  • Pen or marker

Many offices create multiple file folders each day to keep track of clients or patients. All of these files must be stored in a way that make it easy to find the next time. Alphabetic filing is the simplest and most traditional way to store files. Keep alphabetic files in your office and you will have no problem retrieving information every time your patient walks in the door.

Insert alphabetic separators into your file drawer. These separators are generally large file folder holders with a tab that sticks up on top of the folder. Each tab will have a letter of the alphabet on it, indicating which file should be stored within its space.

Separate out your folders into piles. Each pile should be for one letter of the alphabet. All the files beginning with the letter “A” should be in the first pile, and so on.

Organize the “A” pile in alphabetical order. Begin with the second letter in the file name. Place the “Aa” files first, then the “Ab” files, then the “Ac” files and continue on in this manner. If there is more than one file with a two-letter designation, put them in order according to the third letter in the name.

Place all of the “A” files into the “A” file holder in the file drawer. Do the same with all of the other letters of the alphabet and their corresponding files.

Add any new files in the correct place in each file holder. Do not simply place new “B” files in the front in the “B” holder. Search through the file in order to find the correct place in the collection of files to store the new file.

Make sure to mark each file folder using the same system. All patients must have last name and first name, or all house listings filed by street name, for example, are good ways to mark each file.

Table of Contents

What is the proper way to file alphabetically?

The general rule for filing alphabetically is to arrange items in order from A (first) to Z (last). Use increasingly specific information to distinguish between and order separate items.

How many rules are there for alphabetical filing?

There are three versions of alphabetical filing rules: Letter by letter: In this version, spaces between the words are disregarded. Word by word: Here, each word is filed on the basis of the first letter. Unit by unit: Here, each word, abbreviation, and initial is considered as a separate unit.

What comes first alphabetically Mc or Mac?

Letter by letter: They also largely ignore distinctions among different punctuation marks and do not distinguish among the types of access points. In these rules, for example, names beginning with M’, Mc, and Mac are filed alphabetically as spelled.

Do you count the in alphabetical order?

In APA Style, alphabetization is easy as long as you remember these simple rules: Alphabetize letter by letter. Ignore spaces, capitalization, hyphens, apostrophes, periods, and accent marks. When alphabetizing titles or group names as authors, go by the first significant word (disregard a, an, the, etc.)

Do you file by last name or first name?

When it is impossible to distinguish the first or last name, or if confusion lies in the arrangement of a name, it is filed as it is written with the last name as the first filing unit while creating a crossreference from the first name. Hyphenated and compound last names are treated as one unit.

Do you alphabetize by first or second last name?

A. In the absence of a hyphen, alphabetize by the final name. Since it’s usually not possible to know for certain the origin of the name in the middle, it is treated as a middle name (not a surname) by default.

How do you alphabetize for file and indexing?

When indexing the name of an individual, arrange the units in this order: last name as Unit 1, first name or initial as Unit 2, and middle name or initial as Unit 3. When two names in Unit 1 begin with the same letter, you consider the next or second letter in arranging for alphabetical order.

Why is the D in McDonald’s capitalized?

Donald is the name so D will be the uppercase as it is the beginning of the word. It wasn’t originally a lastname. The “Mc” means “son of”, from Mac in Gaelic languages. Son of Donald and for whatever reason, they chose McDonald instead of Mcdonald.

Where do MC names come in alphabetical order?

The conventional way to alphabetize names that start with these prefixes is to treat Mac and Mc the same. Names that start with Mc are treated as though they were spelled Mac. In effect, “Mc” has an invisible “a” between the “M” and “c”.

Should APA references be alphabetical?

Is APA reference page in alphabetical order? Yes, an APA reference page is listed in alphabetical order by the author’s last name. When you have authors with the same last name, you alphabetize them by the first or middle initial.

On my Xubuntu install, in some folders, if I list all the files with ls -U , sometimes they are not listed in alphbetical order. For example, once I had it list every single file in alphabetical order except one single file that came before all the others (it started with the letter g and it came before the a ‘s. All the other g ‘s were in the place I expected them to be in).

How does ls -U decide the order to list files in?

3 Answers 3

-U do not sort; list entries in directory order

Otherwise the default behavior is

Sort entries alphabetically if none of -cftu‐ vSUX nor –sort is specified

Directory order refers to the order in which the files are internally stored in the file system. Different FS:s use different criteria, so the order depends on the FS itself.

How to file alphabetically

According to man ls , the -U option forces ls to use the directory order in listing the files.

Answers saying -U means “do not sort; list entries in directory order” are right, but the phrase “directory order” or more descriptive “the order in which the files are internally stored” is misleading in some cases.

Some filesystems (virtual or FUSE) do not store anything, they retrieve data on demand. The order you get from ls -U in a filesystem like this may be random(-ish).

Imagine a filesystem that aggregates files from several remote servers in one local directory. Let’s assume name collisions are not an issue. To list the files as fast as possible the filesystem queries the servers asynchronously, whichever server delivers its listing first will be listed first. Conditions in the network and on the servers can certainly affect how fast and in what order the responses get to the local computer, therefore they will affect the order of files. It’s possible to build such filesystem. In it there is no internal storage and there is no strict order; so there is certainly no order in which all the files you observe are internally stored.

ls -U uses the order the filesystem returns. If the filesystem stores the files internally then most likely it will return an array reflecting the internal order (whatever this means for this particular filesystem); but it may not. In general the order may depend on anything.

How Do You File In Alphabetical Order : Useful Links

the same, file in terms of the second letter, and so on. Butterfield. Butternuts

If you’re using an alphabetical system, you’ll file numbers in ascending order, that is smallest to largest, the same way you would proceed .

Order files alphabetically according to their indexed name. The general rule for filing alphabetically is to arrange items in order from A (first) to Z (last). Use .

When two names in Unit 1 begin with the same letter, you consider the next or second letter in arranging for alphabetical order. If both the first and second letters .

Seeley, is the classic guide to filing catalog cards using the basic order of alphabetical, “word-by-word” rules. They retain provisions for observing .

The listFiles method, with or without a filter does not guarantee any order. It does, however, return an array, which you can sort with Arrays.sort() .

Open the folder or library that you want to sort in the File Explorer. · Go to View on the top and expand the View ribbon by double clicking on it. Click Sort by, and .

There are three versions of alphabetical filing rules:

The arrangement (or “filing”) rules currently used in American library catalogs, .

Order each manila file folder for each category alphabetically by the last name or company name. When done, you’ll have separate piles in alphabetical order.

With “ls” the following files are sorted as I want as:

but in file manager (I have tried nautilus, nemo and pcmanfm) they are sorted as:

At this article says you can affect sort order in file browser using:

But I tried this and the sort order is still the same – numerically not alphabetical.

Is there away of getting any file manager to sort as ls does by some option in preferences or by setting a variable such as LC_COLLATE ?

Extra information on why files are sorted numerically for those interested :

the reason given for sorting numerically goes something like a user expects the following files to be ordered numerically like:

and not alphabetically like:

and where as I can see this point:

    If files are ordered alphabetically, then you simply need to pad files with a zero, to make them ordered numerically (easy to script using printf “%03d” ), but there is nothing you can pad files that are ordered numerically to order them alphabetically.

It is not obvious how the files ordered numerically at the top of this post are sorted – I spent 30 mins creating various files and could not figure out how they were being sorted and had to resort to Google to work it out, where as it is a lot easier to workout that “numbered” files like 10,101,11,8,9 are ordered alphabetically.

Even AFTER I knew files were ordered numerically it still took a while to understand, and hard to locate the files I wanted (I have over 70 files to look through) – point in case is the comment by “muru” who says they couldn’t see how 08f comes before 026 numerically and they have a reputation of over 100,000, so is clearly very intelligent. In contrast, when you know files are ordered alphabetically it is easy to understand how the “numbered” files are sorted and easy to locate them.

I don’t mind the default being to sort numerically in a file browser as long as there is an option to change default to sort alphabetically, so surely there is a file manager that has this option or that uses “LC_COLLATE”

Índice de contenidos

What command is used to sort the lines of data in a file in alphabetical order?

The sort command is a command line utility for sorting lines of text files. It supports sorting alphabetically, in reverse order, by number, by month and can also remove duplicates.

How do I sort the lines of a file in Unix?

Unix Sort Command with Examples

  1. sort -b: Ignore blanks at the start of the line.
  2. sort -r: Reverse the sorting order.
  3. sort -o: Specify the output file.
  4. sort -n: Use the numerical value to sort.
  5. sort -M: Sort as per the calendar month specified.
  6. sort -u: Suppress lines that repeat an earlier key.

How is data arranged in sort command?

To sort in alphabetical order:

  1. Select a cell in the column you want to sort by. In this example, we’ll sort by Last Name. …
  2. Select the Data tab, then locate the Sort and Filter group.
  3. Click the ascending command to Sort A to Z or the descending command. …
  4. The data in the spreadsheet will be organized alphabetically.

How do you sort data in Linux?

How to Sort Files in Linux using Sort Command

  1. Perform Numeric Sort using -n option. …
  2. Sort Human Readable Numbers using -h option. …
  3. Sort Months of an Year using -M option. …
  4. Check if Content is Already Sorted using -c option. …
  5. Reverse the Output and Check for Uniqueness using -r and -u options.

How do I sort files?

Sort Files and Folders

  1. In the desktop, click or tap the File Explorer button on the taskbar.
  2. Open the folder that contains the files you want to group.
  3. Click or tap the Sort by button on the View tab.
  4. Select a sort by option on the menu. Options.

How do you use sort?

Sort by more than one column or row

  1. Select any cell in the data range.
  2. On the Data tab, in the Sort & Filter group, click Sort.
  3. In the Sort dialog box, under Column, in the Sort by box, select the first column that you want to sort.
  4. Under Sort On, select the type of sort. …
  5. Under Order, select how you want to sort.

What does sort do python?

Python sorted() Function

The sorted() function returns a sorted list of the specified iterable object. You can specify ascending or descending order. Strings are sorted alphabetically, and numbers are sorted numerically. Note: You cannot sort a list that contains BOTH string values AND numeric values.

How do I sort files by name in Linux?

If you add the -X option, ls will sort files by name within each extension category. For example, it will list files without extensions first (in alphanumeric order) followed by files with extensions like . 1, . bz2, .

How do you sort by date?

Drag down the column to select the dates you want to sort. Click Home tab > arrow under Sort & Filter, and then click Sort Oldest to Newest, or Sort Newest to Oldest.

Whats is sorting?

Sorting is any process of arranging items systematically, and has two common, yet distinct meanings: ordering: arranging items in a sequence ordered by some criterion; categorizing: grouping items with similar properties.

What is a ascending order?

Ascending Order. Ascending Order. Arranging numbers (or other items) in ascending order means to arrange them from smallest to largest. Example 1 (with Numbers) The numbers 12, 5, 7, 10, 1, 160 arranged in ascending order are 1, 5, 7, 10, 12, 160.

How do I sort a filename in Unix?

The sort command sorts the contents of a file, in numeric or alphabetic order, and prints the results to standard output (usually the terminal screen). The original file is unaffected. The output of the sort command will then be stored in a file named newfilename in the current directory.

How do I sort log files in Linux?

If you want to sort the lines in chronological order, you would omit this option. The –key=1,2 option tells sort to only use the first two whitespace-separated “fields” (the “freeswitch. log:”-prefixed date, and the time) as the key for sorting.

What does sort mean in Linux?

In computing, sort is a standard command line program of Unix and Unix-like operating systems, that prints the lines of its input or concatenation of all files listed in its argument list in sorted order. Sorting is done based on one or more sort keys extracted from each line of input.

As we already mentioned, by default, the ls command is listing the files in alphabetical order. The –sort option allows you to sort the output by extension, size, time and version: –sort=extension (or -X ) – sort alphabetically by extension.

How do I list files in alphabetical order?

Replies (24) 

  1. Open the folder or library that you want to sort in the File Explorer.
  2. Go to View on the top and expand the View ribbon by double clicking on it. Click Sort by, and then select Name, then click Ascending.

How does Linux sort file names?

By default, the ls command sorts by name: that is file name or the folder name. By default the files and folders are sorted together. If you prefer to sort the folders separately and be displayed before the files, then you can use the –group-directories-first option.

How do I list files in Linux?

See the following examples:

  1. To list all files in the current directory, type the following: ls -a This lists all files, including. dot (.) …
  2. To display detailed information, type the following: ls -l chap1 .profile. …
  3. To display detailed information about a directory, type the following: ls -d -l .

How do I sort files in a folder in Linux?

Simply open the Nautilus File Manager and click on the Files menu in the top bar.

  1. Then select the Preferences option from the File menu; this will open the Preferences window in the “Views” view. …
  2. Select the sort order through this view and your file and folder names will now be sorted in this order.

How many ways are there to sort a list of files?

There are four ways you can sort a list of your files in Google Drive:

  • Name: Orders files alphabetically by filename.
  • Last modified: Orders files by the last time anyone changed a file.
  • Last modified by me: Orders by the last time you changed a file.
  • Last opened by me: Orders by the last time you opened a file.

How do I sort files by Name?

To sort files in a different order, click the view options button in the toolbar and choose By Name, By Size, By Type, By Modification Date, or By Access Date. As an example, if you select By Name, the files will be sorted by their names, in alphabetical order. See Ways of sorting files for other options.

How do you sort a list in Unix?

Unix Sort Command with Examples

  1. sort -b: Ignore blanks at the start of the line.
  2. sort -r: Reverse the sorting order.
  3. sort -o: Specify the output file.
  4. sort -n: Use the numerical value to sort.
  5. sort -M: Sort as per the calendar month specified.
  6. sort -u: Suppress lines that repeat an earlier key.

How do I list only directories in Linux?

How can I list directories only in Linux? Linux or UNIX-like system use the ls command to list files and directories. However, ls does not have an option to list only directories. You can use combination of ls command, find command, and grep command to list directory names only.

How do I sort a filename in Unix?

The sort command sorts the contents of a file, in numeric or alphabetic order, and prints the results to standard output (usually the terminal screen). The original file is unaffected. The output of the sort command will then be stored in a file named newfilename in the current directory.

How do I use find in Linux?

The find command is used to search and locate the list of files and directories based on conditions you specify for files that match the arguments. find command can be used in a variety of conditions like you can find files by permissions, users, groups, file types, date, size, and other possible criteria.

How do I list files in UNIX?

In computing, ls is a command to list computer files in Unix and Unix-like operating systems. ls is specified by POSIX and the Single UNIX Specification. When invoked without any arguments, ls lists the files in the current working directory.

How do I view .files in Linux?

The easiest way to show hidden files on Linux is to use the ls command with the “-a” option for “all”. For example, in order to show hidden files in a user home directory, this is the command that you would run. Alternatively, you can use the “-A” flag in order to show hidden files on Linux.

Ship69

How can I set up my Windows Explorer view such that in the right hand pane:

1. At the top of the pane, I see the list of folders. Ideally this should be sorted in alphabetic order [or else order in which last accessed?]

2. Then I want to see my files sorted by date last modified (or date last saved. or even date last accessed)

Background
If I sort just by “Date”, although the folders will appear at the top, and although the files below them are sorted by when they were last saved, the folder are always sorted by their time of creation – which is deeply irritating!

PS I have it in my mind that what I see used to be the default view in previous versions of Windows, but if it cant be done are there any freeware/freemium applications that can be used as a replacement for Windows Explorer?

Attachments

Advertisements

Wolfie

  • Jul 1, 2020
  • #2
  • I really don’t know the answer as I think you can either have folder view or file type or last access?, there are alternatives at the following link but the usual warning “USE AT YOUR OWN RISK” and I have not used any of them.

    How to file alphabetically

    8 Best File Manager Alternative for Windows 10 [2019]

    Ship69

    • Jul 1, 2020
  • #3
  • Hmmm. I really don’t WANT to use any of these things.

    Are we sure that after all this time, Windows Explorer really is so stupidly designed as to not be able to deliver what I seek?

    Wolfie

    • Jul 1, 2020
  • #4
  • We are talking about Microsoft here so most likely yes?.

    There isn’t much in the view settings to change.

    Ship69

    • Jul 1, 2020
  • #5
  • Wolfie

    • Jul 2, 2020
  • #6
  • sorry but I don’t know what the default settings are?, there is a button in View > Sort by > Group by but it doesn’t react when I click it?.

    Advertisements

    Rainlover

    • Jul 2, 2020
  • #7
  • Create two new columns on the far left. Populate them with the data that you require to sort on.
    Sort by these columns then hide them.
    You will have to do some pretty stuff like create a template to save to that already has the sorting included. A simple macro might help.
    Good luck. As I said untested.

    Ship69

    • Jul 2, 2020
  • #8
  • Create two new columns on the far left. Populate them with the data that you require to sort on.
    Sort by these columns then hide them.

    Is it possible to sort on TWO columns at once? (Holding down any of the control/shift/alt keys and then hitting the a second column header doesn’t seem to do anything.

    Either way, what fields would I use, because I want the Folder name to be alphetical, but the dates (of last save) to be in date order.

    Btw, I am amazed at how many different fields Windows10 appears to be providing use for each file. I’m guessing something like 200! Most of them are blank. Some of them seem to be duplicates – e.g. there are three ‘Status’ fields.

    Bighorn

    • Jul 3, 2020
  • #9
  • Wolfie

    • Jul 3, 2020
  • #10
  • In the post from @Bighorn , there is a suggestion to use “Total Commander” and/or something like it. Total Commander is not free but there are a couple in the link below but I have no idea how good they are?.

    How to file alphabetically

    Total Commander Alternatives: 25+ Similar File Managers | AlternativeTo

    Rainlover

    • Jul 4, 2020
  • #11
  • I am having problems with this.
    You have not given a lot of information as to why you want this.
    If you used MS Access as a reporting tool you could do some wonderful things, but do you know how to program. In fact I would think that that would be the best solution that I can think of.
    Where is your data now? Is the data been typed directly into Excel.
    There could be lots of alternatives for you to use but it all depends on what is the origin of the data.

    At this stage I have little to add but I will watch this post to see what is happening.

    Advertisements

    Ship69

    • Jul 20, 2020
  • #12
  • > You have not given a lot of information as to why you want this.

    It’s pretty simple:
    1. I want to have always see all the folders at the top of the screen, because that helps me navigate up and down the folders hierarchy by clicking on folder names.

    2. I want to see the files that I edited most recently because they are the files that I am most likely to want to edit again.

    No, I don’t want to install anything complicated.

    > Where is your data now? Is the data been typed directly into Excel.
    eh? My data is in side files of all manner of data types. (e.g. images, ms Word, ms Powerpoint, ms Excel, but also mind maps, Xara Designer, raw text, CVS. ).

    To recap, I am trying work out how to navigate up and down my folders and open up my general business documents.

    How to file alphabetically

    Original file ‎ (1,356 × 928 pixels, file size: 80 KB, MIME type: image/png )

    Captions

    Captions

    Summary Edit

    USSR Republics, numbered alphabetically.

    Post-Soviet states in English alphabetical order:

    1. Armenia
    2. Azerbaijan
    3. Belarus
    4. Estonia
    5. Georgia
    6. Kazakhstan
    7. Kyrgyzstan
    8. Latvia
    9. Lithuania
    10. Moldova
    11. Russia
    12. Tajikistan
    13. Turkmenistan
    14. Ukraine
    15. Uzbekistan

    Licensing Edit

    Derivative works Edit

    Carte de l’Union des Républiques Socialistes Soviétiques

    File history

    Click on a date/time to view the file as it appeared at that time.

    Date/Time Thumbnail Dimensions User Comment
    current 03:40, 3 August 2009 1,356 × 928 (80 KB) Hoshie (talk | contribs) Added border for N. Ireland; spilit Germany so that this map dates from 1988-89
    21:06, 10 October 2008 1,356 × 928 (52 KB) Milosevo (talk | contribs) <>
    03:38, 15 April 2005 1,356 × 928 (46 KB) Aris Katsaris (talk | contribs) USSR Republics, numbered alphabetically. Created by User:Aris Katsaris, based on Image:Soviet Union Map.png, in mimicry of the concept of en:Image:Soviet republics.jpg. <> Category:Political divisions of the Soviet Union [[Categor

    You cannot overwrite this file.

    File usage on Commons

    The following 13 pages use this file:

    File usage on other wikis

    The following other wikis use this file:

    • Usage on af.wikipedia.org
      • Sowjetunie
      • Republieke van die Sowjetunie
      • Selfbeskikking
      • Ontbinding van die Sowjetunie
    • Usage on als.wikipedia.org
      • Sowjetunion
    • Usage on ar.wikipedia.org
      • دول ما بعد الاتحاد السوفيتي
    • Usage on ast.wikipedia.org
      • Federación
      • Disolución de la Xunión Soviética
      • Repúbliques de la Xunión Soviética
      • Estaos postsoviéticos
    • Usage on avk.wikipedia.org
      • TSSS
    • Usage on azb.wikipedia.org
      • شوروی
    • Usage on ban.wikipedia.org
      • Republik ring Uni Soviet
    • Usage on bar.wikipedia.org
      • Sowjetunion
    • Usage on be-tarask.wikipedia.org
      • Саюз Савецкіх Сацыялістычных Рэспублік
    • Usage on bg.wikipedia.org
      • Съюз на съветските социалистически републики
      • Съюзни републики на СССР
      • Постсъветско пространство
      • Разпадане на Съветския съюз
    • Usage on bn.wikipedia.org
      • চিত্র:সাবেক সোভিয়েত প্রজাতন্ত্র.png
    • Usage on br.wikipedia.org
      • Unaniezh ar Republikoù Sokialour Soviedel
    • Usage on bs.wikipedia.org
      • Mihail Gorbačov
      • Raspad Sovjetskog Saveza
    • Usage on ca.wikipedia.org
      • Unió de Repúbliques Socialistes Soviètiques
      • Estats postsoviètics
      • Repúbliques de la Unió Soviètica
      • Dissolució de la Unió Soviètica
    • Usage on ckb.wikipedia.org
      • یەکێتیی سۆڤیەت
    • Usage on cs.wikipedia.org
      • Republiky v Sovětském svazu
      • Postsovětské republiky
      • Postsovětské války
    • Usage on cv.wikipedia.org
      • Совет Социализм Республикисен Пĕрлешĕвĕ
    • Usage on cy.wikipedia.org
      • Cyn-weriniaethau’r Undeb Sofietaidd
    • Usage on da.wikipedia.org
      • Sovjetunionen
      • Bruger:Rasmus81/Sandkasse2
      • Jødiske autonome oblast
      • Russiske SFSR
      • Sovjetrepublik
      • Karelsk-finske SSR
      • Lettiske SSR
      • Skabelon:Navboks Sovjetunionens administrative inddeling
      • Hviderussiske SSR
      • Ukrainske SSR
      • Karelske ASSR
      • Autonome Socialistiske Sovjetrepublikker i Sovjetunionen
      • SNG ved OL
      • Georgiske SSR
      • Armenske SSR
    • Usage on de.wikipedia.org
      • Unionsrepublik
      • Geschichte der Sowjetunion

    Metadata

    This file contains additional information such as Exif metadata which may have been added by the digital camera, scanner, or software program used to create or digitize it. If the file has been modified from its original state, some details such as the timestamp may not fully reflect those of the original file. The timestamp is only as accurate as the clock in the camera, and it may be completely wrong.

    I have a file with content like this:

    i need to sort all names alphabetically
    I tried many ways from the Internet, the last one looked like this:

    But it displays only the contents of a file in a list, how to sort alphabetically?

      1Answer 0 Followers 0

    Answer

    1 Answer

    I tried many ways from the Internet, you say …
    Then you need to turn on your head and think for yourself. And to begin with, break down the task into subtasks.
    Task number 1: read the contents of the input file.
    Task number 2: turn the read string into a list of items for sorting
    Task number 3: sort the list by the desired criterion
    Task # 4: write the sorted list to the output file.

    Now, point by point.
    # 1. The mistake you made is that .readlines () creates a list where each line is one element. You have all the elements of a list on one line, so readlines () won’t help you. We just use .read ()

    # 2. We google work with strings in python. The biggest question is: can a comma appear in a name? If not, then everything is solved very simply:
    items = content.split(‘,’)
    This will give us a list of strings, but with three caveats.
    1) the last comma will give us a list item – an empty string.
    If this is unacceptable, then you should get rid of empty lines:

    2) Lines in lists will be quoted. This will not affect the sorting, but if you need to get rid of them, you will need one more step.
    3) If there is a line feed \ n at the end of the line, then you need to get rid of it before splitting: content = content.rstrip()

    No. 3. Sorting the list right in place: items.sort (). Unlike the .sort () method, sorted () creates and returns a new sorted list without touching the old one. Descending if needed items.sort (reverse = True).

    No. 4. content = ‘,’.join(items) to glue the items back together. If the last comma is needed, then content = (‘,’.join(items)) + ‘,’ . .join () is more efficient than the manual for loop.
    Well, write to the file:

    If you’ve looking for a tool to help you sort a load of documents in alphabetical order then look no further than Bundledocs. Sorting documents is done with a single click and updates are instant. Ready to take a look at how it works? Then keep on reading…

    How to file alphabetically

    Regardless of what you are producing – whether its documents for court, tribunal or your upcoming board meeting, sorting documents can be a really time intensive exercise. Not the case with Bundledocs. We make it incredibly easy to sort large numbers of files instantly. Don’t believe us? Why not avail of our free 30-day trial and give it a go for yourself.

    These are the steps you need if you’re looking to sort documents in alphabetical order.

    Enable Dates. The first thing you need to do is enable the document dates to appear on-screen. This is not the default and can be easily switched on. Simply select the ‘Edit Details’ option and choose to ‘Show Document Dates on Screen’. Once this option is selected we will be able to see, at a glance, our document dates and more importantly our sorting options.

    Arrange Documents Alphabetically. Sorting document in description order can be done with a single click. Select the arrow icon to sort either ascending or descending order.

    If you’re having trouble viewing our ‘How to Sort Documents by Description‘ video (above) then head over to our YouTube channel to check it out.

    That’s it. Your documents will be instantly arranged in alphabetical sequence. Need to amend or change the document name? No problem. All you need to do is double-click.

    Bundledocs makes the creation of bundles incredibly quick and easy. If you’re interested to see how Bundledocs can help you streamline document production then get in touch. We offer free online demonstrations, a free 30-day trial or are on-hand to answer any questions you have. What are you waiting for? Get in touch with our helpful and friendly team today!

    GarryP

    Advertisements

    Peter T. Daniels

    • Apr 6, 2014
  • #2
  • This isn’t a question about MSWord.

    Open (double-click on) a folder.

    Near the upper right, below the window where the folder’s url appears, are
    three icons. The right-hand one is the Help button. Next to the left one
    is a down-arrow. Click that arrow and you get a number of ways of showing
    the files in that folder. Choose “Details.”

    When your files are displayed in the window by name, you can click on the
    header of any of the columns to order them by Name, Date, Size, etc. Click
    the same header again and they go in the opposite order — Z to A, or oldest
    to newest, etc.

    Whichever order you choose in Details carries over to the other views
    of that folder.

    Ask a Question

    Want to reply to this thread or ask your own question?

    You’ll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

    Similar Threads

    Temp files saving in word & alphabetical filing 1 May 10, 2010
    Temp files saving in word & alphabetical filing 1 May 10, 2010
    Saved word files 1 Oct 3, 2008
    how do you alphabetize files within a folder? 2 Aug 6, 2008
    Automatic Alphabetizing Files and Folders 3 Feb 1, 2007
    file i-r.htm rehabilitation 0 Jan 23, 2017
    Word 2003 won’t exit 8 Apr 28, 2019
    How do I return my Open file list to alphabetical order? 1 Jan 17, 2007
    • Forums
    • Archive
    • Newsgroup Archive
    • Word Newsgroups
    • Word Documents

    We’re a friendly discussion community for Microsoft Office help and support. All of the individual suite applications are supported here, so please post your question in the relevant section for help.

    How do you sort the entries in a text file in ascending order in Linux?

    How to Sort Files in Linux using Sort Command

    1. Perform Numeric Sort using -n option. …
    2. Sort Human Readable Numbers using -h option. …
    3. Sort Months of an Year using -M option. …
    4. Check if Content is Already Sorted using -c option. …
    5. Reverse the Output and Check for Uniqueness using -r and -u options.

    How do I sort files alphabetically?

    Replies (24) 

    1. Open the folder or library that you want to sort in the File Explorer.
    2. Go to View on the top and expand the View ribbon by double clicking on it. Click Sort by, and then select Name, then click Ascending.

    How do I sort a text file?

    Sort a text file, or selection of lines

    To do this, click the Edit tab, then click the Sort button near the end. Clicking Sort will cause the entire file to be sorted, line-by-line, with the last-used sort options.

    How do you sort a file in Unix?

    Unix Sort Command with Examples

    1. sort -b: Ignore blanks at the start of the line.
    2. sort -r: Reverse the sorting order.
    3. sort -o: Specify the output file.
    4. sort -n: Use the numerical value to sort.
    5. sort -M: Sort as per the calendar month specified.
    6. sort -u: Suppress lines that repeat an earlier key.

    What is the output of who command?

    Explanation: who command output the details of the users who are currently logged in to the system. The output includes username, terminal name (on which they are logged in), date and time of their login etc. 11.

    What does the following command do sort Myfile sorted file?

    Overview. sort is a simple and very useful command which will rearrange the lines in a text file so that they are sorted, numerically and alphabetically. By default, the rules for sorting are: Lines starting with a number will appear before lines starting with a letter.

    How do I sort a folder by name in alphabetical order?

    To sort files in a different order, click the view options button in the toolbar and choose By Name, By Size, By Type, By Modification Date, or By Access Date. As an example, if you select By Name, the files will be sorted by their names, in alphabetical order. See Ways of sorting files for other options.

    How do you use the sort command?

    SORT command is used to sort a file, arranging the records in a particular order. By default, the sort command sorts file assuming the contents are ASCII. Using options in sort command, it can also be used to sort numerically. SORT command sorts the contents of a text file, line by line.

    How do I sort a text file in CMD?

    The command produces a sorted list of lines that contain the specified text. Then type the text that you want sorted, and press ENTER at the end of each line. When you have finished typing text, press CTRL+Z, and then press ENTER. The sort command displays the text you typed, sorted alphabetically.

    How do I sort large text files?

    The only viable option for sorting very large files efficiently is to split them, sort the individual parts in parallel and merge them. This splits the input file into chunks of 100000 lines. The chunks are named input-aa , input-ab , etc.

    How do I arrange alphabetically in NotePad?

    To get a dictionary sort (a-z), use the menu option Edit -> Line operations -> Sort lines lexicographically. There are two versions – ascending and descending.

    How to file alphabetically

    Robert Junior, the founder of Techtrix. I’m a Tech blogger and content creator who loves to Write About Tech, Apps, And Games.

    When using hardware devices to play music from SD cards or USB disks, you may find that they play files in non-alphabetical order. In my case, the Pioneer AVIC-F940BT device in my car showed and played MP3 files in almost alphabetical order. The problem here is that these SD cards and USB disks use the FAT filesystem. They read the contents of the file allocation table as is, and do not perform sorting of their own. This means that the playing order is based on the order in which the directories and files were copied to the disk or card.

    Luckily there is a way to sort these files again. For Windows, there is a program called FatSorter that works perfectly. Download from here if the previous link does not work. Select the drive or folder you want to sort and wait a few seconds/minutes for it to finish.

    How to file alphabetically

    • ← Fixing “unable to find partition containing kernel” on XenServer with Ubuntu VM
    • Fixing “Another operation involving the object is currently in progress” on XenServer →

    10 thoughts on “ Sorting files alphabetically on FAT filesystems (USB disks, SD cards) ”

    Is their program for the MAC ?
    Tks
    BM

    Apparently THERE does not appear to be a version of this for Mac. But I bet you could find a FAT sorter for linux which could be used in OS X via the Terminal if you dig around a bit.
    You could also set up boot camp or at least a Windows based VM- that’s what I do… I may not use it much, but occasionally I require the functions of Windows only software.

    thanks for your effort about fat sorter.
    Sincerely yours,

    I want to download this programm, but the second link doesn’t work, and the first one leads to [link removed]. And I do not undersdand how to downloand FAT Sorter. So could you plese help me?

    I am unable to find the program now as well. Hopefully you can find it somewhere else.

    I hope so too. Still thank you for your time and attention 🙂

    Available at: http://www.softpedia.com/get/System/File-Managemen​​​t/FAT-Sorter.shtml (note: use the Softpedia download link option–the alternative External mirror download link did not work for me when I tried it just now).

    I’ve used this program a lot and it is simply not very reliable. Very common for it to totally make a mess or the ordering and lately it has mixed everything up every time.

    This tutorial explains how to copy folders in alphabetical order. You can use this to also copy files alphabetically.

    Normally, when we copy folders and paste in some other directory or USB flash drive, folders are copied in some random order. So, when you have to copy folders in alphabetical order in another folder or directory, you can use this handy software, named Copy In Order. This software can also help you copy files alphabetically.

    This freeware lets you select the destination folder and copy files and folders that you want to copy to the destination path. No matter what the sequence is of input files and folders, they will be copied in alphabetical order in the destination path.

    How to file alphabetically

    Do note that there are some other, and better, bulk file copier software that can speed up the copy process. The distinguishing feature of this particular software is that it lets you copy files and folders in alphabetical order.

    Other Features Available In This Software:

    • You can select the file types (MP3, JPG, etc.) that you want to include in the copy process
    • You can enable the option to move files instead of copying the files
    • Option to check space in destination location before starting the copying process is also available

    How To Copy Folders In Alphabetical Order?

    Step 1: Download the portable application of this software.

    Step 2: It has a self-explanatory interface. You can select the destination path where copied folders and files will be stored, select file types (if needed), and drop files and folders in the list that you want to include in the copying process.

    How to file alphabetically

    Step 3: When you are ready, click on Copy Files button, and the folders will be saved to the destination in alphabetic order only.

    Conclusion:

    The software has brought a unique idea and can be handy for sure when you want to folders in a-z sequence, and not in the random order. Give it a try.

    How can we help you today?

    Sorting Production Files in Chronological / Alphabetical Order in GoldFynch Print

    Modified on: Fri, Apr 16, 2021 at 8:56 AM

    This article applies to emails processed in GoldFynch from container files like MBOX or PST.

    The emails in GoldFynch are numbered in the order they are stored in the (uploaded) MBOX or PST file, which sometimes may not be in chronological order. Learn more about the sort order of files in incoming PST productions here.

    To ensure emails are sorted in chronological order in a production you create, use the “Oldest to newest” or “Newest to oldest” sorting orders as described below.

    NOTE: The sort method in the production wizard only affects those top-level emails/families. Any attachments will always immediately follow their parent document in the Bates sequence, regardless of the selected sort order.

    To set the sort order:

    Once you logged in to GoldFynch, click on the Production icon from the left menu, then click on the “Start Production Wizard” button.

    How to file alphabetically

    Step 1: Give the production a name.

    How to file alphabetically

    Step 2: Select the tags and saved searches you want to use for Production.

    Step 3: Choose how you’d like your production to be produced.

    How to file alphabetically

    Step 5: If you want to sort your files by alphabetical order, this is the step where you can either choose “Alphabetically by file name” or “Alphabetically by folder and file name” for Alphabetical sorting, or ” Oldest to newest” \ “Newest to oldest” for chronological sorting from the “Item Sort Order” dropdown, and click “OK.”

    How to file alphabetically

    Continue the Production steps Step 6 to Step 10 of the Production Wizard. Make sure to r eview the production options in the summary step, if you wish to edit any of the options hit back, if not, click on the “Produce” button, to finish producing.

    vladimiratanasiu

    Board Regular
    • Aug 2, 2021
  • #1
  • This problem is somehow alike my previous post, but with different results. I have a workbook including more files with data about some companies, as shown in the next Dropbox link : 1. Lista Furnizori Agreati.xlsx . The file “Furnizori” includes all companies, arranged alphabetically. Each other file (A,B,C etc.) includes only the the group of companies from file “Furnizori”, whose names start with the alphabet letters (A, B, C etc.). At one time, one / more rows with companies could be added / deleted in a file. My question is how could be automatically updated the content from the file “Furnizori”, when are made changes in other files, adding or removing new / existing companies and auto arrange them alphabetically. Similarly, if a company is added / deleted from the file “Furnizori”, I need to be operated the same changes in the file where the company/ies is/are placed. At the same time, depending of the changes, all elements should auto arrange alphabetically also in the main file and in the letter-marked one(s).

    Thank you in advance.

    Attachments

    • How to file alphabetically

    Excel Facts

    mumps

    Well-known Member
    • Aug 2, 2021
  • #2
  • vladimiratanasiu

    Board Regular
    • Aug 3, 2021
  • #3
  • I added the necessary identifiers in the column A from all alphabetical sheets as shown in the linked file 1. Lista Furnizori Agreati .xlsx. Anyway, the number of rows from the main / alphabetic files and their present order are just indicative, taking into account that the firms will vary in the future.

    vladimiratanasiu

    Board Regular
    • Aug 3, 2021
  • #4
  • mumps

    Well-known Member
    • Aug 3, 2021
  • #5
  • The 1. Lista Furnizori Agreati – grouped .xlsx file is the desired format. We have to take this one step at a time.

    When you add a new company to any of the individual company sheets, do you enter data in all the columns starting from column A to L? When you delete a company from any of those sheets, do you delete the whole row or just the supplier name in column B?

    When you add a new company in the “Furnizori(suppliers)” sheet, do you also enter data in column C? When you delete a company from the “Furnizori(suppliers)” sheet, do you delete the whole row or just the supplier name in column B?

    vladimiratanasiu

    Board Regular
    • Aug 4, 2021
  • #6
  • The 1. Lista Furnizori Agreati – grouped .xlsx file is the desired format. We have to take this one step at a time.

    When you add a new company to any of the individual company sheets, do you enter data in all the columns starting from column A to L? When you delete a company from any of those sheets, do you delete the whole row or just the supplier name in column B?

    When you add a new company in the “Furnizori(suppliers)” sheet, do you also enter data in column C? When you delete a company from the “Furnizori(suppliers)” sheet, do you delete the whole row or just the supplier name in column B?

    I’m trying to answer punctually:

    1. I use constantly the columns B (Supplier name) and H (Purchased products), that must always be filled in. Data from the other columns is inserted only if necessary to, complying with no certain criteria (see the attached photo).
    2. In the sheet “Furnizori(suppliers)” I enter data also in the column C, in case of processing information about a new company .
    3. If I need to remove a company, I delete the whole row where it’s placed.
    4. I rectified the title of column C from files A-Z, in order to avoid possible misunderstandings. It abbreviated the Romanian expression “Number of contract”, as shown in the linked table 1. Lista Furnizori Agreati – grouped .xlsx.
    5. I separated the large group of firms in specific alphabetical subgroups, linked with their original identifier (Nr. crt.). Anyway, neither of them won’t keep the present numbering in the future, considering the certain modifications of the content. Could you take into account a dynamic system to adjust the the whole and the alphabetical numbering lists, in order to exclude overlapped / missing Crt. numbers?

    Thanks. We have received your request and will respond promptly.

    Come Join Us!

    • Talk With Other Members
    • Be Notified Of Responses
      To Your Posts
    • Keyword Search
    • One-Click Access To Your
      Favorite Forums
    • Automated Signatures
      On Your Posts
    • Best Of All, It’s Free!

    Posting Guidelines

    Promoting, selling, recruiting, coursework and thesis posting is forbidden.

    • Forum
    • Search
    • FAQs
    • Links
    • MVPs

    sort the content of a file in alphabetical order

    sort the content of a file in alphabetical order

    I have a file load_bom.ctl and the content of the file as follows:

    I need to write a perl script that reads this file and sort the file content in alphabetical order. How will I be able to achieve this? Please help. Thanks.

    RE: sort the content of a file in alphabetical order

    this might work:

    RE: sort the content of a file in alphabetical order

    Does it have to be a perl script? I would have thought a command line option might have been faster in these circumstances, for a straightforward sort

    Paul
    ————————————
    Spend an hour a week on CPAN, helps cure all known programming ailments

    RE: sort the content of a file in alphabetical order

    open(INFILE,’ outfile.txt’) or die “$!”;

    print OUTFILE sort ;

    close OUTFILE;
    close INFILE;

    RE: sort the content of a file in alphabetical order

    well it would be easier if I typed it in correctly.

    the print line should be:

    Red Flag Submitted

    Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
    The Tek-Tips staff will check this out and take appropriate action.

    Reply To This Thread

    Posting in the Tek-Tips forums is a member-only feature.

    Click Here to join Tek-Tips and talk with other members! Already a Member? Login

    Search Support

    1. Home
    2. Support Forums
    3. Firefox
    4. When I go to save or upload a file.

    Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

    Learn More

    How to file alphabetically

    When I go to save or upload a file, the menu is backwards, how do I get it back to alphabetical order?

    • 5 replies
    • 2 have this problem
    • 13 views
    • Last reply by Vivek

    How to file alphabetically

    So when I save or upload a file, it’s in reverse-alphabetical order. I can’t seem to get it to switch back, and I’m pretty sure I didn’t change any settings that would cause this. Any ideas on how to fix it?

    Thanks in advace

    Chosen solution

    Not sure, it looks like a Windows tweak. The file open dialog box is a Windows feature. Does this happen on other programs?? You can try to click the last icon on top, change the view to Details, click the Name header, then the Type column header until File Folder comes on top alphabetically.

    All Replies (5)

    How to file alphabetically

    Can you please post a screenshot?? Add images: Browse below Post a Reply on this page.

    How to file alphabetically

    Here’s a good example, the folders are on the right, and both files and folders are in reverse-alphabetical order.

    How to file alphabetically

    Chosen Solution

    Not sure, it looks like a Windows tweak. The file open dialog box is a Windows feature. Does this happen on other programs?? You can try to click the last icon on top, change the view to Details, click the Name header, then the Type column header until File Folder comes on top alphabetically.

    How to file alphabetically

    It only happens in Firefox, but that did solve it. Thanks!