While loading data from Xcel files I see an option called 'MaxLine' which is set to 1 by default.
Can anyone explain how this option is useful ?
Thanks !!
The Load
LOAD A,
B,
C,
D,
E
FROM
(ooxml, explicit labels, table is Übersicht);
Line Length:
8 //LOAD+Space+A,+Space
8 //5*Space+B,+Space
8
8
6 //5*Space+E
4 //FROM
43//FILE
45//PARAM
max. 1-8 it look like above
max. 9-10:
LOAD A,
B,
C,
D, E
FROM
(ooxml, no labels, table is Übersicht);
5*Space+D,+Space+E := 9
max. 11:
LOAD A, B,
C, D,
E
FROM
(ooxml, no labels, table is Übersicht);
LOAD+Space+A,+Space+B,+Space:= 11
max 12-13:
LOAD A, B,
C, D, E
FROM
(ooxml, no labels, table is Übersicht);
5*Space+c,+Space+D,+Space+E :=12
max 14-16:
LOAD A, B, C,
D, E
FROM
(ooxml, no labels, table is Übersicht);
max 17:
LOAD A, B, C, D,
E
FROM
(ooxml, no labels, table is Übersicht);
max 18-47:
LOAD A, B, C, D, E
FROM
(ooxml, no labels, table is Übersicht);
max 48-86:
LOAD A, B, C, D, E
FROM
(ooxml, no labels, table is Übersicht);
max 87-...:
LOAD A, B, C, D, E
FROM
If you dont want a long list you can enter a bigger value, the Fields listet like below:
LOAD B, C, D, E, F, G, H, I, J, K, L,
M, N, O, P, Q, R, S, T, U, V, W,
X, Y, Z, AA, AB, AC, AD, AE, AF,
AG, AH, AI, AJ, AK, AL, AM, AN,
AO, AP, AQ, AR, AS, AT, AU, AV,
AW, AX, AY, AZ, BA, BB, BC, BD,
BE, BF, BG, BH, BI, BJ, BK, BL,
BM, BN, BO, BP, BQ, BR, BS, BT,
BU, BV, BW, BX, BY, BZ, CA, CB,
CC, CD, CE, CF, CG, CH, CI, CJ,
CK, CL, CM, CN, CO, CP, CQ, CR,
CS, CT, CU, CV, CW, CX, CY, CZ,
DA, DB, DC, DD, DE, DF, DG, DH,
DI, DJ, DK, DL, DM, DN, DO, DP,
DQ, DR, DS, DT, DU, DV, DW, DX,
DY, DZ, EA, EB, EC, ED, EE, EF,
EG, EH, EI, EJ, EK, EL, EM, EN,
EO, EP, EQ, ER, ES, ET, EU, EV,
EW, EX, EY, EZ, FA, FB, FC, FD,
FE, FF, FG, FH, FI, FJ, FK
FROM[Al.xlsx]
(ooxml, no labels, table is Gesamtservicelevel);
The spaces at the beginning of each row are countet also. Min one field in a row is loaded and then it is filled to the end of youre limit. The limit is number of signs.
Dear Jonas and Massimo,
Many thanks for your help and answers.
I am still not very clear if I understand it right ?
So if I sent Maxline to '5' does it mean that I can only give maxmum of five fields in one line like
Load F1, F2, F3, F4, F5
F6,F7,F8,F9, F10
From A.xlsx
And later when i change the Maxline to 10 it takes all 10 fields on the same line ?
Best Regards,
M.Aushik
if you set it to 5 it will fill the line to the sign 5, but it will always minimum of one field in the line.
Hi Jonas,
'if you set it to 5 it will fill the line to the sign 5 ' - does it mean till t encounters 5 delimiter signs ?
The Load
LOAD A,
B,
C,
D,
E
FROM
(ooxml, explicit labels, table is Übersicht);
Line Length:
8 //LOAD+Space+A,+Space
8 //5*Space+B,+Space
8
8
6 //5*Space+E
4 //FROM
43//FILE
45//PARAM
max. 1-8 it look like above
max. 9-10:
LOAD A,
B,
C,
D, E
FROM
(ooxml, no labels, table is Übersicht);
5*Space+D,+Space+E := 9
max. 11:
LOAD A, B,
C, D,
E
FROM
(ooxml, no labels, table is Übersicht);
LOAD+Space+A,+Space+B,+Space:= 11
max 12-13:
LOAD A, B,
C, D, E
FROM
(ooxml, no labels, table is Übersicht);
5*Space+c,+Space+D,+Space+E :=12
max 14-16:
LOAD A, B, C,
D, E
FROM
(ooxml, no labels, table is Übersicht);
max 17:
LOAD A, B, C, D,
E
FROM
(ooxml, no labels, table is Übersicht);
max 18-47:
LOAD A, B, C, D, E
FROM
(ooxml, no labels, table is Übersicht);
max 48-86:
LOAD A, B, C, D, E
FROM
(ooxml, no labels, table is Übersicht);
max 87-...:
LOAD A, B, C, D, E
FROM
It is the fifth sign not Fields, it is to use the minimum place without scrolling to the right. Most code editors using styles with same width of each caracter so you can create a block wich use youre full display size without horizen scrolling. there are also some editors wich create a new line if you get to the right of the display, if youlimit it that no automatic linefeet is generatett it looks all the same. The line numbers and the reading is not changing.
Dear Jonas,
It is clear now...many many thanks for your details answer and time...
Much appreciated!!!