11-21-2016 07:24 AM
I've a file to read where fields are wrapped using quotes ("Field-Value") and fields are seperated by comma(,). What is the suitable DLM option to be used ?
I tried using DLMSTR='","' -> It worked fine untill there was a null value for a field.
Example Record in the file is as below
I want to read above record so that I get below output, where F1-F9 are variables.
F1=A, F2=B, F3=C, F4=D, F5= (Blank), F6=F, F7= (Blank), F8=H, F9= (Blank)
Need further help from the community? Please ask a new question.