Hi All, I have an csv file with around 5 fields, one of this field (field 3) is an free text column in the source system. I.E., user can type an message in it, so this field has carriage return value, special char, quotes, alt+enter. Also, length of the field 3 is variable, depends on the user message. So that data of the field 3 is distributed in multiple lines per observation in few rows and in one line per observation in few rows, basically depends on the length of the text. Fields description Field 1 – emp id Field 2 - dept id Field 3 – free text, it includes comma or special character, carriage return Field 4 - Product code Field 5 - country code Sample data 001,12A, Tues to Friday John rotates with Team, Perm 10800-1645 Sat Perm 8am starts Tue to Sat as of 22/02, cards, UK 002,12B, Mon to Wed Marry rotates with Team, Perm 0800-1645 Sat Perm 8am starts Tue to Sat as of 22/02 Works in shift, HL, UK 003,12c, Sat&Sun Paul rotates with Team, Perm 19000-1645 Sat,HL, UK 004,12D, All day Joe rotates with PL Team, Perm 10800-1645 Sat 8am starts Tue to Sat as of 24/02 Works in shift, CC, UK Even I am okay if I exclude the field 3 and read the rest of the fields correctly. I tried with PROC Import but not able to find an option of excluding the particular column/fields. Field 3 data highlighted in red colour. Please suggest an approach to read this csv file.
... View more
