on 06-25-2008 7:23 AM
Hi,
I have written a UDF which returns data in the form of a string with comma ',' seperated.
I wanted to get each value seperately and directly map them to the output data type.
Is it possible to seperate the string that is comma seperated and pass them into Global variables and use global variables to directly map with reciever datatype?
Or is there any other method to handle this using other existing functions to split the returned value?
Please help. Thanks in Advance
Rohan.
..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Is it possible to seperate the string that is comma seperated and pass them into Global variables and use global variables to directly map with reciever datatype?
I think Java mapping is good for this scenario....
Regards,
Vivek LR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You have to use StringTokenizer Class in java it will eleminate delemiter. Else use substring to get the "," and keep in global variable as you like. You can do both ways.
Thanks,
RamuV
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.