Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Something like this:
if(index(MyField,',')>0,left(MyField,index(MyField,',')-1,Myfield) as Myfield;
Hi Brandon.
This should work:
if(FindOneOf(Field1,',') = 0,Field1,TextBetween(Field1,left(Field1,1),',')) as NewField
Have you tried
subfield(FIELD,',',1) as NewField
?
In this case there are several ways to skin a cat!