topic Slicing in QlikView

Slicing

lawrance — Thu, 16 Mar 2017 17:36:35 GMT

Hi,

How to slice the below text using QlikView Script.

E:\Source_files\HISTORIC_0308171515.csv

Expected Output: 0308171515

Thanks,

Lawrance. A

Re: Slicing

m_woolf — Thu, 16 Mar 2017 17:38:28 GMT

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

Re: Slicing

sunny_talwar — Thu, 16 Mar 2017 17:38:56 GMT

You can try like this

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

Re: Slicing

aarkay29 — Thu, 16 Mar 2017 17:40:22 GMT

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

Re: Slicing

Anonymous — Thu, 16 Mar 2017 17:44:17 GMT

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);