SSRS Report Builder Part 7.9 - Trimming and Replacing Text

[@1M4C1999]

Thank you for this whole series Andrew, invaluable stuff for someone learning the intricacies of PBIRB!

[@jayong1418]

Thanks, this solved my issue.

[@WiseOwlTutorials]

Happy to hear it Jay, thanks for watching!

[@NS-tp3vr]

Is there a way to remove all character after a symbol ?

[@WiseOwlTutorials]

After a specific symbol? Or just any symbol? If it's a specific symbol then sure, let's say you wanted to remove everything after a / character from a field: =Left(Fields!MyField.Value, InStr(Fields!MyField.Value, "/")) Hope it helps!

[@kartickchakraborty9135]

Hello Sir, Recently, I've faced some problems in my office work. In order to solve those problems, I came up with 3 ideas. But due to shallow knowledge in VBA, I couldn't implement those ideas in reality to sort out those issues. I've given my 3 questions below one by one. I believe, you'll definitely help me. 001) Is it possible to create Spilled Array (Dynamic Array) like function in VBA. I mean to say creating User Defined Function like Spilled / Dynamic Array Functions (Filter, RandArray, Sequence, Sort, SortBy and Unique Functions) in Excel (Office 365 Version). 002) How do I split First Names, Middle Names (If Available) and Last Names with one single User Defined Function in VBA? Is it also possible in VBA? 003) How to use VBA Split Function with Multiple Delimiters?