Line skip during IMPORT data- [BLANK]

Nov 23, 2019 12:31AM

Hi Experts,

i have below 4 records with semi-colon separated and column 5 is hte product description.

when i try to load this file, any description contains double quote is skipping with BLANK

1234;203040;03;1000046;Sample description;;-2415;-25043

1234;506070;03;9999999;description, with, comma,seperated;;-1;0

1234;500600;03;8888888;double" quote given;;0;163316

1234;123456;03;2233445;"double quote given;;0;1378

so what ever lines with double quote is skipping, i am using BEFIMPORT script and AFTIMPORT.

is there a way to replace these lines in the BEFIMPORT script.

Because the IMPORT scripts is not application, these lines get skipped before it reached to IMPORT script logic

my solution:

for now i used a for loop to read each line of record and pull this columns "DESC" and used find & replace.

Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)