Mar 17, 2005 #1 Jay2003 Programmer Joined Feb 26, 2003 Messages 147 Location 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 Joined Jan 3, 2005 Messages 5,457 Location 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.