Text-In Query Examples
142
Query Example II
In the above text-in data, you can find that the comparison value is located at 17th (Unit
price, $ mark will be ignored automatically), 28th (Qty) and 40th (amount) characters
(including spaces) from the left, but the value of amount category is located on a
different line from Item. In this case, you can enter
17
,
28
, and
40
in each Column field
and enter
1
in the Line field for the next line.
For example, if you want to search for Coke with a Qty (Quantity) of more than 1 and
Hotdog with an amount totaling over $8, the following search condition can be set.
Figure B-2
Query Example 2
1
2
3
4
5
6
123456789012345678901234567890123456789012345678901234567890
Item
Unit price
Qty
amount
====================================================
Coke
| $ 2.20 |
1(s)
$
2.20
Fanta
| $ 2.20 |
1(s)
$
2.20
Hotdog
| $ 3.50 |
3(s)
$
10.50
Pepsi
| $ 1.95 |
1(s)
$
1.95
====================================================
total : $ 16.85
Thank you~~
Summary of Contents for HRSD16
Page 12: ...Tables 12 ...
Page 18: ...18 ...
Page 22: ...Introduction 22 ...
Page 138: ...Operation 138 ...
Page 140: ...USB Hard Disk Drive Preparation 140 ...
Page 158: ...Time Overlap 158 ...
Page 160: ...Troubleshooting 160 ...
Page 162: ...Connector Pinouts 162 ...
Page 163: ...Map of Screens Document 800 03650 Rev D 163 02 09 H Map of Screens ...
Page 164: ...Map of Screens 164 ...
Page 166: ...System Log Notices 166 ...
Page 175: ......