I need a substring in ASP

Author Name Status Posted Time Manvaalo Jinochi 5/30/2008 1:58:10 AM Author is Offline Hi all, How can I get a substring "Finance" from a string like "Business and Finance" and "Telecom" from "IT And Telecom " I want a substring from a string that start after "and" I need it in ASP Thanks manvaalo

Subject Author Status Date Re: I need a substring in ASP Mable Henning 5/30/2008 3:39:36 AM Hi Manvalo, Here is the code you need: Code: <% sString = "Business and Finance" sString = Mid(sString, InStr(sString, "and") + 4) Response.Write sString %> The InStr ASP/VBScript function will find the position of the first occurrence of one string within another. In this case the position of the string "and" within your main string. Then you add 4 to this number because the "and " string has 4 characters and you want to get the substring starting after "and ". Finally you use the Mid VBScript function which gets a substring starting from the position specified in the second parameter, in this case InStr(sString, "and") + 4 All the best! Post Comments Re: Thanx for the reply Manvaalo Jinochi 5/30/2008 3:43:24 AM Mable, Thanx for REPLY Manvalo  Post Comments Re: You're welcome! Mable Henning 5/30/2008 3:44:48 AM You're welcome Manvalo, If you have any questions, let me know. Post Comments

Related Forums Optimizing Images Get a Website Template for Free!!! Get a Website Template for Free!!! Do You Sell Your Templates on Ebay? Template Tutorials