Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have this problem
an excel file field name PRODCD but with value of alphanum
if the value of this field contains numeric, automatically excel expect it to be numeric, so if i have other record with alphanum it will create confusion in loading.
My question is how do i convert it during loading (in edit script) because i have a table with the same field name so that i can get full product name when i reload.
Hi,
No autogenerate is for example see the sample file once again.
And see the load statement and Sample atachment also.
load Text(Column) as StringCol;
Temp:
LOAD * INLINE [
Column
1234566
1213sdad
sdasd4565
dsd445
efdfd
dsds458
dfdfs885
yytyty555
5555
111
111
];
Regards,
Anand
im using PE of QV ..
tried this .. tnx..
ok other obsrvation is when i send this to excel...
the prodcd field will be autotically set numeric to those value is all number ... how could i force to set this field to string?
load Text(trim(Column)) as StringCol;
Temp:
LOAD * INLINE [
Column
1234566
1213sdad
sdasd4565
dsd445
efdfd
dsds458
dfdfs885
yytyty555
5555
111
111
];