Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi, one solution could be this.
If(SubStringCount(Plant, '-') > 0, SubField(Plant, '-', 1), '-') as [Plant number]