Hi
i have used rename file activity.
Do I need to mention extension type also while renaming
what if the sometimes if the original file is .xls or .csv
Yes you have to put file extension.
Yes we need to specify extension type also.
Ya but some files might be of type .csv, .xlx, .xls all are excel sheets how to I know? It iso of which type
@KarthikBallary
from where you are getting files?
If you change file extension type then file will get renamed and corrupted.
those are downloaded files
ok I can get the file
example filename.nme_xxxx.yyyy.xlsx
tell the substring so that I can get only .xlsx
Fantastic
while mentioning the renamed file name
get the file extension from the file been passed as input (which is going to be renamed)
like this
out_extension = Split(in_filepath,“.”)(1).ToString
this will give us xlsx or csv or xls as a string
now with the rename property mention this at last like concatenating
yourfilename+“.”+out_extenstion
simple isnt it
Cheers @KarthikBallary
@KarthikBallary
So are saving it in any folder?
I mean last index (.) to …last position
@KarthikBallary
If you knows the full path of file then you can get the Extension using Path.GetExtension(“YourPath”).
does it hold good if there any numbe rof “.” in filename?
thats a good question
usually we wont have . unless its before fileextension
if we do so , it will show error as illegal characters in file path
Cheers @KarthikBallary
Ya I mean the same is it going to last “.” we don’t have any dots after extension
yah no dot after extension because thats the last one followed by fileextension
so split(instring,“.”)(1).ToString will surely give the file extension alone
exactly
Cheers @KarthikBallary
Split(in_filepath,“.”)(1).ToString whats “(1)” here? is it first index
@KarthikBallary Try to use this.
is returning ".xlx " or only “xlx”