Extracting values from string

[skzwane01]

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.

[sunny_talwar · Accepted solution]

May be this while you load the file

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

[zhadrakas]

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

regards
tim

[Brett_Bleess]

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