tS3List Case Sensitive

[Papademuchos]

Hello,

I'm trying to pull files from AWS using tS3List. As long as the prefix matches the file case, it works fine. But if the case is different, it passes over it. For example:

Key prefix: in

Filename: inside.txt <match>

Filename: into.txt <match>

Filename: INandOUT.txt <no match>

Is there any way to use the tS3List so it's not case-sensitive?

Thanks for your help!

[gjeremy1617088143]

Hi,

Unlike standard Windows file systems, the Amazon S3 storage is case-sensitive.

so you have to use tS3List four time :

Key prefix :

in

IN

iN

In.

Send me Love and Kudos

[Papademuchos]

Wow - no way around this huh? So if I'm expecting a file "Benefit_Plan.txt" I have to anticipate all possible ways they might name that file? Currently it's required to be lower case, but I was hoping to code around that.

[gjeremy1617088143 · Accepted solution]

So ,i can suggest you to list all the files with the ts3List, then you can transform the name to lower case et filter on those you want.

[Papademuchos]

This works - thanks for the suggestion. I added a tFilterRow and filtered out the ones that I want using the Advanced option with tLowerCase() and matches().