String in Excel to handle a column URL URL for a column of a CSV file
1. The URL URL of a column of a CSV file is now escaped after a string. Example:
http:\/\/www.jammerall.com\/product_images\/p\/035\/JMHigh_Sensitivity_and_Long_Range_From_0_to_6GHz_Drone_Alarmer_3__03159_zoom.jpg
2. Because it is planned to import the CSV file into WooCommerce’s products, the URL is mapped as a picture. If it is escaped, the picture is empty after importing. After deciding to deliberate, import again.
3. Select the column to be replaced, find the replacement method, press Ctrl+H to open the replacement window, and enter the search content input: \/ Replace with input:/ Click ‘Replace All’. as shown in Figure 1
