Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
please describe properly what your required result would look like, maybe also using additional examples.
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.
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
];