String Manipulation

[Nebooaw]

Hi, if i have a sring containing values like...

Black, Green, Blue

how can i manipulate the string so it now reads...

Def1 = ''Black'' or Def1 = ''Green'' or Def1 = ''Blue''

and if the string only contains one value...

Def1 = ''Black''


Kindest regards

 

[SaMaLaKo]

you can use the split function to separate the values from a for example comma separated string...

--------------------------------------
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs,
and the Universe trying to produce bigger and better idiots.
So far, the Universe is winning.

 

[Nebooaw]

Thanks for replying, have you an example script which can split a string, add quotes before and after the value and rejoin the string?


kindest thanks.

 

[SaMaLaKo]

on the msdn site you will find all help on vbscript functions, examples,...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsfctsplit.asp

-------------------
Feed a man to fish, and feed him for a day.
Teach a man how to fish and feed him for a lifetime.

 

[draigGoch]

Here you go Nebooaw:

strvalue = "black, red, blue"
strvalue = strvalue & ", "

do until (instr(strvalue, " ")=0)
firstspace=instr(strvalue, " ")
strcolour=left(strvalue, 1)
strcolour=strcolour-1
strvalue=mid(strvalue, firstspace+1)

'do stuff with strcolour here (put in array etc)

loop

 

[PHV]

strInp = "Black, Green, Blue"
strOut = "Def1=""" & Replace(strInp, ", ", """ Or Def1=""") & """

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Nebooaw]

Perfect, thanks for your example - all is clear now. Have got it sorted - works a treat!

Kindest thanks,