select string value from starting to a special character.

[Architect]

I have a field value that looks like =

ABB-343

BADDD-7787

GG3WW-889H.

THESE VALUES ARE made up with the logic --" ITEM_TYPE & '-'& ITEM_NO AS FIELD1".

now help me select only "ITEM_TYPE" FROM THE  FIELD1 string.

My understanding we have to select data from the 1st left value up to '-'.

[Taoufiq_Zarra · Accepted solution]

@Architect  like ?

=subfield(Field,'-',1)

Field is ITEM_TYPE & '-'& ITEM_NO AS FIELD1

like for example :

[Architect · Accepted solution]

Thanks, Taoufiq,

But I have used the below method, and it is working well.-

 TextBetween(FIELD1 ,'','-') AS ITEM_TYPE.