Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
hi-I need to read one of the data field entry as string ,the field will be set as TEXT and the users will input data as "ABD,HYG,HOO,IKO,NMJ,KKK" and I need to raed this one line TEXT and seperate each symbol..... thx<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=237&image=1&table=forumtopics' class='bbc_emoticon' alt=':huh:' />
Swat,take a look at VBScript function Split(). This is exactly what you need.Best regards,Sergey Kornilov