Skip to content

Commit e23450e

Browse files
alexbruyalexbruy
committedFeb 1, 2012
updates to Field calculator help from Alister Hood (fix #4405)
·
ltr-3_40Before-merge-new_vector_api
1 parent 7b2bf88 commit e23450e

File tree

1 file changed

+18
-14
lines changed

1 file changed

+18
-14
lines changed
 

‎resources/context_help/QgsFieldCalculator-en_US

Lines changed: 18 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -15,26 +15,30 @@ The field calculator allows you to update fields with expressions.
1515
</td>
1616
<td>value of field <tt>column_name</tt></td>
1717
</tr>
18-
<tr><td>'string'</td><td>literal string value</td></tr>
19-
<tr><td><i>number</i></td><td>number</td></tr>
18+
<tr><td>'<tt>string</tt>'</td><td>literal string value</td></tr>
19+
<tr><td><tt>number</tt></td><td>number</td></tr>
2020
<tr><td>NULL</td><td>null value</td></tr>
21+
<tr><td>exp(<tt>a</tt>)</td><td>Euler's number e to the power of <tt>a</tt></td></tr>
22+
<tr><td>ln(<tt>a</tt>)</td><td>natural log (i.e. base e) of <tt>a</tt></td></tr>
23+
<tr><td>log10(<tt>a</tt>)</td><td>log base 10 of <tt>a</tt></td></tr>
24+
<tr><td>log(<tt>a</tt>,<tt>b</tt>)</td><td>log base <tt>b</tt> of <tt>a</tt></td></tr>
2125
<tr><td>sqrt(<tt>a</tt>)</td><td>square root</td></tr>
22-
<tr><td>sin(<tt>a</tt>)</td><td>sinus of <tt>a</tt></td></tr>
23-
<tr><td>cos(<tt>a</tt>)</td><td>cosinus of <tt>b</tt></td></tr>
24-
<tr><td>tan(<tt>a</tt>)</td><td>tangens of <tt>a</tt></td></tr>
25-
<tr><td>asin(<tt>a</tt>)</td><td>arcussinus of <tt>a</tt></td></tr>
26-
<tr><td>acos(<tt>a</tt>)</td><td>arcuscosinus of <tt>a</tt></td></tr>
27-
<tr><td>atan(<tt>a</tt>)</td><td>arcustangens of <tt>a</tt></td></tr>
26+
<tr><td>sin(<tt>a</tt>)</td><td>sine of <tt>a</tt></td></tr>
27+
<tr><td>cos(<tt>a</tt>)</td><td>cosine of <tt>b</tt></td></tr>
28+
<tr><td>tan(<tt>a</tt>)</td><td>tangent of <tt>a</tt></td></tr>
29+
<tr><td>asin(<tt>a</tt>)</td><td>inverse sine of <tt>a</tt></td></tr>
30+
<tr><td>acos(<tt>a</tt>)</td><td>inverse cosine of <tt>a</tt></td></tr>
31+
<tr><td>atan(<tt>a</tt>)</td><td>inverse tangent of <tt>a</tt></td></tr>
2832
<tr><td>to int(<tt>a</tt>)</td><td>convert string <tt>a</tt> to integer</td></tr>
2933
<tr><td>to real(<tt>a</tt>)</td><td>convert string <tt>a</tt> to real</td></tr>
3034
<tr><td>to string(<tt>a</tt>)</td><td>convert number <tt>a</tt> to string</td></tr>
3135
<tr><td>lower(<tt>a</tt>)</td><td>convert string <tt>a</tt> to lower case</td></tr>
3236
<tr><td>upper(<tt>a</tt>)</td><td>convert string <tt>a</tt> to upper case</td></tr>
3337
<tr><td>length(<tt>a</tt>)</td><td>length of string <tt>a</tt></td></tr>
34-
<tr><td>atan2(y,x)</td><td>arcustangens of y/x using the signs of the two arguments to determine the quadrant of the result.</td></tr>
35-
<tr><td>replace(<tt>a</tt>,<i>replacethis</i>,<i>withthat</i>)</td><td>replace <i>replacethis</i> with <i>withthat</i> in string <tt>a</tt></td></td>
36-
<tr><td>regexp_replace(<tt>a</tt>,<i>replacethis</i>,<i>withthat</i>)</td><td>replace the regular expression <i>replacethis</i> with <i>withthat</i> in string <tt>a</tt></td></td>
37-
<tr><td>substr(<tt>a</tt>,from,len)</td><td>len characters of string <tt>a</tt> starting from from (first character index is 1)</td></td>
38+
<tr><td>atan2(<tt>y</tt>,<tt>x</tt>)</td><td>inverse tangent of <tt>y</tt>/<tt>x</tt> using the signs of the two arguments to determine the quadrant of the result.</td></tr>
39+
<tr><td>replace(<tt>a</tt>,<tt>replacethis</tt>,<tt>withthat</tt>)</td><td>replace <tt>replacethis</tt> with <tt>withthat</tt> in string <tt>a</tt></td></td>
40+
<tr><td>regexp_replace(<tt>a</tt>,<tt>replacethis</tt>,<tt>withthat</tt>)</td><td>replace the regular expression <tt>replacethis</tt> with <tt>withthat</tt> in string <tt>a</tt></td></td>
41+
<tr><td>substr(<tt>a</tt>,<tt>from</tt>,<tt>len</tt>)</td><td><tt>len</tt> characters of string <tt>a</tt> starting from <tt>from</tt> (first character index is 1)</td></td>
3842
<tr><td><tt>a</tt> || <tt>b</tt></td><td>concatenate strings <tt>a</tt> and <tt>b</tt></td></tr>
3943
<tr><td>$rownum</td><td>number current row</td></tr>
4044
<tr><td>$area</td><td>area of polygon</td></tr>
@@ -43,8 +47,8 @@ The field calculator allows you to update fields with expressions.
4347
<tr><td>$id</td><td>feature id</td></tr>
4448
<tr><td>$x</td><td>x coordinate of point</td></tr>
4549
<tr><td>$y</td><td>y coordinate of point</td></tr>
46-
<tr><td>xat(n)</td><td>x coordinate of nth point of a line (indizes start at 0; negative values apply to the last index)</td></tr>
47-
<tr><td>yat(n)</td><td>y coordinate of nth point of a line (indizes start at 0; negative values apply to the last index)</td></tr>
50+
<tr><td>xat(<tt>n</tt>)</td><td>x coordinate of <tt>n</tt>th point of a line (indices start at 0; negative values apply to the last index)</td></tr>
51+
<tr><td>yat(<tt>n</tt>)</td><td>y coordinate of <tt>n</tt>th point of a line (indices start at 0; negative values apply to the last index)</td></tr>
4852
<tr><td><tt>a</tt> ^ <tt>b</tt></td><td><tt>a</tt> raised to the power of <tt>b</tt></td></tr>
4953
<tr><td><tt>a</tt> * <tt>b</tt></td><td><tt>a</tt> multiplied by <tt>b</tt></td></tr>
5054
<tr><td><tt>a</tt> / <tt>b</tt></td><td><tt>a</tt> divided by <tt>b</tt></td></tr>

0 commit comments

Comments
 (0)
Please sign in to comment.