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]

__._,_.___

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

Messages in this topic (2)

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

.

__,_._,___