Re: [ExcelVBA] need Vba script in excel

 

please describe what you have done so far to work out a solution, can
you get the data below as CSV ot fixed length format? It will make
life a lot easier

NB this is a group to help you find a solution, not a workshop to
deliver you up a turnkey script!

Dr B

On 27 January 2012 14:12, tapas <tapas.sh@gmail.com> wrote:
> Hi,
>
> I need a vba script and input file & output file is given below. Input file was saved in text format.I need to collect the U#############AMA & record count in output 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
>
>
> Desire output file:
> ===================
> U120125011383AMA       25002
> U120125183601AMA       167971
>
>
> Please provide the vba script.
>
>
>
>
> ------------------------------------
>
> ----------------------------------
> 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
>
> ----------------------------------Yahoo! Groups Links
>
>
>

--
===========================
http://uk.linkedin.com/in/drjohnbullas

__._,_.___

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

Messages in this topic (4)

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

.

__,_._,___