Parsing data from a field in Crystal

[mrichey]

Using the following field, how would I parse only the text that says PASSWORD=usbank7?

The length of the password will change but &target will always follow. Thank you!

USER=KBPWC2&PASSWORD=usbank7&target=https%3A%2F%2F

 

[scottostanek]

I looked at this an ran this test formula to see where to start:

stringvar test := "USER=KBPWC2&PASSWORD=usbank7&target=https%3A%2F%2F";
stringVar array Output := split(test,'&');

Output[2]

This uses the Split function to parse by way of the '&' delim and you can come up with a for loop to walk the Output array and parse out to your heart's content. You could even split on '=' and look at that results 2 position...

Scotto the Unwise