Jump to content

Calling Vbscript Experts....


Recommended Posts

Posted

bayya vunnava? sleep vesava? i will ltt t'row then

Posted

[quote name='cherlapalli_jailer' timestamp='1374684068' post='1304004294']
or if
[color=#282828][font=helvetica, arial, sans-serif]AUTO AUTO2 ELC IT-DB IT-DESK IT-NET PLU PLU2 TECH[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]these are all mandatory [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]and not sure of how String 1 will be then [/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]there is way to do[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]what out put u need if match and/or doesn't match[/font][/color]
[/quote]

All words should be there in string1 ... If order matches then output should be true otherwise false....

M going out now come back after 2 hrs
Thx in advance

Posted

hi notTrouble

u need complete code or logic(so that u can write accordingly)
if u r good@VBScript then it is easy for u

coz i know the logic if u need complete script then it takes some time

the sol i have may not be 100% best but as the day progresses we can get much better one

Posted

dim AUTOpos = [color=#000000]InStr(1,txt,"AUTO")[/color]
dim AUTO2pos = [color=#000000]InStr(1,txt,"AUTO2")[/color]
dim ELCpos = [color=#000000]InStr(1,txt,"ELC")[/color]
dim ITDBpos = [color=#000000]InStr(1,txt,"IT-DB")[/color]
[color=#000000]so on[/color]
[color=#000000]if([/color]AUTOpos > AUTO2pos)
return false ;
if(AUTO2pos > ELCpos)
return false ;
if(ELCpos > ITDBPos)
return false ;

so on

so on

Posted

with this logic u can make sure all r in order

Posted

[quote name='cherlapalli_jailer' timestamp='1374750280' post='1304008077']
dim AUTOpos = [color=#000000]InStr(1,txt,"AUTO")[/color]
dim AUTO2pos = [color=#000000]InStr(1,txt,"AUTO2")[/color]
dim ELCpos = [color=#000000]InStr(1,txt,"ELC")[/color]
dim ITDBpos = [color=#000000]InStr(1,txt,"IT-DB")[/color]
[color=#000000]so on[/color]
[color=#000000]if([/color]AUTOpos > AUTO2pos)
return false ;
if(AUTO2pos > ELCpos)
return false ;
if(ELCpos > ITDBPos)
return false ;

so on

so on
[/quote]

Actually those r variables....

I m done with the script I ill post my code...

Thx for ur time bayyaa

Posted

Sub String_Order_Check ()

Dim String1, String2, SubStrings, Position, i,objSortedList
Set objSortedList = CreateObject( "System.Collections.Sortedlist" )
String1 = "CodeDescriptionHourly RateLiveAUTOVehicle MechanicaAUTO2Vehicle Mechanic Level 2£1.00ELCElectrician Level 1£100.00IT-DBIT Database Engineer£155.99IT-DESKIT Desktop Support Engineer£175.89IT-NETIT Network Engineer£99.01PLUPlumber Level 1£100.00PLU2Plumber Level 2£125.00TECHGeneral Technician£75.00"

String2 = "AUTO,AUTO2,IT-DB,IT-DESK,IT-NET,PLU,PLU2,TECH,ELC"

SubStrings = Split(String2, ",")

For i = 0 to UBOUND(SubStrings)

Position = aqString.Find(String1, SubStrings(i))
objSortedList.Add SubStrings(i),Position
If Position = -1 Then
Log.Error Substrings(i)&" is not Found in the grid"
End If
If i>1 then

If objSortedList(Substrings(i-1)) > objSortedList(Substrings(i)) Then
log.error Substrings(i)&" is prior than "&Substrings(i-1)
End If

End If

Next
Posted

baaaaa nenu eppudeee totorials chusi nerchukuntunna C#

eeeee thedduki sambandinchinadi kadu ayina aduthunda

naku .net nerchukodaniki yedin manchi soruces or tutorials and exercises vunte cheppandi vayya

Posted

[quote name='gundugadu' timestamp='1374773584' post='1304009461']
baaaaa nenu eppudeee totorials chusi nerchukuntunna C#

eeeee thedduki sambandinchinadi kadu ayina aduthunda

naku .net nerchukodaniki yedin manchi soruces or tutorials and exercises vunte cheppandi vayya
[/quote]
anthaku mundu Emi technology?

Posted

[quote name='cherlapalli_jailer' timestamp='1374773740' post='1304009473']
anthaku mundu Emi technology?
[/quote]
SQL baaaaaaa

Posted

[quote name='gundugadu' timestamp='1374774489' post='1304009550']
SQL baaaaaaa
[/quote]
.net and c# is what ur planing?

Posted

[quote name='gundugadu' timestamp='1374774489' post='1304009550']
SQL baaaaaaa
ETL and reporting lo .net vasthe na pani konchem easy avuddi.

Vere valla meeda depend avvalsi vasthandi anduke nerchukundam ani 1 week nundi strt chesa videos chusthunna and simultaneously practice chesthunna

[/quote]

Posted

[quote name='gundugadu' timestamp='1374774489' post='1304009550']
[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]SQL baaaaaaa[/background][/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]ETL and reporting lo .net vasthe na pani konchem easy avuddi.[/background][/size][/font][/color]

[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]Vere valla meeda depend avvalsi vasthandi anduke nerchukundam ani 1 week nundi strt chesa videos chusthunna and simultaneously practice chesthunna[/background][/size][/font][/color]
[/quote]
oh ok
You have specific goal then good...i thought u want to change the technology

ok here r the Q(s)
1) how far u r in?
2) Do have any doubts?
or you r yet to start?
do u have any plans to learn online by paying?
or u want give a try on ur own?

where r u located?

Posted

[quote name='cherlapalli_jailer' timestamp='1374774789' post='1304009580']
oh ok
You have specific goal then good...i thought u want to change the technology

ok here r the Q(s)
1) how far u r in?
2) Do have any doubts?
or you r yet to start?
do u have any plans to learn online by paying?
or u want give a try on ur own?

where r u located?
[/quote]


1) how far u r in?[color=#ff0000][b]Last year oka learnvisualstudio ani oka paid subscription thesukunni oka 1month nerchukunna. [/b][/color]
2) Do have any doubts? Doubts vasthunnay mana google odini aduguthunna. Need to Exercises to work on as a starter
or you r yet to start? layear strt chesa and break tharuvatha malli oka 1 week mundu start chesa
do u have any plans to learn online by paying? onoine pay lite mama vidos vunnay
or u want give a try on ur own? own

where r u located? US

×
×
  • Create New...