Slicing

[lawrance]

Hi,

How to slice the below text using QlikView Script.

E:\Source_files\HISTORIC_0308171515.csv

Expected Output: 0308171515

Thanks,

Lawrance. A

[m_woolf]

purgechar(Subfield(YourText,'_',-1),'.csv')   as ExpOutput;

[sunny_talwar]

You can try like this

SubField(SubField(FieldName, '_', -1), '.', 1) as ExpectedOutput

[aarkay29]

KeepChar('E:\Shared_Common_Files\Static_Data\Meter_Read_Rate_Source_files\COMED_MTR_RDG_HISTORIC_0308171515.csv','0123456789')

[Anonymous]

load left(right('E:\Shared_Common_Files\Static_Data\Meter_Read_Rate_Source_files\COMED_MTR_RDG_HISTORIC_0308171515.csv',14),10) as field
AutoGenerate (1);