469,159 Members | 1,437 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,159 developers. It's quick & easy.

Changing file extension from REF to CSV

1
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
Mar 11 '08 #1
2 834
VBWheaties
145 100+
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:

Expand|Select|Wrap|Line Numbers
  1. Public Function FileExtensionREFToCSV(byVal REFFile As String) As String
  2.    FileExtensionREFToCSV = REPLACE(UCASE(TRIM(REFFile)), '.REF', '.CSV') 
  3. End Function 
  4.  
Mar 12 '08 #2
Killer42
8,435 Expert 8TB
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.REFERRING.TO.BLAH.REF" would become "SOMETHING.CSVERRING.TO.BLAH.CSV".
Mar 14 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by timothy.williams | last post: by
1 post views Thread by P Jones | last post: by
reply views Thread by rspoonz | last post: by
4 posts views Thread by Claire | last post: by
5 posts views Thread by pb | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.