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

[swuehl]

What qualifies this special string value? Could you post some sample strings?

[b_garside]

There are a number of powerful String functions at your disposal. SubField() ,  Index() starting position of the n:th occurrence of sub-string, TextBetween()  as well. You will most likely need to Nest a couple of these functions.

If you provide some samples of these strings Im sure we can help give you some good starting points.

[chaper]

String field example

Data Source

SQL DB2 Oracle

DB2 SQL Oracle

Excel Oracle SQL

I want to create group based on source type.

[swuehl]

And you want to transform these field values into what resulting table / field?

[chaper]

I tried something like this

if(Index([Data Source],'SQL'),'SQL'),'SQL',

  if(Index([Data Source],'DB2'),'DB2'),'DB2'

    if(Index([Data Source],'Excel'),'Excel'),'Excel','Other') as Data Source Type

For example All string field values with SQL are not grouped as SQL,some values getting dropped??

[chaper]

May be i wrongly interpreted the example field .this is how the field is

itemno   Datasource

   1        SQL ,DB2 ,Oracle

   2        DB2, SQL ,Oracle

   3.       Excel , Oracle ,SQL

[chaper]

Each data item has Datasource labels/tags (Ex ,excel,sql,oracle).i want to group data items based on data source tags/labels.Sometimes each data item can share same or more than one tag.

[swuehl]

Try something like this:

MAP:

MAPPING LOAD F1, F1 as F2 INLINE [

F1

SQL

DB2

Oracle

Excel

];

LOAD itemno, [Data Source], applymap('MAP',trim(subfield([Data Source],' ')),'Other') as Group INLINE [

itemno, Data Source

1, "SQL ,DB2 ,Oracle"

2, "DB2, SQL, Oracle"

3, "Excel, Oracle ,SQL"

]

[rwunderlich]

Try:

subfield(String,' ') as Tag

-Rob