- Posts: 86
- Thank you received: 0
Case Sensitivity in downloading via FTP Operation
- Steve Vaughn
- Topic Author
- Offline
- Premium Member
-
Less
More
13 years 6 days ago #999
by Steve Vaughn
Case Sensitivity in downloading via FTP Operation was created by Steve Vaughn
I am utilizing a mask when downloading files via the FTP Operation. My mask is currently set at *.csv allowing me to download dynamic file names in a .csv format.
The problem I am having is when a customer posts a file with a file name in all CAPS, i.e. <filename>.CSV
The mask within the FTP Download Operation does not recognize the file because of the UPPERCASE .CSV Is there a way around this or can the FTP Download Operation be changed to not be case sensitive?
The mask function within the transformation reader is not case sensitive. Shouldn't this be the same?
Please advise.
Thank You!
The problem I am having is when a customer posts a file with a file name in all CAPS, i.e. <filename>.CSV
The mask within the FTP Download Operation does not recognize the file because of the UPPERCASE .CSV Is there a way around this or can the FTP Download Operation be changed to not be case sensitive?
The mask function within the transformation reader is not case sensitive. Shouldn't this be the same?
Please advise.
Thank You!
Please Log in or Create an account to join the conversation.
13 years 6 days ago #1005
by admin
Mike
ETL Architect
Replied by admin on topic Re:Case Sensitivity in downloading via FTP Operation
Hmm.. Interesting question
Windows search is not case sensitive, FTP is and we can't change it
Our software does not perform any ftp searches we send "ls mask" command to the FTP server and download what ever the server returns
May be it is possible to make the server not case sensitive but it depends on the FTP server
However there is another solution you can use
Just create two FTP objects instead of one use *.csv mask for one and *.CSV for another
Mike
Windows search is not case sensitive, FTP is and we can't change it
Our software does not perform any ftp searches we send "ls mask" command to the FTP server and download what ever the server returns
May be it is possible to make the server not case sensitive but it depends on the FTP server
However there is another solution you can use
Just create two FTP objects instead of one use *.csv mask for one and *.CSV for another
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- Steve Vaughn
- Topic Author
- Offline
- Premium Member
-
Less
More
- Posts: 86
- Thank you received: 0
13 years 5 days ago #1010
by Steve Vaughn
Replied by Steve Vaughn on topic Re:Case Sensitivity in downloading via FTP Operation
Mike,
Thanks for the response. I will add a secondary FTP Download Operation.
Thanks
Thanks for the response. I will add a secondary FTP Download Operation.
Thanks
Please Log in or Create an account to join the conversation.