Extract text before a fixed phrase

[User12321]

Hi,

I want to create a table in load where the values are the text extracted before a fixed phrase (example: 'has met our orders') in the field names.

Can someone help please. Thank you.

[Vegar · Accepted solution]

You could do this by using mid() and index().

Try something like this:

mid([Company],1, index([Company], 'has met our orders')-1) as Company