So it is separate by chr(13). This seems like a bug in Apex to me.
HTML does NOT use the same carriage return + line feed as database. You have the CR+LF characters in the field, and the search can't deal with them properly. To html a <br> is a line break. To be honest your database design leaves something to be desired..
I would save this as MTWTHF and get rid of the break between..
Los Alamos, NM
It is broken up to be on separate lines so the different schedules for a class line up the same.
So MWF 9-950 Building A
TR 11-150 Building B
where days, times, and buildings are in their own column. Makes it easy for students to read.
Lol, probably but I am stuck with how the university stored the data, so I only have control over the table that combines the data from various per-existing tables.
So it is a bit difficult getting things to work and look nice in the app when the data that was originally stored isn't very neat.
But your answer makes sense, and honestly wouldn't have thought it as a html not being able to handle those characters. Still new to apex.
Thanks for your help.