1. A certain column of URL addresses in the CSV file is currently in an escaped string state. Example:
Plaintext
http:\/\/www.jammerall.com\/product_images\/p\/035\/JMHigh_Sensitivity_and_Long_Range_From_0_to_6GHz_Drone_Alarmer_3__03159_zoom.jpg
2. Since I plan to import the CSV file into WooCommerce products, the URLs will be mapped to images. If they are escaped, the images will be empty after import. I decided to unescape them and then import again.
3. Select the column to be replaced. Using the find and replace method, press Ctrl+H to open the replace window. Enter \/ in the “Find what” field, enter / in the “Replace with” field, and click “Replace All”. As shown in Figure 1.
