1. I have a 'note' field with an Item Number 'WIDGET1000' 2. I'm parsing 'WIDGET1000' with the first calculated field into a NEW Calculated field 'NotePartNum' 3. I then create another calculated field 'KEY', and run a 'LIKE' formula comparing 'PARTNUMBER' against 'NotePartNum' which gives me a 'TRUE' or 'FALSE'.
The problem is: ALL rows with 'ETA 5/7' are indicating 'FALSE'. Rows with no characters after 'WIDGET1000' are showing 'TRUE'? This is where I'm having my problem.
NOTE FIELD (NOTE) Calculated Field ABC WIDGET1000 ETA 5/7 =Mid(Fields!NOTE.Value,5,10)
(KEY) Calculated Field =(Fields!PARTNUMBER.Value)LIKE(Fields!NotePartNum.Value)
Thanks and any suggestions are highly appreciated.