RE: SQL Replace Function for Strings

From: Michael (anonymous_at_discussions.microsoft.com)
Date: 06/06/04 

Date: Sun, 6 Jun 2004 03:11:02 -0700

Hi

I found the solution already.
The solution is to find the position of the colon and than extract the string using this value from all values.

For SQL: select KSName, SUBSTRING(KSName, PATINDEX('%:%',KSName)+1,1000) from job

In Access:SELECT dbo_Job.KSName, Mid( dbo_Job.KSName, InStr(dbo_Job.KSName,':')+1 ,1000) AS Expr1
FROM dbo_Job;

Relevant Pages

  • Re: simple gsub question ` what?
    ... I need to parse a string: ... How can I use gsub to extract everything before the colon? ... I've looked at the documentation and just can't understand how to use ...
    (comp.lang.ruby)
  • Re: simple gsub question ` what?
    ... I need to parse a string: ... and I need to extract everything before the: (colon) into one variable ...
    (comp.lang.ruby)
  • simple gsub question ` what?
    ... I need to parse a string: ... How can I use gsub to extract everything before the colon? ... I've looked at the documentation and just can't understand how to use ...
    (comp.lang.ruby)
  • Re: simple gsub question ` what?
    ... I need to parse a string: ... How can I use gsub to extract everything before the colon? ...
    (comp.lang.ruby)
  • Re: How do I pull the info from this PostScript?
    ... Do you just want to extract the title from a file, ... When anchorsearch returns true, the 'post' string ... SourceArrayDecode filter from the array, and cvx exec the filter. ...
    (comp.lang.postscript)