HI All,
I have a record with column, say B.
The data in this column can vary from record to record.
Column B data:
1,2,3
10,2,3,4,5,6,7,8
7,4,5,6
23,56,87,12,333,444,555,66,777
Desired output from column B is:
1
10
7
23
can anyone please suggest me.
Thanks
Mark
comma separated data in a column
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
comma separated data in a column
Thanks. I want first occurance in the delimited string.
Thanks
Mark
Thanks
Mark