Seperating a text field
I have the following data:
1/rgrgrrtr,2/xcvxcvxcvx,3/cccc,4/thtryrytrytry,5/cvbzxcbb,6/eeeeeeeeeeeeeeee,7/nnnnnnnnnnnnnnnnnn
I can seperate the above values on the / using the:
<cfloop index = "ListElement" list = "#nenen#" delimiters = ",">
</cfloop>
The above will produce:
1/rgrgrrtr
2/xcvxcvxcvx
3/cccc
4/thtryrytrytry
5/cvbzxcbb
6/eeeeeeeeeeeeeeee
7/nnnnnnnnnnnnnnnnnn
I need to seperate each value based on the /. Placing the value before the / in a variable and the value after the / in another variable. I have not found a Cold Fusion function to do this.
The value before the / can be more than one character in length.
The value before the / would be compared against another value that contains a record number.
Thanks.
