Extraction of Location

[Raju_6952]

Hi ,

I am having difficult situation to extract the numeric from Incident Name for the below cases.

1. IND_BHU_SHU_01A_04_CCTV007

2.IND_BLR_06F_04_VAV
as mentioned above it has two different catageories , I am able to extract the BLR_06 from second case with expression bewlow but first case its not able to get.

SubField(Mid(Incident_Name &'-'& Incident_description, Len(SubField(Incident_Name &'-'& Incident_description, 'IND_', 1)) + 1), '_', 3)).

any Suggestion on this.

[MarcoWedel]

please describe properly what your required result would look like, maybe also using additional examples.

[Raju_6952]

Hi @MarcoWedel ,

the expected ouput is like below

1. IND_BHU_SHU_01A_04_CCTV007 - output (BHU_01)

2.IND_BLR_06F_04_VAV-output (BLR_06)

the above two rows are from Incident name field. 

[anat]

load *,

subfield(column,'_',2)&'_'&left(keepchar(column,'0123456789'),2) as newfield;

load * inline [

column

1. IND_BHU_SHU_01A_04_CCTV007 

2.IND_BLR_06F_04_VAV

];