topic Re: Extracting values from string in QlikView

Extracting values from string

skzwane01 — Sat, 16 Nov 2024 02:05:08 GMT

Hi,

Please see below. I would like to extract the values highlighted and create a new field.

EG: 2_6058_Resignation_Demographics_2019-10-28_00_00_00_2019-10-29_00_00_00 I want to only keep 6058

Please assist.

Re: Extracting values from string

sunny_talwar — Wed, 30 Oct 2019 12:39:44 GMT

May be this while you load the file

LOAD SubField(FileBaseName(), '_', 2) as NewField

Re: Extracting values from string

zhadrakas — Wed, 30 Oct 2019 12:41:22 GMT

maybe like this
Load *,
subfield(subfield(filename(), '2_', -1),'_',1) as Version1
FROM yourfile;

regards
tim

Re: Extracting values from string

Brett_Bleess — Thu, 07 Nov 2019 13:30:02 GMT

Sanele, did Sunny or Tim's posts help you get things working as you wished? If so, be sure to return to the thread and use the Accept as Solution button on the post that helped you get things working to give credit for the help and let others know what worked. If you are still working on things and need further help, please leave an update.

Regards,
Brett