🚀 go-pugleaf

Hi all,

I have a comma delimited file that I normally manipulate in Excel, but I
really want to speed things up by automating it. With some help from this
newsgroup, I think I can do this in VB.

The comma delimited file (http://www.swandust.com/rpt_cdc_new.txt) needs to
be converted into a very similar file
(http://www.swandust.com/rpt_cdc_changed.txt). I don't want to make a
lengthy post, so I'll take baby steps first and just do a portion of what is
needed for rpt_cdc_changed. Once this is accomplished, I can explain the
remaining steps in a future post. I think the easiest way to explain what I
did is to walk you through the steps I take in Excel to make
rpt_cdc_changed.txt.

1) Import rpt_cdc_new.txt into Excel.
2) Insert a column titled "SortCode" inbetween "Stop" and "Week".
3) The formula in the "SortCode" column is something like
=CONCATENATE(E2,IF(C2="a","AC",IF(C2="b","BD",IF(C2="c","AC","BD"))),D2)
4) Create 5 rows after "Cust No" titled "DelType", Route Code", "Seq1" and
"Seq2"

If VB can automate this with a click of a buttom, I'll be so happy. Thanks
in advance.

Mike