Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this while you load the file
LOAD SubField(FileBaseName(), '_', 2) as NewField
May be this while you load the file
LOAD SubField(FileBaseName(), '_', 2) as NewField
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