C
CSINVA
I get data in the form of a csv file and I need to change one field
that that looks like this:
Col C (for example)
MORNING/EST
AFTERNOON/PACIFIC
WEEKEND/MST
I would like to break the cells into 2 different col one for time
(morning/afternoon, etc) and one for time zone (est, pacific, mst)
So I guess I need to count over to the / then take the timezone info
and pass it through a series of case statements, est = estern, mst =
mountain, and then put that into a new colunm.
I need to make this available whenever I open the file and not have to
recreate the code everything I get a new file.
Thanks for any help
that that looks like this:
Col C (for example)
MORNING/EST
AFTERNOON/PACIFIC
WEEKEND/MST
I would like to break the cells into 2 different col one for time
(morning/afternoon, etc) and one for time zone (est, pacific, mst)
So I guess I need to count over to the / then take the timezone info
and pass it through a series of case statements, est = estern, mst =
mountain, and then put that into a new colunm.
I need to make this available whenever I open the file and not have to
recreate the code everything I get a new file.
Thanks for any help