How to keep all charaters before a period?

[#1]

Hi all,

This is a simple question I am sure...but I have a column filled with file names "xfsfds.csv" and "sdfdgdfg.csv"

What if I want to just keep the names in the column, and get rid of all the ".csv" at the end?

Thanks!

[#2 · Accepted solution]

For the example, I am calling the column name you have your file names in, "FileName"

For Each Row(
     :FileName = word(1,:FileName,".");
);

If you create a new column and want to use a formula to change the values all you have to do is to create a new character column, and specify the formula:

word(1, :FileName, ".");