How to convert a delimited string to rows but i am not sure
Posted: Mon Sep 29, 2008 2:19 pm
Hi,
I have a requirement i need to convert one delimited string to rows, but i am not sure how many delimiters i will get it.
Eg:
Input:
Project ID User ID
1 31716#@#31965
2 31924#@#32677#@#31689#@#37011#@#30855#@#30096
3 3251058
4 32401#@#42862#@#32401#@#42862
Expected output is :
Project ID User ID
1 31716
1 31965
2 31924
2 32677
2 31689
2 37011
2 30855
2 30096
3 3251058
4 32401
4 42862
4 32401
4 42862
If use field function than i need to specify the number of delimiter, here i am not sure how many i can get it. Please help me to reslove this.
Thanks In Advance.
-Vijay
I have a requirement i need to convert one delimited string to rows, but i am not sure how many delimiters i will get it.
Eg:
Input:
Project ID User ID
1 31716#@#31965
2 31924#@#32677#@#31689#@#37011#@#30855#@#30096
3 3251058
4 32401#@#42862#@#32401#@#42862
Expected output is :
Project ID User ID
1 31716
1 31965
2 31924
2 32677
2 31689
2 37011
2 30855
2 30096
3 3251058
4 32401
4 42862
4 32401
4 42862
If use field function than i need to specify the number of delimiter, here i am not sure how many i can get it. Please help me to reslove this.
Thanks In Advance.
-Vijay