Counting sub-delimited items within a variable 1

[Jamesm601]

Hi All!

Can anyone help me remember how to parse out a variable that contains dilimited and sub-delimited data? I thought either MID() or LEN() did that in VB, but I can't seem to get it to work.

Something along the lines of this:

Variable PATIENT contains the text "DOE,JOHN,C^34^M"

What I need to do is access the first "^" piece of the variable, then the second "," piece, arriving at "John".

I though I could do this with nested MID or LEN statements, but it doesn't seem to work. Any help jogging my aging memory would be greatly appreciated.

Thanks is advance.

 

[SkipVought]

Hi,
Try using the Split function is you're NOT running '97

FullName = Split(PATIENT, "^")(0)
FirstName = Split(FullName, ",")(1)

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[Jamesm601]

Skip,

Thank you very much. That worked nicely. I guess I'd imagined using MID or LEN for this. I've never heard of this function, but it works perfectly.

1 * 2 U