How to extract a value from a data/string field

[trishita]

I have a specific field named Carl_Combined_Key which has values like :

ID_1_TNO_93349345_RPK_1232_EPK_1111_CAR_ID_22.

How can I only extract and display  93349345 only from the whole value

What function should I use, subsfield or trim..Can anyone please explain

[trishita]

Fuel_Consumption_View:
Load

COMBINED_KEY,
FUEL_COMBINED_KEY,

//TextBetween(FUEL_COMBINED_KEY,'TMO_','_RPK') AS FUEL_COMBINED_KEY_NUMERIC,

subfield(COMBINED_KEY,'_',4)  as NewCombinedKey,

FC_CONSUMPTIVE_ENGINE_ID,
FC_MASS,
FC_FUEL_CONSUMPTION_IN_TONS,
FC_VALID_FROM_UTC,
FC_VALID_TO_UTC,
FC_VALID_FROM_TIMEZONE,
FC_VALID_TO_TIMEZONE

FROM

[$(vG.QVDPath)MO_NI_FUEL_CONSUMPTION_VIEW.qvd]

(qvd);


This worked..Thanks for the support

[trishita]

Thanks for the support