How to separate Plant number from text

[Sra1bandi]

Hi Team,

Load inline [

S.no           Plant 

1                 11AM - COMPLETED

2                 1102 - COMPLETED

3                 7185-WF Completed

4                 11AC - WF Completed

5                 Not valid

6                completed

7                No STATUS           ]

I need result like below for 5,6,7 i need '-' like mentioned below.

S.no      Plant

1             11AM

2             1102

3             7185

4             11AC

5                 -

6                -

7               -

Regards,

Sra1.

[BrunPierre]

Hi, one solution could be this.

If(SubStringCount(Plant, '-') > 0, SubField(Plant, '-', 1), '-') as [Plant number]