///$tab Main SET ThousandSep=','; SET DecimalSep='.'; SET MoneyThousandSep=','; SET MoneyDecimalSep='.'; SET MoneyFormat='$#,##0.00;($#,##0.00)'; SET TimeFormat='h:mm:ss TT'; SET DateFormat='M/D/YYYY'; SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'; SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'; SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'; t1: LOAD [@1:n] as a FROM [C:\Users\******\Desktop\New folder\community\95.txt] (fix, codepage is 1252, embedded labels); t2: load Replace(a, TextBetween(a,'"','"') ,Replace(TextBetween(a,'"','"'),',',' ')) as a1 resident t1; drop table t1; t3: load subfield(a1,',',1) as UNQ_ID_SRC_STM, subfield(a1,',',2) as CUSTOMER_NAME, subfield(a1,',',3) as UNQ_ID_SRC_STM2, subfield(a1,',',4) as OWNED_BY_BR, subfield(a1,',',5) as APPNUM, subfield(a1,',',6) as ADR_LNE_1, subfield(a1,',',7) as ADR_LNE_2, subfield(a1,',',8) as ADR_LNE_3, subfield(a1,',',9) as ADR_LNE_4 Resident t2; drop table t2;