IF a Field Starts with the Value from Another Field then use it to Create a New Field

[hellyars]

My source is XML or TXT (from XML).  My fields are trapped in a single field -- I have to separate the wheat from the chaff.

In the example below, the TITLE of an article is trapped in the EVERYTHING FIELD.  TITLE always begins with the name of a state.   

I want to say if EVERYTHING FIELD starts with a value that appears in STATE then it is TITLE else Null.  The hyphen is not a reliable indicator (as it may not be present or may appear in other non-relevant values).

How can I do this?

FILE NUMBER	STATE	EVERYTHING FIELD
2019-325134	Missouri	Missouri - Passes Bill to Do Something
2019-325134	Missouri	Annex
2019-134513	Texas	Item No.
2019-325134	Texas	Texas - Increases Taxes
2019-325134	Texas	Notice
2019-124145	Alaska	Alaska - Requests Federal Funds
2019-124145	Alaska	Policy

[jrgo · Accepted solution]

@hellyars 

IF STARTSWITH([EVERYTHING FIELD], [STATE])
THEN [EVERYTHING FIELD]
ELSE NULL()
ENDIF

[kelsey_kincaid · Accepted solution]

Hi @hellyars ,

Similar to @jrgo 's answer but adjusted to show how you'd do it to set the new field to the word 'Title' instead of 'Everything Field'.

Screenshot of an example is below