Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Algorithm Problem
Hi
I have a string which I would like to pass into my code The string - SBR_1_Ammonia,01246,0.15,,SBR_2_Ammonia,01246,0.94 ,,SBR_3_Ammonia,01246,0.11,,SBR_4_Ammonia,01246,0. 01,,, Broken down this means Name ,WeekDay ,Previous Value There are 4 records in the string each is separated by double commas, the end of the string is found by three commas each piece of the record is separated with a single comma looking at the first record it is - SBR_1_Ammonia - Name 01246 - Monday, Tuesday, Wednesday, Friday, Sunday - Weekdays to be included. 0.15 - Previous Value Lets say it is monday. The 0 indicates monday so I would like to check through the records collecting the values which have a flag for this day. All the records have a 0 so the string outut would look like - SBR_1_Ammonia,01246,0.15,,SBR_2_Ammonia,01246,0.94 ,,SBR_3_Ammonia,01246,0.11,,SBR_4_Ammonia,01246,0. 01,,, but suppose only the first and last records contained the 0 it would only show SBR_1_Ammonia,01246,0.15,,SBR_4_Ammonia,01246,0.01 ,,, Thanks for your assistance with this. I want to do some other things to it aswell but one step at a time. Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Algorithm Challenge | Excel Programming | |||
algorithm creation | Excel Programming | |||
can't find problem with permutation algorithm | Excel Programming | |||
help with algorithm | Excel Programming | |||
Need help with algorithm | Excel Programming |