How to find string value from Space separated String field

[chaper]

I have field with space separated multiple strings.I want to find a particular string value from that field.The position of that particular string value can be anywhere and it changes.How to find the particlar string?

thanks in advance

[b_garside]

Since the Datsource appears to be Tag like in nature with multiple values per row are you trying to pick just one or into separate parts using SubField() etc...  ?

[petter]

If( DataSource Like '*SQL*' , DataSource , 'Other)

[petter]

If( DataSource Like '*SQL*' , 'SQL' , 'Other' )

[chaper]

See below

I want to create a field of source type.If i make selction SQL in source type field i want ot see only SQL items with 1,2,3  and if oracle selected only oracle  items 1,3,4

[chaper]

I tried .sub field is creating individual values of source and ends up as one many

[b_garside]

Perhaps if you could give us a sample mock-up of how it should appear once processed?

I think either SubField or eh Like will do the trick. You will have many combinations of groups since you are allowing multiple Tags per DataSource is that ok?

[b_garside]

Then using Subfield will work.

[chaper]

Thanks Rob for reply.But doing subfield(String,' ') is creating multiple values for each Item ID.One to many.

[chaper]

subfield(String,' ') is creating multiple values for each Item ID.One to many.

[chaper]

Thanks for the reply.I will try this code