String Manipulation (A2K)

Topic

New Reply

I have files that are named in the following fashion:

ABC_123_456.txt

I want to capture the entire name LESS the “.txt”. How can I do this?

I know it will require string manipulation but can’t quite get it together.

Reply | Quote

Replies

If you have a string variable strFile that contains the file name, you can use

Left(strFile, InStr(strFile, ".") - 1)

This assumes that the period (point) before txt is the only one in the name.

Reply | Quote

B E A U T I F U L !!!!!!!

As always, thanks Hans.

Reply | Quote