field with musltiple entires

[dastr]

Hi all,

I have a column in a table where in one cell, I have multiple entries like: 2, 23, 45, 88 - separated by comma.

I was wondering what i may do in teh quesry, so that i get rid of the entries after teh first comma in the cell.



Thanks for yr help in advance.

[pbaldy]

You can use the Left function along with the InStr function to find the position of the first comma.

[dastr]

Hi there,
and what if I have also cells with single entries, ie there is no comma? If I run

Trim(Left([Sizes],[CommaPos]-1))

the single entries will be omitted?

[recyan]

Using pbaldy's logic, just check if below gives some guidelines :

IIf(InStr([Sizes],",")=0 Or IsNull([Sizes]),[Sizes],Left([Sizes],InStr([Sizes],",")-1))

Thanks

[June7]

The entry is actually a text string, not a multi-value field? It looks like a string because of the spaces - just making sure because multi-value fields cannnot be parsed with string manipulation.

[AcsDb]

Function "Left()" acts on a string.... so you should be fine

[dastr]

Thank you!! Much appreciated.