472,121 Members | 1,484 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,121 software developers and data experts.

Search character

How to i search the colon in the data and then pick characters after
colon. for eg:

ACTUAL DATA
Date: Fri Aug 04 15:14:38 EDT 2006

REQURED DATA
Fri Aug 04 15:14:38 EDT 2006

Thanks,

Aug 10 '06 #1
2 1217

Eric wrote:
How to i search the colon in the data and then pick characters after
colon. for eg:

ACTUAL DATA
Date: Fri Aug 04 15:14:38 EDT 2006

REQURED DATA
Fri Aug 04 15:14:38 EDT 2006

Thanks,
reqdDate = Replace(actualData,"Date: ","")

--
Mike Brind

Aug 10 '06 #2
Eric wrote:
How to i search the colon in the data and then pick characters
after colon. for eg:

ACTUAL DATA
Date: Fri Aug 04 15:14:38 EDT 2006

REQURED DATA
Fri Aug 04 15:14:38 EDT 2006
JScript:
output = input.replace(/.*:/,"")

vbscript:
Set re = New RexExp
re.Pattern = ".*:"
output = re.Replace(input,"")

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.
Aug 10 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by pembed2003 | last post: by
4 posts views Thread by Nikos | last post: by
7 posts views Thread by Bonj | last post: by
1 post views Thread by Eric | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.