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]
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
----------------------------------
Tidak ada komentar:
Posting Komentar