357266_en-US

liliconcom

How to keep all charaters before a period?

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!

ScriptingRe: How to keep all charaters before a period?

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, ".");