Parse a record to the first comma

[#1]

If I have records that are strings like "DDateRefGet, FORCED" and I just want the parts of the records until the first comma so "DDateRefGet" in our example, how would I do that?  Also some reords don't have commas and I want to keep those as they are.

[m_woolf]

Something like this:

if(index(MyField,',')>0,left(MyField,index(MyField,',')-1,Myfield) as Myfield;

[john_duffy]

Hi Brandon.

This should work:

if(FindOneOf(Field1,',') = 0,Field1,TextBetween(Field1,left(Field1,1),',')) as NewField

[swuehl · Accepted solution]

Have you tried

subfield(FIELD,',',1) as NewField

?

[#5]

In this case there are several ways to skin a cat!