This live demo begins to wrap up Chad’s series on text parsing by providing a real world example. If this is your first look at series you might want to review each function in more detail. There’s a list of links below to make that a bit easier. Happy Text Parsing! Left functions video. Right functions video. Middle functions video. PatternCount function video. Substitute and GetValue functions video.