{"id":293,"date":"2007-06-19T11:39:39","date_gmt":"2007-06-19T10:39:39","guid":{"rendered":"http:\/\/www.galhano.com\/blog\/?p=293"},"modified":"2017-01-12T11:55:16","modified_gmt":"2017-01-12T11:55:16","slug":"funcoes-matematicas-e-de-texto-em-vbnet","status":"publish","type":"post","link":"http:\/\/galhano.com\/blog\/?p=293","title":{"rendered":"Fun\u00e7\u00f5es Matem\u00e1ticas e de Texto em VB.Net"},"content":{"rendered":"
\n
\u00c2 <\/span><\/div>\n

\u00c2 Mathematical Functions\u00c2 <\/span><\/span><\/strong><\/p>\n

Popular mathematical functions are summarized in the following table. Note that certain functions do not<\/em> require the Math.<\/span> prefix.<\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Function<\/span><\/th>\nUse<\/span><\/th>\n<\/tr>\n
Math.Abs()<\/strong><\/span><\/td>\nReturns the absolute value.
\nMath.Abs(-10)<\/span> returns 10<\/span>.<\/span><\/td>\n<\/tr>\n
Math.Ceiling()<\/strong><\/span><\/td>\nReturns an integer that is greater than or equal to a number.
\nMath.Ceiling(5.333)<\/span> returns 6<\/span>.<\/span><\/td>\n<\/tr>\n
Fix()<\/strong><\/span><\/td>\nReturns the integer portion of a number.
\nFix(5.3333)<\/span> returns 5<\/span>.<\/span><\/td>\n<\/tr>\n
Math.Floor()<\/strong><\/span><\/td>\nReturns an integer that is less than or equal to a number.
\nFix(5.3333)<\/span> returns 5<\/span>.<\/span><\/td>\n<\/tr>\n
Int()<\/strong><\/span><\/td>\nReturns the integer portion of a number.
\nInt(5.3333)<\/span> returns 5<\/span>.<\/span><\/td>\n<\/tr>\n
Math.Max()<\/strong><\/span><\/td>\nReturns the larger of two numbers.
\nMath.Max(5,7)<\/span> returns 7<\/span>.<\/span><\/td>\n<\/tr>\n
Math.Min()<\/strong><\/span><\/td>\nReturns the smaller of two numbers.
\nMath.Min(5,7)<\/span> returns 5<\/span>.<\/span><\/td>\n<\/tr>\n
Math.Pow()<\/strong><\/span><\/td>\nReturns a number raised to a power.
\nMath.Pow(12,2)<\/span> returns 144<\/span>.<\/span><\/td>\n<\/tr>\n
Rnd()<\/strong><\/span><\/td>\nReturns a random number between 0 and 1. Used in conjunction with Randomize<\/span>statement to initialize the random number generator.<\/span><\/td>\n<\/tr>\n
Math.Round()<\/strong><\/span><\/td>\nRounds a number to a specified number of decimal places. Rounds up on .5<\/span>.
\nMath.Round(1.1234567,5)<\/span> returns 1.12346<\/span>.<\/span><\/td>\n<\/tr>\n
Math.Sign()<\/strong><\/span><\/td>\nReturns the sign of a number. Returns -1<\/span> if negative and 1<\/span> if positive.
\nMath.Sign(-5)<\/span> returns -1<\/span>.<\/span><\/td>\n<\/tr>\n
Math.Sqrt()<\/strong><\/span><\/td>\nReturns the square root of a positive number.
\nMath.Sqrt(144)<\/span> returns 12<\/span>.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00c2<\/p>\n

\u00c2 Random Numbers\u00c2 <\/span><\/strong><\/span><\/p>\n

The Rnd()<\/span> function returns a random number between 0 and 1. More likely, the need is to generate a number within a particular range, between a given low and high<\/span><\/p>\n

\u00c2 number. This is accomplished with the following formula.<\/span><\/p>\n\n\n\n
Math.floor((high<\/em> – low<\/em> + 1) * Rnd() + low<\/em>) <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

For instance, to generate a random number between 0 and 10 the formula becomes<\/span><\/p>\n

Math.floor((10 - 0 + 1) * Rnd() + 0)<\/span><\/pre>\n
\u00c2<\/p>\n
\u00c2<\/p>\n
\u00c2 String Functions\u00c2 <\/span><\/strong><\/span><\/p>\n
Several built-in string functions perform string manipulations to augment simple concatenation with the “&”<\/span> operator. These functions are summarized in the following table.<\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Function<\/span><\/th>\nUse<\/span><\/th>\n<\/tr>\n
Asc()<\/strong><\/span><\/td>\nReturns the character code of the first character of a string.
\nAsc(“A”)<\/span> returns 65<\/span>.<\/span><\/td>\n<\/tr>\n
Chr()<\/strong><\/span><\/td>\nReturns the display character of a character code.
\nChr(65)<\/span> returns “A”<\/span>.<\/span><\/td>\n<\/tr>\n
GetChar()<\/strong><\/span><\/td>\nReturns the character at a specified position in a string, counting from 1.
\nGetChar(“This is a string”, 7)<\/span> returns “s”<\/span>.<\/span><\/td>\n<\/tr>\n
InStr()<\/strong><\/span><\/td>\nReturns the starting position in a string of a substring, counting from 1.
\nInStr(“This is a string”, “string”)<\/span> returns 11<\/span>.<\/span><\/td>\n<\/tr>\n
InStrRev()<\/strong><\/span><\/td>\nReturns the starting position in a string of a substring, searching from the end of the string.
\nInStr(“This is a string”, “string”)<\/span> returns 11<\/span>.<\/span><\/td>\n<\/tr>\n
LCase()<\/strong><\/span><\/td>\nReturns the lower-case conversion of a string.
\nLCase(“THIS IS A STRING”)<\/span> returns “this is a string”<\/span>.<\/span><\/td>\n<\/tr>\n
Left()<\/strong><\/span><\/td>\nReturns the left-most specified number of characters of a string.
\nLeft(“This is a string”, 4)<\/span> returns “This”<\/span>.<\/span><\/td>\n<\/tr>\n
Len()<\/strong><\/span><\/td>\nReturns the length of a string.
\nLen(“This is a string”)<\/span> returns 16<\/span>.<\/span><\/td>\n<\/tr>\n
LTrim()<\/strong><\/span><\/td>\nRemoves any leading spaces from a string.
\nLTrim(“\u00c2 \u00c2 \u00c2 This is a string”)<\/span> returns “This is a string”<\/span>.<\/span><\/td>\n<\/tr>\n
Mid()<\/strong><\/span><\/td>\nReturns a substring from a string, specified as the starting position (counting from 1) and the number of characters.
\nMid(“This is a string”, 6, 4)<\/span> returns “is a”<\/span>.<\/span><\/td>\n<\/tr>\n
Replace()<\/strong><\/span><\/td>\nReplaces all occurences of a substring in a string.
\nReplace(“This is a string”, ” s”, ” longer s”)<\/span> returns “This are a longer string”<\/span> (replaces an “s” preceded by a blank space).<\/span><\/td>\n<\/tr>\n
Right()<\/strong><\/span><\/td>\nReturns the right-most specified number of characters of a string.
\nRight(“This is a string”, 6)<\/span> returns “string”<\/span>.<\/span><\/td>\n<\/tr>\n
RTrim()<\/strong><\/span><\/td>\nRemoves any trailing spaces from a string.
\nRTrim(“This is a string\u00c2 \u00c2 \u00c2 “)<\/span> returns “This is a string”<\/span>.<\/span><\/td>\n<\/tr>\n
Str()<\/strong><\/span><\/td>\nReturns the string equivalent of a number.
\nStr(100)<\/span> returns “100”<\/span>.<\/span><\/td>\n<\/tr>\n
Space()<\/strong><\/span><\/td>\nFills a string with a given number of spaces.
\n“This” & Space(5) & “string”<\/span> returns “This\u00c2 \u00c2 \u00c2 \u00c2 \u00c2 string”<\/span>.<\/span><\/td>\n<\/tr>\n
StrComp()<\/strong><\/span><\/td>\nCompares two strings. Return values are 0 (strings are equal), 1 (first string has the greater value), or -1 (second string has the greater value) based on sorting sequence.
\nStrComp(“This is a string”, “This string”)<\/span> returns -1<\/span>.<\/span><\/td>\n<\/tr>\n
StrReverse()<\/strong><\/span><\/td>\nReverses the characters in a string.
\nStrReverse(“This is a string”)<\/span> returns “gnirts a si sihT”<\/span>.<\/span><\/td>\n<\/tr>\n
Trim()<\/strong><\/span><\/td>\nRemoves any leading and trailing spaces from a string.
\nTrim(“\u00c2 \u00c2 \u00c2 This is a string\u00c2 \u00c2 \u00c2 “)<\/span> returns “This is a string”<\/span>.<\/span><\/td>\n<\/tr>\n
UCase()<\/strong><\/span><\/td>\nReturns the upper-case conversion of a string.
\nUCase(“This is a string”)<\/span> returns “THIS IS A STRING”<\/span>.<\/span><\/td>\n<\/tr>\n
Val()<\/strong><\/span><\/td>\nConverts a numeric expression to a number.
\nVal( (1 + 2 + 3)^2 )<\/span> returns 36<\/span>.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
The above summaries give you a basic idea of the uses of these arithmetic and string functions. There are occasions throughout these tutorials to see them in action and in combination as they are applied to various processing needs.\u00c2 \u00c2 \u00c2 <\/span><\/p>\n
\u00c2<\/p>\n
Fonte:<\/strong><\/em>http:\/\/msconline.maconstate.edu\/tutorials\/VBNET\/VBNET01\/vbnet01-06.aspx<\/a><\/span><\/p>\n<\/form>\n","protected":false},"excerpt":{"rendered":"
\u00c2<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"close","ping_status":"close","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,42],"tags":[],"class_list":["post-293","post","type-post","status-publish","format-standard","hentry","category-tutorials","category-utils","author-admin"],"_links":{"self":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=293"}],"version-history":[{"count":1,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/293\/revisions"}],"predecessor-version":[{"id":2095,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/293\/revisions\/2095"}],"wp:attachment":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=293"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}