How to keep all charaters before a period?

schou1994 — Fri, 09 Jun 2023 22:05:41 GMT

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!

Re: How to keep all charaters before a period?

txnelson — Tue, 09 Feb 2021 00:33:42 GMT

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

topic Re: How to keep all charaters before a period? in Discussions

How to keep all charaters before a period?

Re: How to keep all charaters before a period?