Changing file extension from REF to CSV

[Asuepe]

Hi there,

It's my 1st participation her..
I make scripts in my work wz a language that is similar to VB

I need a script to Chang file extension from REF to CSV

any help ?

Thx in advance,
Regards

[VBWheaties]

Hi there,

It's my 1st participation her..
I make scripts in my work wz a language that is similar to VB

I need a script to Chang file extension from REF to CSV

any help ?

Thx in advance,
Regards

Real simple to do thanks to the handy Replace function:

Public Function FileExtensionREFToCSV(byVal REFFile As String) As String
   FileExtensionREFToCSV = REPLACE(UCASE(TRIM(REFFile)), '.REF', '.CSV') 
End Function

[Killer42]

Be warned though, this simple routine will stuff up the name if ".REF" appears anywhere else within it. For example, a file name of "SOMETHING.REFER RING.TO.BLAH.RE F" would become "SOMETHING.CSVERRING.TO.BLAH.CSV".