aplicatia 6 - functii de consultare si functii text (2)
Post on 25-Feb-2018
252 Views
Preview:
TRANSCRIPT
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 1/31
Cod client 105
Adresa Localitate Judeţ
107Client1 Str. Florilor nr.36 bl.8 Pitesti Arges104Client2 Str. Sincai nr.45, sc. Bcresti Bcre!ti
102Client7 Str. A"eresc Braso" Bra!o"
101Client4 Str. 1 #ai nr.36, bl A8Ploiesti Pra$o"a
105Client3 Str. % #ai Bcresti Bcre!ti
100 Client7 Str. Plo&ilor nr.1 B'rlad (asli
108Client8 Str. )teran* nr. 3 +e"a nedoara
Cod Fiscal 23187%46
CodClient
NumeClient
S* se rec&ere-e codul fscal al clientli al c*ri cod a os
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 2/31
Cod Fiscal
3465564513246873
%6325814
75315%46
23187%46
64821%73
57351%84
selectat dintr/o list* derlant* locali-at* la adresa 2.
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 3/31
Cod ISBN Titlu carte
2C+ SB S Co&ania de libr*Bcre!ti
73/6842/67/4 +esign eb Co&ania de libr* Bcre!ti
73/6842/67/3(isal Basic or A&&licatio)ibr*ria 9Central9 Sibi
73/6842/67/5 Ba-e de +ate (o: 2000 Bcre!ti
73/6842/67/6;ce 2010 / A&lica<ii Co&ania de libr*Bra!o"
73/6842/67/6 ;ce 2010 / A&lica<ii )ibr*ria 9Central9 Cl=
73/6842/67/5 Ba-e de +ate olCris Sibi
73/6842/67/4 +esign eb olCris Bcre!ti
73/6842/67/6 ;ce 2010 / A&lica<ii olCris Bcre!ti
73/6842/67/7 e$nologia a&lica<iilor ;(o: 2000 Cl=
73/6842/67/7e$nologia a&lica<iilor ;Co&ania de libr*Bcre!ti
73/6842/67/6;ce 2010 / A&lica<ii Co&ania de libr*Bcre!ti
73/6842/67/7e$nologia a&lica<iilor ;Co&ania de libr*Bra!o"
73/6842/67/8Prograarea calclatoareolCris Bcre!ti
73/6842/67/7e$nologia a&lica<iilor ;olCris Bcre!ti
73/6842/67/3(isal Basic or A&&licatio)ibr*ria 9Central9 Sibi73/6842/67/3(isal Basic or A&&licatioCo&ania de libr*Bcre!ti
73/6842/67/8 Prograarea calclatoare(o: 2000 Bcre!ti
73/6842/67/4 +esign eb (o: 2000 Sibi
73/6842/67/7e$nologia a&lica<iilor ;Co&ania de libr*Bra!o"
73/6842/67/4 +esign eb )ibr*ria 9Central9 Sibi
73/6842/67/7e$nologia a&lica<iilor ;olCris Sibi
73/6842/67/8Prograarea calclatoareolCris Cl=
73/6842/67/5 Ba-e de +ate olCris Bcre!ti
73/6842/67/% SA+ olCris Bcre!ti
73/6842/67/3(isal Basic or A&&licatioCo&ania de libr*Bra!o"
73/6842/67/7e$nologia a&lica<iilor ;Co&ania de libr*Bcre!ti
73/6842/67/5Ba-e de +ate Co&ania de libr*Bcre!ti
73/6842/67/7e$nologia a&lica<iilor ;)ibr*ria 9Central9 Sibi
73/6842/67/% SA+ )ibr*ria 9Central9 Cl=
73/6842/67/5 Ba-e de +ate (o: 2000 Bra!o"
Compania dedistribuţie
Oraş dedistribuţie
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 4/31
73/6842/67/6 ;ce 2010 / A&lica<ii (o: 2000 Bra!o"
73/6842/67/% SA+ (o: 2000 Bra!o"
73/6842/67/7e$nologia a&lica<iilor ;olCris Bcre!ti
73/6842/67/5Ba-e de +ate Co&ania de libr*Bra!o"73/6842/67/7e$nologia a&lica<iilor ;Co&ania de libr*Bcre!ti
73/6842/67/5 Ba-e de +ate (o: 2000 Sibi
73/6842/67/7e$nologia a&lica<iilor ;)ibr*ria 9Central9 Bra!o"
73/6842/67/5Ba-e de +ate )ibr*ria 9Central9 Bra!o"
73/6842/67/5 Ba-e de +ate olCris Sibi
73/6842/67/6 ;ce 2010 / A&lica<ii (o: 2000 Sibi
73/6842/67/6 ;ce 2010 / A&lica<ii (o: 2000 Bra!o"
73/6842/67/6 ;ce 2010 / A&lica<ii (o: 2000 Bra!o"
73/6842/67/5 Ba-e de +ate Co&ania de libr* Cl=
73/6842/67/7e$nologia a&lica<iilor ;olCris Bcre!ti
73/6842/67/7e$nologia a&lica<iilor ;olCris Bcre!ti
73/6842/67/5Ba-e de +ate )ibraria 9PlaCedo9Bra!o"
73/6842/67/4 +esign eb (o: 2000 Cl=
73/6842/67/4 +esign eb (o: 2000 Bra!o"
73/6842/67/8 Prograarea calclatoare(o: 2000 Bra!o"73/6842/67/5 Ba-e de +ate (o: 2000 Bcre!ti
73/6842/67/% SA+ )ibraria 9PlaCedo9 Cl=
73/6842/67/8Prograarea calclatoareCo&ania de libr*Bcre!ti
73/6842/67/5 Ba-e de +ate )ibr*ria 9Central9 Sibi
73/6842/67/7e$nologia a&lica<iilor ;)ibr*ria 9Central9 Cl=
73/6842/67/8Prograarea calclatoareolCris Bcre!ti
73/6842/67/5 Ba-e de +ate )ibr*ria 9Central9 Cl=
>n ca-l ?n care codl SB n se reg*se!te ?n tabell de conS* se rec&ere-e titlul cărţii B3B5% ?n nc<ie de codl
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 5/31
Cod ISBN
adlesc Sori 40 bc DDD DDD %73/6842/67/
adlesc Sori 80 bc DDD DDD %73/6842/67/
adlesc Sori 800 bc DDD DDD %73/6842/67/
Po&esc #i$ne 400 bc DDD DDD %73/6842/67/
onesc )ara %00 bc DDD DDD %73/6842/67/
#oisesc Adria 850 bc DDD DDD %73/6842/67/
Sa"a Sebastian1300 bc DDD DDD %73/6842/67/
Sa"a Sebastian1000 bc DDD DDD
Sa"a Sebastian 30 bc DDD %30 lei
#oisesc Adria 1400 bc DDD DDD
adlesc Sori 16 bc DDD 640 lei
adlesc Sori 600 bc DDD DDD
onesc )ara 650 bc DDD DDD
Po&esc #i$ne 1050 bc DDD DDD
Po&esc #i$ne 800 bc DDD DDD
#oisesc Adria 1300 bc DDD DDDAlb #aris 1000 bc DDD DDD
onesc )ara 750 bc DDD DDD
onesc )ara 60 bc DDD DDD
#oisesc Adria 125 bc DDD DDD
#oisesc Adria 600 bc DDD DDD
#oisesc Adria 100 bc DDD DDD
#oisesc Adria 250 bc DDD DDD
onesc )ara %0 bc DDD DDD
onesc )ara 100 bc DDD DDD
#oisesc Adria 100 bc DDD DDD
Po&esc #i$ne 360 bc DDD DDD
onesc )ara 2000 bc DDD DDD
Alb #aris 20 bc DDD 800 lei
Alb #aris 30 bc DDD 870 lei
#oisesc Adria 40 bc DDD DDD
Agentvn!are
edistribui
#reţcarte
$aloarevn!are
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 6/31
#oisesc Adria 400 bc DDD DDD
#oisesc Adria 200 bc DDD DDD
#oisesc Adria 280 bc DDD DDD
#oisesc Adria 300 bc DDD DDDPo&esc #i$ne 1200 bc DDD DDD
adlesc Sori 450 bc DDD DDD
Alb #aris 50 bc DDD DDD
Alb #aris 60 bc DDD DDD
adlesc Sori 4%0 bc DDD DDD
adlesc Sori %00 bc DDD DDD
Sa"a Sebastian 350 bc DDD DDD
Sa"a Sebastian 250 bc DDD DDD
Alb #aris 360 bc DDD DDD
adlesc Sori 750 bc DDD DDD
adlesc Sori 45 bc DDD DDD
#oisesc Adria 75 bc DDD DDD
Alb #aris 20 bc DDD 680 lei
#oisesc Adria 10 bc DDD 340 lei
#oisesc Adria 40 bc DDD DDDPo&esc #i$ne 500 bc DDD DDD
Alb #aris 240 bc DDD DDD
onesc )ara 800 bc DDD DDD
onesc )ara 365 bc DDD DDD
Alb #aris 120 bc DDD DDD
Alb #aris 180 bc DDD DDD
#oisesc Adria 320 bc DDD DDD
sltare, se "a a@!a n esa= de eroare. B &relat din tabell de consltare din cmpul
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 7/31
Titlu carte
(isal Basic or A&&lication
+esign eb
Ba-e de +ate
;ce 2010 / A&lica<ii
e$nologia a&lica<iilor ;ce
Prograarea calclatoarelor
SA+
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 8/31
%&'(.
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 9/31
Curs Eur )*)+, lei
Destinaţ Bucureşti
Prods1 1.2 t -.*,/) lei
Prods2 1.4 t -.*,/) lei
Prods3 2.% t -.*,/) lei
Bra!o" Bcre!ti Ploie!ti Predeal Sinaia 20.00 E 13.75 E 13.50 E 15.00 E 12.50 E
+enir
e &rods
Cantitate
li"rat*
C$eltieli
trans&ort lei
S* se calcle-e Cheltuielile de transp
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 10/31
rt ?n nc<ie de ora!l de destina<ie !i de crsl .
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 11/31
ata actur 000 1001Prods1 36.25 E
1002Prods2 1%.00 E
Curs Euro )*)./- lei 1003Prods3 37.50 E1004Prods4 75.00 E
1006Prods6 22.50 E
1002 1.7 t 000 1007Prods7 55.00 E
1018 1.2 t (1*+% lei 1008Prods8 15.00 E
1007 2.5 t 000 100%Prods% 41.00 E
1020 1.% t 000 1010 Prods10 33.75 E
1011 Prods11 12.50 E1012 Prods12 16.00 E1013 Prods13 2%.25 E1014 Prods14 30.00 E1015 Prods15 55.00 E1016 Prods16 1%.50 E1017 Prods17 32.50 E1018 Prods18 18.00 E101% Prods1% 20.25 E
1020 Prods20 17.33 E
Codprodus
2enumireprodus
#reţunitar
345
Codprodus
Cantitatelivrat"
$aloare6actur"
3lei5
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 12/31
2ata debut promoţie
/ /
1.0 t 7G SatrdaH, o"eber 01, 2014
/ // /
1.3 t 15G $rsdaH, #aH 01, 2014
2.0 t 3G SatrdaH, IanarH 25, 2014
1.7 t 10G $rsdaH, #aH 01, 2014
/ /
/ /
/ /2.5 t 15G ednesdaH, ctober 15, 2014
/ // // // /
1.3 t 18G SatrdaH, #arc$ 15, 20142.0 t 10G $rsdaH, #arc$ 20, 20141.0 t 6G #ondaH, +eceber 01, 2014
/ /
Cantitate2iscount
2iscount375
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 13/31
2ata s6rşit promoţie
SndaH, o"eber 30, 2014
ednesdaH, #aH 21, 2014
$rsdaH, FebrarH 06, 2014
SndaH, Ine 01, 2014
DDD
#ondaH, #arc$ 31, 2014 $rsdaH, #arc$ 27, 2014
DDD
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 14/31
2ata scadenţei
101 Client1 Constanta Str. A 456,865 DDD 20 -ile Fri, 24 ct 2014
101 Client1 Constanta Str. A 456,854 DDD / ed, 8 ct 2014
101 Client1 Constanta Str. A 456,86% DDD 20 -ile $, 20 o" 2014
101 Client1 Constanta Str. A 456,858 DDD 10 -ile Fri, 28 o" 2014
101 Client1 Constanta Str. A 456,85% DDD 20 -ile Fri, 1% +ec 2014
102 Client2 Bcresti Str. B 456,855 e, 2 +ec 2014 30 -ile e, 13 Ian 2015
102 Client2 Bcresti Str. B 456,861 DDD 15 -ile $, 8 Ian 2015
103 Client3 Braso" Str. C 456,860 DDD 15 -ile Fri, 3 A&r 2015
103 Client3 Braso" Str. C )1-891, DDD / T:u8 +- Apr %.+1
104 Client4 Cl= Str. + 456,852 Fri, 24 A&r 2015 / Fri, 24 A&r 2015
104 Client4 Cl= Str. + 456,862 DDD 8 -ile #on, 18 #aH 2015
104 Client4 Cl= Str. + 456,864 DDD 3 -ile ed, 24 In 2015105 Client5 Arad Str. 456,853 DDD 17 -ile $, 3 Se& 2015
105 Client5 Arad Str. 456,866 e, 6 Ian 2015 5 -ile e, 13 Ian 2015
105 Client5 Arad Str. 456,867 DDD 7 -ile e, 20 Ian 2015
106 Client6 iisoara Str. F 456,868 DDD / ed, 4 Feb 2015
106 Client6 iisoara Str. F 456,856 DDD % -ile ed, 18 #ar 2015
107 Client7 B-a Str. 456,870 DDD 14 -ile e, 21 A&r 2015
107 Client7 B-a Str. 456,871 DDD 6 -ile #on, 6 A&r 2015
107 Client7 B-a Str. 456,863 DDD 30 -ile Fri, 1 #aH 2015
DJA
Codclien
t
Numeclient
Localitate client
Adresaclient
Num"r6actur"
2ata6acturii
Nr* !ilegraţie
Care este luna ?n care a de"enit scadent* actra c nr.
Obs re-ltatl orlei "a @ oratat &ersonali-at, astel ?nc't, ?n celllna scaden<ei tili-'nd oratl abre"iat &entr acest eleent a
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 15/31
#l"tit ;a<or"ri T$A
12,520 lei 2A 0 lei 2,37% lei 14,8%% lei
15,600 lei N= 63,648 lei 15,057 lei %4,305 lei
8,360 lei 2A 0 lei 1,588 lei %,%48 lei
13,000 lei N= 46,410 lei 11,288 lei 70,6%8 lei
38,060 lei N= 127,882 lei 31,52% lei 1%7,471 lei
46,766 lei N= 145,442 lei 36,520 lei 228,728 lei
3,%00 lei N= 12,324 lei 3,083 lei 1%,307 lei
14,005 lei 2A 0 lei 2,661 lei 16,666 lei
87,056 lei N= 18%,782 lei 52,5%% lei 32%,437 lei
1%,500 lei 2A 0 lei 3,705 lei 23,205 lei
12,505 lei 2A 0 lei 2,376 lei 14,881 lei
8,706 lei 2A 0 lei 1,654 lei 10,360 lei45,000 lei 2A 0 lei 8,550 lei 53,550 lei
2,284 lei 2A 0 lei 434 lei 2,718 lei
3,600 lei N= 10,%44 lei 2,763 lei 17,307 lei
18,732 lei N= 54,135 lei 13,845 lei 86,712 lei
12,200 lei N= 30,134 lei 8,043 lei 50,377 lei
14,780 lei 2A 0 lei 2,808 lei 17,588 lei
81,000 lei N= 184,680 lei 50,47% lei 316,15% lei
56,100 lei N= 113,883 lei 32,2%7 lei 202,280 lei
Apr
)1-891,
$aloare6actur"
$aloareatotal"
a destina<ie 25 se "a a@!aum r
6actur" datei de exemplu an.
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 16/31
2ata cotaţiei Curs >=?O
ednesdaH 01 ct 2014 4.4127
1 $rsdaH 02 ct 2014 4.4106
2 FridaH 03 ct 2014 4.4114
3 #ondaH 06 ct 2014 4.41364 esdaH 07 ct 2014 4.4067
5 ednesdaH 08 ct 2014 4.408%
6 $rsdaH 0% ct 2014 4.4061
7 FridaH 10 ct 2014 )*)./-
8 #ondaH 13 ct 2014 4.4030
9 esdaH 14 ct 2014 4.410%
10 ednesdaH 15 ct 2014 4.4137
11 $rsdaH 16 ct 2014 4.4300
12 FridaH 17 ct 2014 4.420%13 #ondaH 20 ct 2014 4.4176
14 esdaH 21 ct 2014 4.4170
15 ednesdaH 22 ct 2014 4.4166
16 $rsdaH 23 ct 2014 4.4236
17 FridaH 24 ct 2014 4.420%
18 #ondaH 27 ct 2014 4.4255
19 esdaH 28 ct 2014 4.4200
ednesdaH 2% ct 2014 4.4226
$rsdaH 30 ct 2014 4.41%7
deco
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 17/31
Cod #rodus
12312341233212
23456573578%0321341234568%50
S* se calcle-e preţul mediu, &res&n'nd c* acesta este editat ?nce&'nd d
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 18/31
la "aloarea &o-i<ional* 3 &'n* la 5 ?n codl co&o-it din c'&l A/&A9.
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 19/31
Nume #renume 2epartament 2ata naşterii
A)B ana 24%1107345633 Creditare ++@,@+(.,
A)B Constanta 2770%044448%0Creditare (@)@%..)
B)AA #*d*lina 2611123546%67Cor&ora<ii ++@%/@%.%/
C Bogdan 1560817341871 Creditare 9@+,@%.+,
C#A Ara 2800304227773 @cil =ridic /@)@%..)
CSA Ana 25012074725%0@cil =ridic +%@,@%..,
++ atalia 2610722114674 Creditare ,@%%@%.%%
AA Pa"el 170110155588% ela<ii clien<i ++@+@%..+
#ASC Andreea 2811010510053 Cor&ora<ii +.@+.@%.+.
#A Caren 2600227503812 Creditare %@%,@%.%,
#A +in 1550602422877 Asigrari -@%@%..%
#+A )ara 2600615100121Asigrari -@+1@%.+1
+)C #i$ai 1810130333655 Asigrari +@/.@+(/.
PAA Cornel 15%05016738%5 Cor&ora<ii 1@+@%..+
P Cristina 266080%31034%@cil =ridic 9@(@%..(
PPA Florin 1501001701%02 Cor&ora<ii +.@+@%..+
PPSC (iorel +an 1621212345345 Creditare +%@+%@%.+%
SA( C*t*lin 1700404222888 Creditare )@)@%..)
SSC )iana 2680312508405ela<ii clien<i /@+%@%.+%
(SA Ale:andra 2721225557812@cil =ridic +%@%1@%.%1
()A+ Petr 1600205667445 Cor&oratii %@1@%..1
Cod numericpersonal
S* se calcle-e Data naşterii &lec'nd de la codl neric &e
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 20/31
A&r/2006 % ani 1,000 lei
Se&/1%80 35 ani 2,%00 lei
In/1%%% 16 ani 1,180 lei
Feb/1%70 45 ani 2,%00 lei
In/1%85 30 ani 2,7%0 lei
+ec/1%7% 36 ani 3,200 lei
ct/1%83 32 ani 2,%00 lei
Ag/2001 14 ani 1,180 lei
#aH/2004 11 ani 1,050 lei
A&r/2006 % ani 1,000 lei
#ar/1%78 37 ani 2,%00 lei
ct/1%84 31 ani 2,500 lei
+ec/2006 % ani 1,000 lei
Ag/1%81 34 ani 2,800 lei
Il/1%7% 36 ani 3,200 lei
Feb/2006 10 ani 1,050 lei
o"/2002 13 ani 1,200 lei
A&r/2006 % ani 1,000 lei
A&r/1%80 35 ani 3,350 leiA&r/2006 % ani 1,050 lei
o"/1%75 40 ani 3,200 lei
2ataanga<"rii
$ec:ime3ani5
Salariu ncadrare
sonal.
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 21/31
Nume #renume Cod salariat
A)B Constan<a A)B 400P Cristina P S221
PPA Florin PPA 400++ atalia ++ S337C#A Ara C#A B222+)C #i$ai +)C B222#A +in #A 400
orat din 2 eleente nele salariatli !i indicatiS* se calcle-e codul salariatului !tiind c* acesta r
Exemplu ALB= T)..
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 22/31
Nume #renume
PPSC (iorel +an S221#A Caren A117
PPA Florin 400A)B Constan<a 400+)C #i$ai B222C Bogdan A117A)B ana S337()A+ Petr 400
CSA Ana S221l locli de n #+A )ara A117
SA( C*t*lin S221PAA Cornel B222
C#A Ara B222B)AA #*d*lina A117#A +in 400++ atalia S337AA Pa"el S337SSC )iana 400P Cristina S221#ASC Andreea A117(LA Ale:andra A117
Indicativ locde munc"
&re-int* n cod c
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 23/31
ecodi@care
5478 2,523.70 0.13 315.4652016854%0 6,500.00 0.%4 6,116.505201605485 1%,46%.52 0.40 7,787.815201655481 21,547.80 0.17 3,620.03520161
din narl de in"entar "a @ inlocit c anl crent.
Optional- anul punerii in functiune
Recodificare
5478 2,523.70 0.13 315.46 519998
54%0 6,500.00 0.%4 6,116.50 520000
5485 1%,46%.52 0.40 7,787.81 520075
*r dein"entar
(aloare dein"entar
Coe@cientde
ree"alare
(aloareree"alat*
Se "a reali-a o recodifcare a i=loacelor @:e in ra careia c
Obs re-ltatl orlei de calcl re&re-inta o informatie de na
*r dein"entar
(aloare dein"entar
Coe@cientde
ree"alare
(aloareree"alat*
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 24/31
5481 21,547.80 0.17 3,620.03 519991
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 25/31
5478AAA 2J12J1%%% 2,523.70 lei
547%BBB 2J18J200% 12,547.83 lei
5480CCC %J3J2000 3,550.00 lei
5481+++ 1J25J1%%% 3,6%5.00 lei5482 6J6J2006 1,754.01 lei
5483FFF 11J8J2000 6,500.00 lei
5484 4J12J2000 2,765.82 lei
5485 6J14J2007 1%,46%.52 lei
5486 8J30J2001 4,785.00 lei
5487 III 2J4J2002 1,548.78 lei5488MMM 8J6J1%%8 21,547.80 lei
548%))) 3J17J2004 3,583.00 lei
54%0### 3J12J2000 6,500.00 lei
*rin"enta
r
+enirei=loc @:
+ata &nerii ?n nc<ine
(aloare dein"entar
l de/al do
tura num
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 26/31
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 27/31
Nume #renume Sucursala
PPSC (iorel +an+octor Feli: Creditare .+#$-% #
#A Caren Ltean cel #ar Creditare .+;C-. F
PPA Florin Ltean cel #ar Cor&ora<ii .%#F1. #
A)B Constanta +octor Feli: Creditare .+AC,, F
+)C #i$ai Ltean cel #ar @cil =ridic ./N;9+ #
C Bogdan Ple"nei @cil =ridic ./CB1- #
A)B ana Ple"nei Creditare .+AO)( F
()A+ Petr Ltean cel #ar ela<ii clien<i .)$#-. #
CSA Ana +octor Feli: Cor&ora<ii .%CA1. F
#+A )ara Ltean cel #ar Creditare .+;L-. F
SA( C*t*lin Ltean cel #ar Asigrari .1SC,. #
PAA Cornel Ltean cel #ar Asigrari .1#C1( #
C#A Ara Ltean cel #ar Asigrari .1CA9. F
B)AA #*d*lina Ple"nei Cor&ora<ii .%B;-+ F
#A +in +octor Feli: @cil =ridic ./;211 #
++ atalia Ltean cel #ar Cor&ora<ii .%2N-+ F
AA Pa"el Ltean cel #ar Creditare .+#,. #SSC )iana Ple"nei Creditare .+SL-9 F
P Cristina +octor Feli: ela<ii clien<i .)#C-- F
#ASC Andreea Ltean cel #ar @cil =ridic ./;A9+ F
(SA Ale:andra Ple"nei Cor&ora<ii .%$A,% F
2epartament
Codulsalariatului
enu3;Dmasculi
nFD6eminin
Codul salariatului re&re-int* n cod co&o-it care con<ine
:e&l salariatl (isan Ale:andra are codl .%$A,%
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 28/31
Nume #renume
46 ani A&r/2006 2 ani 1,000 lei A)B ana DDD
4% ani Se&/1%80 28 ani 2,%00 lei A)B Constanta DDD
58 ani In/1%%% % ani 1,180 lei B)AA #*d*lina DDD
31 ani Feb/1%70 3% ani 2,%00 lei C Bogdan DDD
28 ani In/1%85 23 ani 2,7%0 lei C#A Ara DDD
52 ani +ec/1%7% 2% ani 3,200 lei CSA Ana DDD
5% ani ct/1%83 25 ani 2,%00 lei ++ atalia DDD
4% ani Ag/2001 7 ani 1,180 lei AA Pa"el DDD
58 ani #aH/2004 4 ani 1,050 lei #ASC Andreea DDD
48 ani A&r/2006 2 ani 1,000 lei #A Caren DDD
38 ani #ar/1%78 31 ani 2,%00 lei #A +in DDD
4% ani ct/1%84 24 ani 2,500 lei #+A )ara DDD
2% ani +ec/2006 2 ani 1,000 lei +)C #i$ai DDD
47 ani Ag/1%81 27 ani 2,800 lei PAA Cornel DDD
53 ani Il/1%7% 2% ani 3,200 lei P Cristina DDD
47 ani Feb/2006 3 ani 1,050 lei PPA Florin DDD
38 ani o"/2002 6 ani 1,200 lei PPSC (iorel +an DDD41 ani A&r/2006 2 ani 1,000 lei SA( C*t*lin DDD
42 ani A&r/1%80 28 ani 3,350 lei SSC )iana DDD
27 ani A&r/2006 2 ani 1,050 lei (SA Ale:andra DDD
36 ani o"/1%75 33 ani 3,200 lei ()A+ Petr DDD
$rsta
3ani5
2ataanga<"rii
$ec:imea 3ani5
Salariu ncadrar
e
Cod numericpersonal
cod de&artaent, &ria liter* a neli, &ria liter* a &re
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 29/31
Creditare 01
Cor&ora<ii 02
@cil =ridic 03
ela<ii clien<i 04
Asigrari 05
2epartament
Coddepartament
eli !i anl na!terii ?n orat abre"iat.
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 30/31
5 7 100001
3 5 1001
4 7 %001
ocompo!it npatru trepte
variabile
denti@carea"alorii &o-itionale
aerente primului SPATIU
"alorii
&o-itionaleaerente celide/al doilea
"alorii&o-itionale
aerente celide/al treilea
:tragereaprimuluigrup decaractere
...+ A ;;
.+ A EEEE (
..+ AA E ((
Obs Alegerea sccesinii de a@!are a gr&rilor de caractere di
7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)
http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 31/31
A
A
AA
:tragereaceli de/al
doilea grup de caractere
:tragereaceli de/al
treilea grup de caractere
:tragereaultimului grup decaractere
n
alt" ordine3prin
codul compozit recompus r*'ne la latitdinea stdentli.
top related