Hi,
Can you help me please with changing this date format 22 Aug 2018 into this 20180822?
Is it possible?
Thanks!
(\d\d) (Jan|Feb|Mar|Apr|Mai|Jun|Jul|Aug|Sep|Okt|Nov|Dez) ((19|20)\d\d)(?X)(:Jan)(?X)(:Feb)(?X)(:Mar)(?X)(:Apr)(?X)(:Mai)(?X)(:Jun)(?X)(:Jul)(?X)(:Aug)(?X)(:Sep)(?X)(:Okt)(?X)(:Nov)(?X)(:Dez)
$3:$2$1(?X)01(?X)02(?X)03(?X)04(?X)05(?X)06(?X)07(?X)08(?X)09(?X)10(?X)11(?X)12
(\b|_)(\d-\d\d-)(19|20)(\d\d)(\b|_)/g(?X)(\b|_)(\d\d-\d\d)-(19|20)(\d\d)(\b|_)/g
${1}0$2$3$4$5(?X)${1}$3$4-$2$5
Hasse wrote:I am not sure if company is always within parentesis or if the company name is always the same, but you can try this:
In my example below I have used different company names just in case they vary.
Under RegEx (1) on the left side of the BRU interface:
Match:
(.+)\((\d\d)\.(\d\d)\.(\d\d\d\d)
Replace:
\1 (\4.\3.\2)
Before change:
Production company1 (30.11.2015).pdf
Production company2 (02.03.2015).pdf
Production company3 (15.09.2015).pdf
Production company4 (02.10.2016).pdf
Production company5 (30.12.2014).pdf
After change:
Production company1 (2015.11.30).pdf
Production company2 (2015.03.02).pdf
Production company3 (2015.09.15).pdf
Production company4 (2016.10.02).pdf
Production company5 (2014.12.30).pdf
Try it in a testfolder, just to be on the safe side.
I hope it helps!
/Hasse
evh5150ni wrote:Hasse wrote:I am not sure if company is always within parentesis or if the company name is always the same, but you can try this:
In my example below I have used different company names just in case they vary.
Under RegEx (1) on the left side of the BRU interface:
Match:
(.+)\((\d\d)\.(\d\d)\.(\d\d\d\d)
Replace:
\1 (\4.\3.\2)
Before change:
Production company1 (30.11.2015).pdf
Production company2 (02.03.2015).pdf
Production company3 (15.09.2015).pdf
Production company4 (02.10.2016).pdf
Production company5 (30.12.2014).pdf
After change:
Production company1 (2015.11.30).pdf
Production company2 (2015.03.02).pdf
Production company3 (2015.09.15).pdf
Production company4 (2016.10.02).pdf
Production company5 (2014.12.30).pdf
Try it in a testfolder, just to be on the safe side.
I hope it helps!
/Hasse
I have a really similar query and I just can't quite adapt the RegEx.
Before change:
08-12-2000 - xxx - yyy
After change:
2000-08-12 - xxx - yyy
Thanks in advance!