Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

lawrance
Contributor II

Slicing

Hi,

How to slice the below text using QlikView Script.

E:\Source_files\HISTORIC_0308171515.csv

Expected Output: 0308171515

Thanks,

Lawrance. A

4 Replies
mwoolf
Honored Contributor II

Re: Slicing

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

Re: Slicing

You can try like this

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

aarkay29
Valued Contributor

Re: Slicing

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

robin_hausdoerfer
Valued Contributor III

Re: Slicing

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