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?
str = Left(str, str.length -4)
Or you could do str = str.Replace("-eng","")
drat - no substr() in VB.Net...
:)
try str.SubString
Thanks to both of you. Either or works for me.
so much syntax, so little brainpower...
Thank you Reverend
Stuugie, please mark thread as solved if you're all set.
Thanks
Sorry about that! Won't happen again.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.
