Honeywell HRSD40F250 User Guide - Page 135

Text-In Search Examples B, Search Example

Page 135 highlights

Text-In Search Examples B Text-In Search Examples Search Example I 1 2 3 4 5 6 123456789012345678901234567890123456789012345678901234567890 Item Unit price Qty amount Coke Fanta Hotdog Pepsi | $ 2.20 | | $ 2.20 | | $ 3.50 | | $ 1.95 | 1(s) | 1(s) | 3(s) | 1(s) | $ 2.20 $ 2.20 $ 10.50 $ 1.95 total : $ 16.85 Thank you~~ 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. In this case, you can enter 17, 28, and 40 in each Column field. 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-1 Text-In Query Example 1 Document 800-03097 Rev C 135 03/09

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168

Text-In Search Examples
Document 800-03097
Rev C
135
03/09
B
Text-In Search Examples
Search Example I
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. In this case, you can enter
17
,
28
, and
40
in each
Column field.
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-1
Text-In Query Example 1
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~~