topic Re: Extraction of Location in App Development

Extraction of Location

Raju_6952 — Wed, 06 Mar 2024 17:29:47 GMT

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.

Re: Extraction of Location

MarcoWedel — Wed, 06 Mar 2024 20:10:48 GMT

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

Re: Extraction of Location

Raju_6952 — Thu, 07 Mar 2024 05:57:51 GMT

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.

Re: Extraction of Location

anat — Thu, 07 Mar 2024 06:36:07 GMT

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

];