Spliting up a field

[Linux Man]

Hi

I have a table which has a text field ( variable length) of the from

string1://string2/string3/string4

Is there any easy was using the access builtin functions to extract
string2.?


Thanks..

 

[Douglas J. Steele]

Assuming you're using Access 2000 or newer, you could try using the Split
function to split the string into an array on the / symbols.

Split("string1://string2/string3/string4", "/")(2) would give you string2

(0 would give you string1:, 1 would give you a zero-length string, since
there's nothing between those 2 slashes, 3 would give you string3 and 4
would give you string4)