Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Sorting method, system and terminal for hybrid character string table

A sorting method and string technology, which is applied in the field of string sorting, can solve problems that do not conform to daily usage habits, and achieve the effect of accurate sorting

Pending Publication Date: 2020-03-27
ZHUHAI KINGSOFT OFFICE SOFTWARE +2
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

According to the existing collation rules, such as Figure 1a The first character of 'Building 10' is 1, the first character of 'Building 9' is 9, and 1 is less than 9, so 'Building 10' will be ranked in front of 'Building 9', and so on, and such Results do not meet daily usage habits

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Sorting method, system and terminal for hybrid character string table
  • Sorting method, system and terminal for hybrid character string table
  • Sorting method, system and terminal for hybrid character string table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] In order to make the purpose, technical solution and advantages of the present invention more clear, the embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined arbitrarily with each other.

[0040] The steps shown in the flowcharts of the figures may be performed in a computer system, such as a set of computer-executable instructions. Also, although a logical order is shown in the flowcharts, in some cases the steps shown or described may be performed in an order different from that shown or described herein.

[0041] The embodiment of the present invention provides a method for sorting mixed character string tables, such as figure 2 As shown, the method includes:

[0042] S201 Locate the column corresponding to the sort basis in the mixed-type character strin...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a sorting method, a system and a terminal for mixed character string tables. The method comprises the following steps of: positioning columns corresponding to sorting bases inthe mixed character string tables to be sorted; distinguishing a non-numeric character string and a numeric character string from the mixed character string in each row of the column; sorting the to-be-sorted mixed character string table for the first time according to the non-numeric character strings; and if the same non-digital character string exists in the column after the first sorting of the to-be-sorted hybrid character string table, sorting the table content corresponding to the same non-digital character string again according to the digital character string. According to the method,the content of the mixed character string table can be accurately sorted.

Description

technical field [0001] The invention relates to a character string sorting technology, in particular to a sorting method, system and terminal for a mixed character string table. Background technique [0002] In the spreadsheet, in order to facilitate the search and observation of data, the data needs to be sorted. For example: sort by total score, sort by date, sort by name, sort by address. Numbers and text can be stored in the spreadsheet. A mixed string spreadsheet refers to a spreadsheet that contains both 'numeric characters' and 'non-numeric characters' strings. [0003] In the existing technology for sorting the contents of electronic tables, the same set of rules are used for sorting 'mixed strings' and 'ordinary strings (that is, numeric strings)', and the mixed strings are Each numeric character is compared and sorted as an ordinary character. According to this rule, the sorting result is often far from the expected value. Figure 1a is a mixed-type string tabl...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/9032
Inventor 陈波项林建覃欢
Owner ZHUHAI KINGSOFT OFFICE SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com