comma separated data in a column

pavan_test · Post by **pavan_test** » Tue Oct 27, 2009 1:21 pm

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

chulett · Post by **chulett** » Tue Oct 27, 2009 1:30 pm

You always want the first occurance in the delimited string? If so:

Field(Yourfield,",",1,1)

pavan_test · Post by **pavan_test** » Tue Oct 27, 2009 1:32 pm

Thanks. I want first occurance in the delimited string.

Thanks
Mark