Extract some string/ digit or combination of both in a format NN-NN-NNNN

[XXX_Rosy_XXX]

Hi 

I have a column  as below. This column is key in by several helpdesk agents. The way he/she entered are different.

LT58C PROJECTOR LIGHT KEEP ON & OFF, KINDLY ASSIST.

72-04-0003 AUDIO SYSTEM NOT WORKING, KINDLY ASSIST.

LT38FAULTY PROJECTOR.

23-02-01DISMANTLE AND REMOVAL OF SPEAKERS AND PTZ CAMS

BLK 51 #06-0008 NO CONNECTION TO LAPTOP AND TV

73-05-0002 CANNOT CONNECT TO PROJECTOR

5-03-03 CAN'T DO PROJECTION THRU USB-C.

LT-38 PROJECTOR NO DISPLAY, KINDLY ASSIST.

LT-58-C MIC NO SOUND, KINDLY ASSIST.

LT77 CAN'T CONNECT TO PROJECTOR.

I will need to extract the facility id as in this format NN-NN-NNNN e.g. 72-04-0003 or for lecture theatre LT51 or LT73A.  LTDD or LTDD[A-Z].     ( Here D stand for digit). Please help

LT 58C PROJECTOR LIGHT KEEP ON & OFF, KINDLY ASSIST	LT58C
72-04-0003 AUDIO SYSTEM NOT WORKING, KINDLY ASSIST.	72-04-0003
LT38FAULTY PROJECTOR.	LT38
23-02-01DISMANTLE AND REMOVAL OF SPEAKERS AND PTZ CAMS	23-02-0001
BLK 51 # 06-0008 NO CONNECTION TO LAPTOP AND TV	51-06-0008
73-05-0002 CANNOT CONNECT TO PROJECTOR	73-05-0002
5-03-03 CAN'T DO PROJECTION THRU USB-C.	05-03-0003
LT-38 PROJECTOR NO DISPLAY, KINDLY ASSIST.	LT38
LT-58-C MIC NO SOUND, KINDLY ASSIST.	LT58C
LT77 CAN'T CONNECT TO PROJECTOR.	LT77
BLK 4 #03-04 LAB ONE OF THE PROJECTOR CANNOT PROJECT	04-03-0004

[aatalai]

@XXX_Rosy_XXX take a look a this and let me know if it helps

[XXX_Rosy_XXX]

Thanks this help alot on facility id 

[aatalai · Accepted solution]

cool can you mark the post as a solution?

[XXX_Rosy_XXX]

Hi 

Can help im still having issue with the lecture theatre. I will need it in LTDD ot LT DD[A-Z]