Dividing fields with an embedded delimiter #56
Description
Received by email "A user has a CSV file with a field with a delimiter within the field data. For example, a field named City with “city, postcode” in the fields. Can the user split the information into two new fields: Suburb and Postcode? The user wants to divide the City field from all records into new fields. The delimiter in the original field is “,”, the same delimiter in the original CSV file."