Hi everyone,
I would like to obtain information from the datafile name and tab using the RegEx (Parse) Tool. In particular, I would like to obtain the "month.year" and Sheet name from a document:
"...\Hours\KA_04.2020.xlsx|||`CC123456_Sales Customer Service$`"
I figured it out how to get the month.Year information --> (\d{2}.\d{4})
But I am struggling to get the information "CC123456" and "Sales Customer Services" from the string.
Can anyone help?
as requested:
regex_replace([filename],".*(\d{2)\.(\d{4}.*\'(.*)\$.*",'$1|$2|$3')
this will give you a pipe delimiter result in a formula or you can use regex parse with the expression inside of the double quotes.
cheers,
mark