How to convert a delimited string to rows but i am not sure

vijaydev · Post by **vijaydev** » 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

vijaydev · Post by **vijaydev** » Tue Sep 30, 2008 6:22 am

Hi,

Any one pls. help me..

-Vijay

ray.wurlod · Post by **ray.wurlod** » Tue Sep 30, 2008 6:48 am

Help yourself. Search - parse and pivot.