首页 \ 问答 \ 按包含数字和字母的字段排序(Order by a field containing Numbers and Letters)

按包含数字和字母的字段排序(Order by a field containing Numbers and Letters)

 我需要从Delphi XE2下的现有Padadox数据库中提取数据（是的，我超过10年将它们分开......）。  
 我需要根据包含以下值的字段（示例中的id）来排序结果：'1'，'2 a'，'100'，'1 b'，'50 bis'...并得到：  
- 1
- 1 b
- 2 a
- 50 bis
- 100
 
 也许这样的事情可以做到，但那些关键字不存在：  
SELECT id, TRIM(TRIM(ALPHA FROM id)) as generated, TRIM(TRIM(NUMBER FROM id)) as generatedbis, etc
FROM "my.db"
WHERE ...
ORDER BY generated, generatedbis
 
 我怎么能用矛盾实现这样的排序......？ 

I need to extract data from an existing Padadox database under Delphi XE2 (yes, i more than 10 years divide them...). 
i need to order the result depending on a field (id in the example) containing values such as : '1', '2 a', '100', '1 b', '50 bis'... and get this : 
- 1
- 1 b
- 2 a
- 50 bis
- 100
 
maybe something like that could do it, but those keywords don't exist : 
SELECT id, TRIM(TRIM(ALPHA FROM id)) as generated, TRIM(TRIM(NUMBER FROM id)) as generatedbis, etc
FROM "my.db"
WHERE ...
ORDER BY generated, generatedbis
 
how could i achieve such ordering with paradox... ?

原文：https://stackoverflow.com/questions/10028951

更新时间：2023-05-20 07:05

最满意答案

 如果赋予它的表达式为False ，0， None ， '' ， []等， if不会评估if语句的主体False语句不会尝试检测number是否尝试为字符串/ int。  
 因此，如果用户输入0，则number = int(input(question))将运行正常，但数字将为零，因此不会评估if语句的主体。  
 try / except的目的是检查try主体中的语句是否会运行错误。 因此，如果用户输入一些数字，则number = int(input(question))将运行没有任何问题。 如果用户输入的内容不是整数，则number = int(input(question))将为您提供ValueError ，而except块将捕获错误并进行评估。 

The body of the if statement will NOT be evaluated if the expression given to it is False, 0, None, '', [], etc. The if statement will not try to detect if number is trying to be a string/int. 
So if the user enters 0, then number = int(input(question)) will run just fine, but number will be zero, so the body of the if statement will not be evaluated. 
The purpose of the try/except is to check if the statements in the try body will run in to errors. So if a user enters some numbers, then number = int(input(question)) will run without any problems. If a user enters something that is not an integer, then number = int(input(question)) will give you a ValueError, and the except block will catch the error and be evaluated.

按包含数字和字母的字段排序(Order by a field containing Numbers and Letters)

最满意答案

相关问答

尝试将输入字段与标签对齐(Trying to align input field with labels)[2023-05-31]

subprocess.communicate（input_string）仍尝试从stdin读取输入(subprocess.communicate(input_string) still tries to read input from stdin)[2022-08-21]

尝试使用输入捕获不捕获异常(Try catch not catching exception with input)[2019-11-23]

尝试，除了和输入(Try, except and input)[2022-01-30]

尝试使用用户输入创建一个Acronym(Trying to create an Acronym out of user input)[2022-04-12]

尝试将表单输入存储到数组(Trying to store form input to array)[2022-06-19]

当用户在jquery中点击输入外部时，尝试填充输入字段(Trying to fill input field when user clicks away outside of input in jquery)[2024-01-25]

尝试在输入中使用3个以上的值时的ValueError(ValueError when trying to use more than 3 values in input)[2023-12-26]

尝试使用angularjs将一个输入值更新为另一个输入值(Trying to update one input's value to another's using angularjs)[2021-05-17]

尝试根据用户输入显示数组中的元素(Trying to display elements in an array based off user input)[2021-09-11]

相关文章

最新问答