Trim 4 Characters from Right of String

[Stuugie]

Hi all,

With BIDS (Business Intelligence Development Studio)/SSIS, I have a process that downloads zipped CSV files. I store the files using the naming convention from the source ie 03260020-eng.csv. In a script task using BIDS, I would like to rename the file to exclude "-eng" but I'm not sure how to go about this. I have an idea to use a Right Trim but am unsure about the syntax. Can someone guide me with this?

[john.knapp]

str = Left(str, str.length -4)

[Reverend Jim]

Or you could do str = str.Replace("-eng","")

[john.knapp]

drat - no substr() in VB.Net...
:)

[Reverend Jim]

try str.SubString

[Stuugie]

Thanks to both of you. Either or works for me.

[john.knapp]

so much syntax, so little brainpower...
Thank you Reverend

[john.knapp]

Stuugie, please mark thread as solved if you're all set.
Thanks

[Stuugie]

Sorry about that! Won't happen again.