{"id":2275,"date":"2022-09-10T10:33:14","date_gmt":"2022-09-10T10:33:14","guid":{"rendered":"https:\/\/www.overcharts.com\/en\/helpcenter\/?post_type=docs&p=2275"},"modified":"2023-01-20T11:11:04","modified_gmt":"2023-01-20T11:11:04","password":"","slug":"overbasic-string-functions","status":"publish","type":"docs","link":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-string-functions\/","title":{"rendered":"Overbasic – String functions"},"content":{"rendered":"\n

My.Strings<\/strong> category contains all built-in functions available in Overbasic for handling strings.<\/p>\n\n\n\n

<\/div>\n\n\n\n

Cstr<\/strong><\/h2>\n\n\n\n

Converts a number (or the result of a numeric-expression) to a string.<\/p>\n\n\n\n

Result type<\/strong>: string<\/p>\n\n\n\n

Arguments<\/strong>:<\/p>\n\n\n\n

    \n
  • NUMBER<\/strong>: any numeric expression.<\/li>\n<\/ul>\n\n\n\n
    <\/div>\n\n\n\n
    Dim<\/mark><\/strong> s As String<\/mark><\/strong> = My.Strings.Cstr(2 * 3) 'Result: \"6\"<\/mark><\/code><\/pre>\n\n\n\n
    <\/div>\n\n\n\n
    FormatNumber<\/strong><\/h2>\n\n\n\n
    Returns a number\/numeric-expression formatted as specified.<\/p>\n\n\n\n
    Result type<\/strong><\/strong>: string<\/p>\n\n\n\n
    Arguments<\/strong><\/strong>:<\/p>\n\n\n\n
      \n
    • EXPRESSION<\/strong>: any numeric expression.<\/li>\n\n\n\n
    • FORMAT<\/strong>: format string<\/li>\n<\/ul>\n\n\n\n
      <\/div>\n\n\n\n
      Note:<\/strong><\/p>\n\n\n\n
      In the format string:<\/p>\n\n\n\n
        \n
      • “,<\/strong>” (comma) is the thousand separator<\/li>\n\n\n\n
      • “.<\/strong>” (point) is the decimal separator<\/li>\n\n\n\n
      • “#<\/strong>” character omits the most significant digit (if zero)<\/li>\n\n\n\n
      • “%<\/strong>” character formats the number as a percentage<\/li>\n<\/ul>\n\n\n\n
        WARNING: thousand and decimal separators in the resulting string will be the separators defined in OS settings.<\/p>\n\n\n\n
        <\/div>\n\n\n\n
        Dim<\/mark><\/strong> a As String<\/mark><\/strong> = My.Strings.FormatNumber(10.2, \"0.00\")  'Result: \"10.20\"<\/mark>\nDim<\/mark><\/strong> b As String<\/mark><\/strong> = My.Strings.FormatNumber(10.27, \"0.0\")  'Result: \"10.3\"<\/mark>\nDim<\/mark><\/strong> c As String<\/mark><\/strong> = My.Strings.FormatNumber(0.23, \"#.00\")   'Result: \".23\"<\/mark>\nDim<\/mark><\/strong> d As String<\/mark><\/strong> = My.Strings.FormatNumber(10.23, \"000000\")  'Result: \"000010\"<\/mark>\nDim<\/mark><\/strong> e As String<\/mark><\/strong> = My.Strings.FormatNumber(10.23, \"0\")  'Result: \"10\"<\/mark>\nDim<\/mark><\/strong> f As String<\/mark><\/strong> = My.Strings.FormatNumber(0.273, \"0.0%\")  'Result: \"27.3%\"<\/mark>\nDim<\/mark><\/strong> g As String<\/mark><\/strong> = My.Strings.FormatNumber(12345.92827635, \"#,##0.00\")  'Result: \"12,345.93\"<\/mark>\nDim<\/mark><\/strong> h As String<\/mark><\/strong> = My.Strings.FormatNumber(45.92827635, \"#,##0.00\")  'Result: \"45.93\"<\/mark><\/code><\/pre>\n\n\n\n
        <\/div>\n\n\n\n
        Instr<\/strong><\/h2>\n\n\n\n
        Returns the position of the first character of STRING2 within STRING1. If STRING2 is not present in STRING1, it returns zero.<\/p>\n\n\n\n
        Result type<\/strong><\/strong><\/strong>: numeric<\/p>\n\n\n\n
        Arguments<\/strong><\/strong>:<\/p>\n\n\n\n
          \n
        • START<\/strong>: character (position) where to start searching for STRING2 in STRING1<\/li>\n\n\n\n
        • STRING1<\/strong>: any string<\/li>\n\n\n\n
        • STRING2<\/strong>: any string<\/li>\n<\/ul>\n\n\n\n
          <\/div>\n\n\n\n
          Dim<\/mark><\/strong> a As Numeric<\/mark><\/strong> = My.Strings.Instr(1, \"Hello World\", \"World\") 'Result: 7<\/mark>\nDim<\/mark><\/strong> b As Numeric<\/mark><\/strong> = My.Strings.Instr(1, \"Hello World\", \"Bye\") 'Result: 0<\/mark><\/code><\/pre>\n\n\n\n
          <\/div>\n\n\n\n
          Len<\/strong><\/h2>\n\n\n\n
          Returns the length (in characters) of a string.<\/p>\n\n\n\n
          Result type<\/strong><\/strong><\/strong>: numeric<\/p>\n\n\n\n
          Arguments<\/strong><\/strong>:<\/p>\n\n\n\n
            \n
          • STRING<\/strong>: any string<\/li>\n<\/ul>\n\n\n\n
            <\/div>\n\n\n\n
            Dim<\/mark><\/strong> l As Numeric<\/mark><\/strong> = My.Strings.Len(\"Hello World\") 'Result: 11<\/mark><\/code><\/pre>\n\n\n\n
            <\/div>\n\n\n\n
            Ltrim<\/strong><\/h2>\n\n\n\n
            Removes any spaces from the left side of a string.<\/p>\n\n\n\n
            Result type<\/strong><\/strong><\/strong>: string<\/p>\n\n\n\n
            Arguments<\/strong><\/strong>:<\/p>\n\n\n\n
              \n
            • STRING<\/strong>: any string<\/li>\n<\/ul>\n\n\n\n
              <\/div>\n\n\n\n
              Dim<\/mark><\/strong> s As String<\/mark><\/strong> = My.Strings.Ltrim(\"   Hello   \") 'Result: \"Hello   \"<\/mark><\/code><\/pre>\n\n\n\n
              <\/div>\n\n\n\n
              Mid<\/strong><\/h2>\n\n\n\n
              Returns a substring of STRING.<\/p>\n\n\n\n
              Result type<\/strong><\/strong><\/strong>: string<\/p>\n\n\n\n
              Arguments<\/strong><\/strong>:<\/p>\n\n\n\n
                \n
              • STRING<\/strong>: any string<\/li>\n\n\n\n
              • START<\/strong>: position of first substring character within STRING<\/li>\n\n\n\n
              • LENGTH<\/strong>: (optional<\/em>) substring length. If omitted, equals the length of STRING minus START.<\/li>\n<\/ul>\n\n\n\n
                <\/div>\n\n\n\n
                Dim<\/mark><\/strong> s As String<\/mark><\/strong> = My.Strings.Mid(\"Hello\", 2, 3) 'Result: \"ell\"<\/mark>\nDim<\/mark><\/strong> s As String<\/mark><\/strong> = My.Strings.Mid(\"Hello\", 2) 'Result: \"ello\"<\/mark><\/code><\/pre>\n\n\n\n
                <\/div>\n\n\n\n
                Rtrim<\/strong><\/h2>\n\n\n\n
                Removes any spaces from the right side of a string.<\/p>\n\n\n\n
                Result type<\/strong><\/strong><\/strong>: string<\/p>\n\n\n\n
                Arguments<\/strong><\/strong>:<\/p>\n\n\n\n
                  \n
                • STRING<\/strong>: any string<\/li>\n<\/ul>\n\n\n\n
                  <\/div>\n\n\n\n
                  Dim<\/mark><\/strong> s As String<\/mark><\/strong> = My.Strings.Rtrim(\"   Hello   \") 'Result: \"   Hello\"<\/mark><\/code><\/pre>\n\n\n\n
                  <\/div>\n\n\n\n
                  Trim<\/strong><\/h2>\n\n\n\n
                  Removes any left and right spaces in a string.<\/p>\n\n\n\n
                  Result type<\/strong><\/strong><\/strong>: string<\/p>\n\n\n\n
                  Arguments<\/strong><\/strong>:<\/p>\n\n\n\n
                    \n
                  • STRING<\/strong>: any string<\/li>\n<\/ul>\n\n\n\n
                    <\/div>\n\n\n\n
                    Dim<\/mark><\/strong> s As String<\/mark><\/strong> = My.Strings.Trim(\"   Hello   \") 'Result: \"Hello\"<\/mark><\/code><\/pre>\n\n\n\n
                    <\/div>\n","protected":false},"excerpt":{"rendered":"
                    My.Strings category contains all built-in functions available in Overbasic for handling strings. Cstr Converts a number (or the result of a numeric-expression) to a string. Result type: string Arguments: FormatNumber Returns a number\/numeric-expression formatted as specified. Result type: string Arguments: Note: In the format string: WARNING: thousand and decimal separators in the resulting string will […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[18],"doc_tag":[],"class_list":["post-2275","docs","type-docs","status-publish","hentry","doc_category-built-in-funtions"],"year_month":"2026-10","word_count":400,"total_views":"1","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Overcharts Team","author_nicename":"overadmin","author_url":"https:\/\/www.overcharts.com\/en\/helpcenter\/author\/overadmin\/"},"doc_category_info":[{"term_name":"Built-In Funtions","term_url":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs-category\/built-in-funtions\/"}],"doc_tag_info":[],"yoast_head":"\r\nOverbasic - String functions - Overcharts Help Center<\/title>\r\n<meta name=\"description\" content=\"My.Strings category contains all built-in functions available in Overbasic for handling strings.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-string-functions\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Overbasic - String functions - Overcharts Help Center\" \/>\r\n<meta property=\"og:description\" content=\"My.Strings category contains all built-in functions available in Overbasic for handling strings.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-string-functions\/\" \/>\r\n<meta property=\"og:site_name\" content=\"Overcharts Help Center\" \/>\r\n<meta property=\"article:modified_time\" content=\"2023-01-20T11:11:04+00:00\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-string-functions\\\/\",\"url\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-string-functions\\\/\",\"name\":\"Overbasic - String functions - Overcharts Help Center\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/#website\"},\"datePublished\":\"2022-09-10T10:33:14+00:00\",\"dateModified\":\"2023-01-20T11:11:04+00:00\",\"description\":\"My.Strings category contains all built-in functions available in Overbasic for handling strings.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-string-functions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-string-functions\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/docs\\\/overbasic-string-functions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Overbasic – String functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/#website\",\"url\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/\",\"name\":\"Overcharts Help Center\",\"description\":\"Trading Software & Technical Analysis\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.overcharts.com\\\/en\\\/helpcenter\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Overbasic - String functions - Overcharts Help Center","description":"My.Strings category contains all built-in functions available in Overbasic for handling strings.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-string-functions\/","og_locale":"en_US","og_type":"article","og_title":"Overbasic - String functions - Overcharts Help Center","og_description":"My.Strings category contains all built-in functions available in Overbasic for handling strings.","og_url":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-string-functions\/","og_site_name":"Overcharts Help Center","article_modified_time":"2023-01-20T11:11:04+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-string-functions\/","url":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-string-functions\/","name":"Overbasic - String functions - Overcharts Help Center","isPartOf":{"@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/#website"},"datePublished":"2022-09-10T10:33:14+00:00","dateModified":"2023-01-20T11:11:04+00:00","description":"My.Strings category contains all built-in functions available in Overbasic for handling strings.","breadcrumb":{"@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-string-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-string-functions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/docs\/overbasic-string-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.overcharts.com\/en\/helpcenter\/"},{"@type":"ListItem","position":2,"name":"Overbasic – String functions"}]},{"@type":"WebSite","@id":"https:\/\/www.overcharts.com\/en\/helpcenter\/#website","url":"https:\/\/www.overcharts.com\/en\/helpcenter\/","name":"Overcharts Help Center","description":"Trading Software & Technical Analysis","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.overcharts.com\/en\/helpcenter\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs\/2275","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/comments?post=2275"}],"version-history":[{"count":8,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs\/2275\/revisions"}],"predecessor-version":[{"id":2283,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/docs\/2275\/revisions\/2283"}],"wp:attachment":[{"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/media?parent=2275"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/doc_category?post=2275"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.overcharts.com\/en\/helpcenter\/wp-json\/wp\/v2\/doc_tag?post=2275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}