Use Power Query's M language to quickly fix names, remove hidden characters, extract numbers, and merge columns.

Abstract: Water level recognition is significant for flood warnings in the hydrology industry, which mainly includes water gauge detection and water level line recognition. With the video surveillance ...