Ben SmithBen Smith
Ben Smith/
Manipulating Articles ('The', etc.)
Manipulating Articles ('The', etc.)
Manipulating Articles ('The', etc.)

Manipulating Articles ('The', etc.)

For
The_Fairy_Feller
From
Reddit
Status
Updating
Formulas
+
+
if
if
replace
replace
slice
slice
test
test
Share
The

Remove 'The'

replace(prop("Title"), "[T|t]he ", "")

Add 'The' to End

replace(prop("Title"), "[T|t]he ", "") + if(test(prop("Title"), "[T|t]he "), ", " + slice(prop("Title"), 0, 3), "")
 
Der/Die/Das

Remove Der/Die/Das

replace(prop("Title"), "[D|d]er |[D|d]ie |[D|d]as ", "")

Add Der/Die/Das to End

replace(prop("Title"), "[D|d]er |[D|d]ie |[D|d]as ", "") + if(test(prop("Title"), "[D|d]er |[D|d]ie |[D|d]as "), ", " + slice(prop("Title"), 0, 3), "")
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!