Load text without "Headers"

Sun, 06 Dec 2015 23:33:09 GMT

Hi guys!

I'm trying to load data to table on "Edit Script", but don't know how should i treat my data.

My load data is like (text), with NO headers name and with ";" as diference caracter:

8434108097693;61CM20030015100;shirt;CAMISA;CLÁSICA;M;00-02-04-06-08-10-12;

8434108097709;61CM20030015102;shirt;CAMISA;CLÁSICA;M;00-02-04-06-08-10-12;

8434108097716;61CM20030015104;shirt;CAMISA;CLÁSICA;M;00-02-04-06-08-10-12;

I would want to create table (in load) and create headers, like:

8434108097693;61CM20030015100;shirt;CAMISA;CLÁSICA;M;00-02-04-06-08-10-12;

is it possible ?

Have any one some ideia ?

Article:

LOAD
(probably create some "for" cicle for each line, and write for each line)

FROM E:\..\Data-*.txt (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Best regards,

Re: Load text without "Headers"

Mon, 07 Dec 2015 16:47:53 GMT

Thanks for "Allow".

I solve it, already!

Article:

LOAD

@1 As COD1 ,

@2 as COD2 ,

@3 as TYPE ,

....

From E:\..\Data-*.txt

(txt, codepage is 1252, no labels, delimiter is ';', msq);

Thanks!
VL