RE: [ExcelVBA] need Vba script in excel

 

Lisa, I had the same thoughts.

Double hmmmm. J

Determine length of string. Search for "NotSent/", search for "has
been", search for "Count: ". Use MID() and RIGHT() and some maths to
find the required text, store them as variables / in new cells, and
record all steps with a macro, of course.

I am sure that tapas can do that, show us the written code and them ask
for more pointers if required.

Paul

From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of 1z@compuserve.com
Sent: Saturday, 28 January 2012 12:29 AM
To: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] need Vba script in excel

Hmmmm....

These groups are more to help people rather than to just supply code.
What problems are you having writing code yourself?

Having said that... Are the input records all on one line like...
INFO SDM BILLING DISK STREAM= AMA: File
/sba/ama/closedNotSent/U120125011383AMA has been moved from Open to
ClosedNotSent Record Count: 25002

... or is ...INFO SDM BILLING DISK one line...
... and ...
STREAM= AMA: File /sba/ama/closedNotSent/U120125011383AMA
has been moved from Open to ClosedNotSent Record Count: 25002
... one line??

As a hint... *If* the second part is one line... I'd use Split on ":"
and then on "/" and search through the resultant array for
Left(Array(),1) = "U" And Right(Array(),3 = "AMA".

Regards
Lisa

Sent: Fri, Jan 27, 2012 4:20 pm
Subject: [ExcelVBA] need Vba script in excel

Hi,
I need a vba script and input file & output file is given below. Input
file was
aved in text format.I need to collect the U#############AMA & record
count in
utput file
input file:
==========
INFO SDM BILLING DISK
STREAM= AMA: File /sba/ama/closedNotSent/U120125011383AMA
has been moved from Open to ClosedNotSent Record Count: 25002

INFO SDM BILLING DISK
STREAM= AMA: File /cbmdata/00/billing/ama/closedNotSent/U1201
25183601AMA has been moved from Open to ClosedNotSent Record Count:
167971

esire output file:
==================
120125011383AMA 25002
120125183601AMA 167971

lease provide the vba script.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 7

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___