Mar 17, 2005 #1 Jay2003 Programmer Feb 26, 2003 147 GB Hi, If I had a string of 20 characters would it be possible using VBS to split these into 4 different and place them into a table using ASP/VBS Regards Jason
Hi, If I had a string of 20 characters would it be possible using VBS to split these into 4 different and place them into a table using ASP/VBS Regards Jason
Mar 17, 2005 #2 Sheco Programmer Jan 3, 2005 5,457 US Yes. If all 4 "fields" are separated by a delimmitting character such as a comma or tab then you could use the Split() function to break it into an array. Alternatively if the fields are a set lenght you could use the Mid() function to pull only the characters that you want from the string. Another option is to user InStr() in conjunction with Mid() if your string is a little more complex. Upvote 0 Downvote
Yes. If all 4 "fields" are separated by a delimmitting character such as a comma or tab then you could use the Split() function to break it into an array. Alternatively if the fields are a set lenght you could use the Mid() function to pull only the characters that you want from the string. Another option is to user InStr() in conjunction with Mid() if your string is a little more complex.