Tecnologia, programação e muito Visual FoxPro.

terça-feira, 12 de abril de 2011

]] XL-mania [[ data text ke excel

A/C TYPE : ATR/AT42300< K
KP0922/11APR11 PNK-KTG 31 Y 09.02F
FROM PONTIANAK INDONESIA< -
---------------------------------- #NAME?
TO KETAPANG INDONESIA< <
<
1 52288000124041 AGUSTINA MR F Y 09A 3/030 E1FO1
INF-52288000124030.CALVIN INF E1<
EBT-88830000338830/010 KGS 1<
2 52277000540282 ABALLUDIN MR M Y 03A 1/007 E1FO1
3 88810005531351 ALENSUKARDI MR M Y 06B 0/000 1 O1
4 52288000124004 DRAHJSANGADAH MR F Y 01A 2/020 E1FO1
5 52288000124015 DRASYARIFAH MR M Y 01B 0/000 E1FO1
6 52288000124111 ELMANTONO MR M Y 04A 1/007 E1FO1
7 52288000123094 HASMIHAMDANSH MR M Y 12A 5/040 E1FO1
EBT-88830000338863/010 KGS 1< )
FCN-8881000541796-99< 8
8 52288000123105 HJMISNAWATI MR F Y 12B 0/000 E1FO1
FCN-8881000541796-99< 9
9 52288000123131 HENDRAGUNAWAN MR M Y 07A 0/000 E1FO1 10
10 52288000123886 HADISADRI MR M Y 08A 0/000 E1FO1 11
11 52288000123875 HABANGHAMDI MR M Y 06D 0/000 E1FO1 12
12 52288000123116 IBNULAYARDASOS MR M Y 12C 0/000 E1FO1
FCN-8881000541796-99< 13
13 52288000141515 IMAKULATA MI F Y 05A 0/000 E1FO1 14
14 52288000123153 IMAMBAHRUDIN MR M Y 06A 0/000 E1FO1
FCN-888100053941< 15
15 52288000124026 IRRODIRUSTAMAN MR M Y 01C 0/000 E1FO1 16
16 88810005530133 KHERI MR M Y 03C 1/017 1 O1
EBT-88830000338874/007 KGS 1< 17
17 52288000123945 MARIEALI MR M Y 05D 1/005 E1FO1 18
18 52288000141666 NORDI MR M Y 12D 0/000 E1FO1 19
19 52288000123901 NURSIAH MR F Y 11D 0/000 E1FO1 20
20 52288000124166 PRAYONO MR M Y 11A 1/010 E1FO1
FCN-8881000540535< 21
21 52288000123654 ROBI MR M Y 08C 0/000 E1FO1)?
22 52277000540293 RUSYATIMAH MR F Y 10A 1/014 E1FO1
EBT-88830000338841/004 KGS 1< 2
23 52288000123492 SUNCIU MR M Y 10D 0/000 E1FO1 2
24 52288000123186 SYARIFALWI MR M Y 04D 0/000 E1FO1
FCN-888100054646< 2
25 52288000123912 SUMITRA MR M Y 11C 2/013 E1FO1 2
26 52288000124100 SATRIASUGANDI MR M Y 07D 0/000 E1FO1 2
27 52288000124214 SOFIAN MR M Y 01D 0/000 E1FO1 2
28 52288000123665 TERIANUS MR M Y 08D 0/000 E1FO1
FCN-8881000553255-56< 2
29 52288000124052 UTIBUKRAN MR M Y 09B 0/000 E1FO1 3
30 52288000141596 YULI MR F Y 04C 0/000 E1FO1 3
31 88810005531340 YULIANUSPRANACI | MR M Y 06C 0/000 1 O1<
< <
<
ADULT CHIL D INFANT< TO
TOTAL PAX F CLASS 0 0 0<
C CLASS 0 0 0<
Y CLASS 31 0 1< )?

------------ ----------<
31 0 1< TOTAL B
TOTAL BAGGAGES FLT.CPN TKT ETK EBT TRANS.PAX MCO 1
18/00163 32 3 29 4/00031 KGS 000 000<

PASSENGER AND BAGGAG E MANIFEST KP40980922
-------------------- ----------< A/C TYPE :
A/C TYPE : ATR/AT42300< KP0922/11A
KP0922/11APR11 PNK-PKN 5 Y 09.02FROM PON
FROM PONTIANAK INDONESIA< ----------
---------------------------------- #NAME?
TO PANGKALANBUN INDONESIA< <
< 1 522880
1 52288000124085 ANI MR F Y 02D 3/024 E1FO1 EBT-88
EBT-88830000338826/004 KGS 1< )?
2 52288000123536 NATU MR M Y 09C 2/027 E1FO1 3 5228
3 52288000123606 PHE MEN M Y 03D 5/021 E1FO1 EBT-
EBT-88830000338815/011 KGS 1<
FCN-8881000553069< 4 5228
4 52288000124096 SWINI MR F Y 02C 0/000 E1FO1 5 5228
5 52288000123540 YASON MR M Y 09D 0/000 E1FO1<
< <
<
ADULT CHIL D INFANT< TOTAL PA
TOTAL PAX F CLASS 0 0 0<
C CLASS 0 0 0<
Y CLASS 5 0 0<
------------ ----------<
5 0 0< TOTAL
TOTAL BAGGAGES FLT.CPN TKT ETK EBT TRANS.PAX MCO
10/00072 5 0 5 2/00015 KGS 000 000<
KALSTAR AVIATION< <
<
PASSENGER AND BAGGAG E MANIFEST KP40980922
-------------------- ----------< A/
A/C TYPE : ATR/AT42300< KP
KP0922/11APR11 PNK-SMQ 4 Y 09.02FR
FROM PONTIANAK INDONESIA< --
---------------------------------- #NAME?
TO SAMPIT INDONESIA< <
<
1 52288000124181 ARDIANSYAH MR M Y 02A 2/022 E1FO1
FCN-8881000553095-7<
2 52288000124192 ERNININGSIH MR F Y 02B 0/000 E1FO1
INF-52288000124203.ARIEL INF E1<
FCN-8881000553095-7<
3 52288000123190 HASANBASRI MR M Y 05B 0/000 E1FO1
FCN-8881000997998<
4 52288000123573 KHOZIN MR M Y 04B 1/010 E1FO1<
ADULT CHILD INFANT< TOTA
OTAL PAX F CLASS 0 0 0<
C CLASS 0 0 0<
Y CLASS 4 0 1<
------------- ---------<
4 0 1< TOTA
OTAL BAGGAGES FLT.CPN TKT ETK EBT TRANS.PAX MCO
3/00032 5 0 5 0/00000 KGS 000 000<
<

KP0922/11APR11 PNK-BDJ 1 Y 09.02FRO
FROM PONTIANAK INDONESIA< ---
---------------------------------- #NAME?
TO BANJARMASIN INDONESIA< <
< 1
1 52288000123072 TEHNIK MR M Y 03B 0/000 E1FO1<
< <
<
ADULT CHIL D INFANT< TOT
TOTAL PAX F CLASS 0 0 0<
C CLASS 0 0 0<
Y CLASS 1 0 0<
------------ ----------<
1 0 0< TOT
TOTAL BAGGAGES FLT.CPN TKT ETK EBT TRANS.PAX MCO
0/00000 1 0 1 0/00000 KGS 000 000<
-------------------- ----------< A/C
A/C TYPE : ATR/AT42300< KP09
KP0922/11APR11 KTG-PKN 4 Y 09.33FROM
FROM KETAPANG INDONESIA< ----
---------------------------------- #NAME?
TO PANGKALANBUN INDONESIA< <
< 1
1 52288000141821 AGUS MR M Y 01A 0/000 E1CO2 2
2 52288000141876 HENDRI MR M Y 01B 0/000 E1CO2 3
3 52288000141902 HADI MR M Y 01D 1/010 E1CO2 4
4 52288000141946 SYARIFAHSALAMAH MR F Y 03A 0/000 E1CO2
INF.SYARIF HUSE IN INF< <

ADULT CHIL D INFANT< TOTA
TOTAL PAX F CLASS 0 0 0<
C CLASS 0 0 0< )?
Y CLASS 4 0 1<
------------ ----------<
4 0 1< TOTAL
TOTAL BAGGAGES FLT.CPN TKT ETK EBT TRANS.PAX MCO
1/00010 4 0 4 0/00000 KGS 000 000<


<
PASSENGER AND BAGGAG E MANIFEST KP40980922
-------------------- ----------< A/C TY
A/C TYPE : ATR/AT42300< KP0922
KP0922/11APR11 KTG-SMQ 0 Y 09.33FROM
FROM KETAPANG INDONESIA< ------
---------------------------------- #NAME?
<
ADULT CHIL D INFANT< TOTAL PA
TOTAL PAX F CLASS 0 0 0<
C CLASS 0 0 0<
Y CLASS 0 0 0<
------------ ----------<
0 0 0< TOTAL
TOTAL BAGGAGES FLT.CPN TKT ETK EBT TRANS.PAX MCO
0/00000 0 0 0 0/00000 KGS 000 000<

PASSENGER AND BAGGAG E MANIFEST KP40980922
-------------------- ----------< A/C TYPE
A/C TYPE : ATR/AT42300< KP0922/1
KP0922/11APR11 KTG-BDJ 3 Y 09.33FROM K
FROM KETAPANG INDONESIA< )?
---------------------------------- #NAME?
TO BANJARMASIN INDONESIA< <
< 1
1 52288000141880 DEDI MR M Y 07B 0/000 E1CO2 2
2 52288000142042 GERI MR M Y 07A 0/000 E1CO2 3
3 52288000141736 MIKAELSRIWANTO MR M Y 04D 0/000 E1CO2<
< <
<
ADULT CHIL D INFANT< TOT
TOTAL PAX F CLASS 0 0 0<
C CLASS 0 0 0<
Y CLASS 3 0 0<
------------ ----------<
3 0 0< TOT
TOTAL BAGGAGES FLT.CPN TKT ETK EBT TRANS.PAX MCO
0/00000 3 0 3 0/00000 KGS 000 000<
KALSTAR AVIATION<
<
PASSENGER AND BAGGAG E MANIFEST KP4098
-------------------- ----------<
A/C TYPE : ATR/AT42300<
KP0922/11APR11 PKN-SMQ 2 Y 0
FROM PANGKALANBUN INDONESIA<
---------------------------------- --------------------------
TO SAMPIT INDONESIA<
<
1 52288000202662 ARYYUDHANINGSIH MR F Y 10A 1/013 E
2 52288000202673 DENISJAYANEGARA MR M Y 10B 0/000 E
<
<
ADULT CHIL D INFANT<
TOTAL PAX F CLASS 0 0 0<
C CLASS 0 0 0<
Y CLASS 2 0 0<
------------ ----------<
2 0 0<
TOTAL BAGGAGES FLT.CPN TKT ETK EBT TRANS.PAX MCO
1/00013 2 0 2 0/00000 KGS 000 000<

PASSENGER AND BAGGAG E MANIFEST KP40980922
-------------------- ----------< A/
A/C TYPE : ATR/AT42300< KP
KP0922/11APR11 PKN-BDJ 23 Y 09.39FR
FROM PANGKALANBUN INDONESIA< --
---------------------------------- #NAME?
TO BANJARMASIN INDONESIA< <
<
1 52288000163381 ABDULHARIF MR M Y 11A 3/030 E1CO2
2 52288000163565 GUNAWAN MR M Y 01D 0/000 E1CO2
3 52288000163801 GDPUTUARYAWK MR M Y 10C 0/000 E1CO2
4 52288000163344 HABDAZIZ MR M Y 09B 2/021 E1CO2)?
5 52288000163296 HAERUDDINTAHIR MR M Y 06D 0/000 E1CO2
6 52288000163053 HENDROGUNAWANLIM MR M Y 05D 0/000 E1CO2
7 52288000162633 IWANSUHARIYADI MR M Y 04A 0/000 E1CO2
8 52288000163300 JOKOPERMANA MR M Y 06C 0/000 E1CO2
9 52288000163495 JANNYJOHANADEHO| MR M Y 01A 1/013 E1CO2 1
10 52288000163355 KHMUHIDINARIFIN MR M Y 09C 3/011 E1CO2 1
11 52288000163812 KIMI MR M Y 10D 0/000 E1CO2 1
12 52288000163366 MARFUAH MR F Y 09A 0/000 E1CO2 1
13 52288000163311 MAMANFIRMANSYAH MR M Y 06B 0/000 E1CO2 1
14 52288000163263 MAGUS MR M Y 08B 1/013 E1CO2 1
15 52288000163506 PAULUSVANDERVEL| MR M Y 01B 2/010 E1CO2 1
16 52288000163532 PRAMESTIPUTRA MR M Y 07D 0/000 E1CO2 1
17 52288000163274 RAWIYAH MR F Y 08C 0/000 E1CO2
INF-52288000163333.ZAFIRAH INF E1< 1
18 52288000163241 SANITEGUH MR M Y 03A 0/000 E1CO2 1
19 52288000163576 SLAMETWIYONO MR M Y 03D 0/000 E1CO2 2
20 52288000163742 SUDIONO MR M Y 02D 1/010 E1CO2 2
21 52288000163322 TONISANTOSO MR M Y 06A 0/000 E1CO2 2
22 52288000163285 UMAR MR M Y 08A 1/000 E1CO2 2
23 52288000241906 WITAMILYANSARI MR F Y 08D 0/000 E1CO2)?
ADULT CHIL D INFANT< TOTA
TOTAL PAX F CLASS 0 0 0<
C CLASS 0 0 0<
Y CLASS 23 0 1<
------------ ----------<
23 0 1< TOTA
TOTAL BAGGAGES FLT.CPN TKT ETK EBT TRANS.PAX MCO
14/00108 24 0 24 0/00000 KGS 000 000<
Para pakar excel,

Mohon bantunya untk memindahkan data dari text ke Excel.
terima kasih atas bantuannya.
sy lampirkan juga contoh file.

thanks.
iwan

Nenhum comentário:

Arquivo do blog