tmp := @If(region != "Mid-Atlantic";conf_dates;
@Trim(
@Transform(conf_schedule;"x";
@Replace(@If(@Word(x;"~|~";3) = "Out of Town Only";"";@Word(x;"~|~";1));@Replace(@If(@Word(x;"~|~";3) = "Out of Town Only";"";@Word(x;"~|~";1));conf_dates;"");""))));
@Text(@Adjust(@TextToTime(tmp);0;0;-1;0;0;0);"D0S0")

The @Transform and @Word combo worked quite nicely. And just for your info, the formula checks which region the person is in and gives them the dates that they can book accomodations for a conference. I bet I could have done it in 30 lines of Script.