Create filename from column

kpierson109

I need a formula to create a name from a column that looks like this: jk.t1.t3.filename

The following formula works for certain files.

=LOWER(SUBSTITUTE(Filename@row, "_", "."))

I need to remove a word and underscore from specific items to create the filename.

Ex item: JK_T1_T3_Test_FileName

I would want the formula to remove "Test_" from these items.

Paul Newcome

You would use a second SUBSTITUTE function:

=LOWER(SUBSTITUTE(SUBSTITUTE(Filename@row, "_", "."), "Test_", ""))