Query a String 1

[stikare2]

Hi,

How do I check for the number of ^ in a string. I want to check that my input file contains all the specified input fields before proceeding with my validations. My input file should contain 52 fields each delimited by ^

Any suggestions welcome.

Regards,
S

 

[jonscott8]

str = "This^is^a^test^of^the^split^function"
aSplit = Split(str,"^",-1,1)
WScript.Echo "There are " & UBound(aSplit) & " ^ in the string." Jon Hawkins

 

[stikare2]

Dear Jon,

Thanks for your tip. My knowledge is doubling up everyday

Best Regards,
Sushil