Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to slice the below text using QlikView Script.
E:\Source_files\HISTORIC_0308171515.csv
Expected Output: 0308171515
Thanks,
Lawrance. A
purgechar(Subfield(YourText,'_',-1),'.csv') as ExpOutput;
You can try like this
SubField(SubField(FieldName, '_', -1), '.', 1) as ExpectedOutput
KeepChar('E:\Shared_Common_Files\Static_Data\Meter_Read_Rate_Source_files\COMED_MTR_RDG_HISTORIC_0308171515.csv','0123456789')
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);