VBA Regex pattern
I’m having some data appears to be like this and got this in CSV file
1305-0023, “4. Appropriate_icf for you version embarrasing version O1_01_SEZ02_9-03, 29-Nov-2023”, “Trialinning”, “da-3aff-41fe-8292-28f03”, “AMERICA”, “Initiated”, “SEZ6”, 2024-07-22T20:46:13.364843Z, “01bf9039-d66a-470b-a403-b7d63c8271ec”, “Upversion and downversion”, “In Process by Sponsor”, 2023-12-052024-09-09y35346282828, 400, “BRB BRB Approval Letter [Site]”, “tehdueuehjjkksjbbcgdh-dheyeyehhehe-ebhdbhdhjdjdd”, “Ongoing”, NULL, 2024-09-09y35346282828
Disregard Carriage Return or Line Break when Importing CSV with Macro
I am trying to import a CSV into Excel using a macro but some of the CSV data contains what appears to be CR Carriage Returns or LB Line Breaks. Instead of the CSV entry importing into the next one cell, it returns to the first column each time.