{"id":2543,"date":"2017-12-09T05:04:08","date_gmt":"2017-12-09T05:04:08","guid":{"rendered":"http:\/\/www.scmgalaxy.com\/tutorials\/?p=2543"},"modified":"2021-02-27T09:18:05","modified_gmt":"2021-02-27T09:18:05","slug":"function-in-vb-script","status":"publish","type":"post","link":"https:\/\/www.scmgalaxy.com\/tutorials\/function-in-vb-script\/","title":{"rendered":"Function in vb script"},"content":{"rendered":"

rajani created the topic: function in vb script<\/strong><\/p>\n

Develop a function that accepts a string of names separated by comma add those names in an array and display the names added in the array.<\/p>\n

rajeshkumar replied the topic: function in vb script<\/strong><\/p>\n

Welcome to board….<\/p>\n

try following snippet…<\/p>\n

Sub Funstr(\"str1\", \"str2\")<\/p>\n

a=Array(str1,str2)
\n document.write(a(0))
\n document.write(a(1))
\nEnd Sub<\/code><\/p>\n

I would recommend you going through this url as well to learn more about it……<\/p>\n

www.functionx.com\/vbscript\/Lesson06.htm<\/a><\/p>\n

Regards,
\nRajesh Kumar
\nTwitt me @ twitter.com\/RajeshKumarIn<\/a><\/p>\n

rajani replied the topic: function in vb script<\/strong><\/p>\n

it won’t work
\ni have write
\n“Develop a function that accepts a string of names separated by comma (example given below), add those names in an array and display the names added in the array”<\/p>\n

Example: rajani; Disha; Dhara; Hunny ;moon
\nwithout using split function
\ncan i use mid function<\/p>\n

rajani replied the topic: function in vb script<\/strong><\/p>\n

i am able to display name but with comma
\nDim fruits()
\nReDim fruits(100)
\nnofruits=0
\n‘we do not know how many fruit names we are going to enter and so, we have declared the array size as 100
\nFor i=0 to 100
\nfruits(i)=inputbox(“Enter the name of a fruit separated by comma”)
\nans = MsgBox(“Do you want to continue”, vbYesNo, “Confirm Continuation…”)
\nIf ans=vbNo Then
\nExit For
\nEnd If
\nnofruits=nofruits+1
\nNext
\nReDim Preserve fruits(nofruits)
\n‘Redim keyword resets the number of elements that can be accommodated in the array.<\/p>\n

fruitnames=””<\/p>\n

For each fruit in fruits
\n‘Using For Each Next we have displayed all the names of the fruits which was entered and kept in fruits array.
\n‘For Each Next extracts the fruit names stored in the array and msgbox displays the output.<\/p>\n

fruitnames=fruitnames&fruit&vbnewline
\nNext<\/p>\n

msgbox fruitnames<\/p>\n

rajani replied the topic: function in vb script<\/strong><\/p>\n

any suggestion<\/p>\n

rajani replied the topic: function in vb script<\/strong><\/p>\n

dim Array, Str1,X
\nStr1 = “Neha; Swati; Disha; Sonya; Dhara”
\nArray = split(Str1,”;”)
\nfor each x in Array
\nmessage = message & x & vbCRLF
\nnext
\nmsgbox message<\/p>\n","protected":false},"excerpt":{"rendered":"

rajani created the topic: function in vb script Develop a function that accepts a string of names separated by comma […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[501],"tags":[278],"class_list":["post-2543","post","type-post","status-publish","format-standard","hentry","category-others-scripting-language","tag-script"],"yoast_head":"\nFunction in vb script - scmGalaxy<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.scmgalaxy.com\/tutorials\/function-in-vb-script\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Function in vb script - scmGalaxy\" \/>\n<meta property=\"og:description\" content=\"rajani created the topic: function in vb script Develop a function that accepts a string of names separated by comma […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.scmgalaxy.com\/tutorials\/function-in-vb-script\/\" \/>\n<meta property=\"og:site_name\" content=\"scmGalaxy\" \/>\n<meta property=\"article:published_time\" content=\"2017-12-09T05:04:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-27T09:18:05+00:00\" \/>\n<meta name=\"author\" content=\"scmgalaxy K\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"scmgalaxy K\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/function-in-vb-script\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/function-in-vb-script\\\/\"},\"author\":{\"name\":\"scmgalaxy K\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/fc12ad190f540e79460243c81148d102\"},\"headline\":\"Function in vb script\",\"datePublished\":\"2017-12-09T05:04:08+00:00\",\"dateModified\":\"2021-02-27T09:18:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/function-in-vb-script\\\/\"},\"wordCount\":331,\"commentCount\":0,\"keywords\":[\"script\"],\"articleSection\":[\"others scripting language\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/function-in-vb-script\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/function-in-vb-script\\\/\",\"url\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/function-in-vb-script\\\/\",\"name\":\"Function in vb script - scmGalaxy\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#website\"},\"datePublished\":\"2017-12-09T05:04:08+00:00\",\"dateModified\":\"2021-02-27T09:18:05+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/fc12ad190f540e79460243c81148d102\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/function-in-vb-script\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/function-in-vb-script\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/function-in-vb-script\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Function in vb script\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#website\",\"url\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/\",\"name\":\"scmGalaxy\",\"description\":\"A Platform for Software Engineers\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/fc12ad190f540e79460243c81148d102\",\"name\":\"scmgalaxy K\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b902ea8c77ee0a326c112f29d0edf51b7c3e1cd05c4fb92a810177e9c3f12a9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b902ea8c77ee0a326c112f29d0edf51b7c3e1cd05c4fb92a810177e9c3f12a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b902ea8c77ee0a326c112f29d0edf51b7c3e1cd05c4fb92a810177e9c3f12a9?s=96&d=mm&r=g\",\"caption\":\"scmgalaxy K\"},\"sameAs\":[\"http:\\\/\\\/www.DevOpsSchool.com\"],\"url\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/author\\\/scmgalaxy\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Function in vb script - scmGalaxy","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.scmgalaxy.com\/tutorials\/function-in-vb-script\/","og_locale":"en_US","og_type":"article","og_title":"Function in vb script - scmGalaxy","og_description":"rajani created the topic: function in vb script Develop a function that accepts a string of names separated by comma […]","og_url":"https:\/\/www.scmgalaxy.com\/tutorials\/function-in-vb-script\/","og_site_name":"scmGalaxy","article_published_time":"2017-12-09T05:04:08+00:00","article_modified_time":"2021-02-27T09:18:05+00:00","author":"scmgalaxy K","twitter_card":"summary_large_image","twitter_misc":{"Written by":"scmgalaxy K","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/function-in-vb-script\/#article","isPartOf":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/function-in-vb-script\/"},"author":{"name":"scmgalaxy K","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#\/schema\/person\/fc12ad190f540e79460243c81148d102"},"headline":"Function in vb script","datePublished":"2017-12-09T05:04:08+00:00","dateModified":"2021-02-27T09:18:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/function-in-vb-script\/"},"wordCount":331,"commentCount":0,"keywords":["script"],"articleSection":["others scripting language"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.scmgalaxy.com\/tutorials\/function-in-vb-script\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/function-in-vb-script\/","url":"https:\/\/www.scmgalaxy.com\/tutorials\/function-in-vb-script\/","name":"Function in vb script - scmGalaxy","isPartOf":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#website"},"datePublished":"2017-12-09T05:04:08+00:00","dateModified":"2021-02-27T09:18:05+00:00","author":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#\/schema\/person\/fc12ad190f540e79460243c81148d102"},"breadcrumb":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/function-in-vb-script\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.scmgalaxy.com\/tutorials\/function-in-vb-script\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/function-in-vb-script\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.scmgalaxy.com\/tutorials\/"},{"@type":"ListItem","position":2,"name":"Function in vb script"}]},{"@type":"WebSite","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#website","url":"https:\/\/www.scmgalaxy.com\/tutorials\/","name":"scmGalaxy","description":"A Platform for Software Engineers","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.scmgalaxy.com\/tutorials\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#\/schema\/person\/fc12ad190f540e79460243c81148d102","name":"scmgalaxy K","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4b902ea8c77ee0a326c112f29d0edf51b7c3e1cd05c4fb92a810177e9c3f12a9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4b902ea8c77ee0a326c112f29d0edf51b7c3e1cd05c4fb92a810177e9c3f12a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b902ea8c77ee0a326c112f29d0edf51b7c3e1cd05c4fb92a810177e9c3f12a9?s=96&d=mm&r=g","caption":"scmgalaxy K"},"sameAs":["http:\/\/www.DevOpsSchool.com"],"url":"https:\/\/www.scmgalaxy.com\/tutorials\/author\/scmgalaxy\/"}]}},"_links":{"self":[{"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/posts\/2543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/comments?post=2543"}],"version-history":[{"count":1,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/posts\/2543\/revisions"}],"predecessor-version":[{"id":2544,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/posts\/2543\/revisions\/2544"}],"wp:attachment":[{"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/media?parent=2543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/categories?post=2543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/tags?post=2543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}