BY CATEGORY▼
REPORT BUILDER CATEGORIES▼
REPORT BUILDER 2016 VIDEOS▼
- Report Builder Pt 1 - Installing Report Builder 2016
- Report Builder Pt 2 - Creating Your First Report
- Report Builder Pt 3 - Saving to a Report Server
- Report Builder Pt 4.1 - Embedded Data Sources and Datasets
- Report Builder Pt 4.2 - Shared Data Sources and Datasets
- Report Builder Pt 4.3 - Importing Datasets from Existing Reports
- Report Builder Pt 4.4 - Importing Datasets from SQL Query Files
- Report Builder Pt 4.5 - Datasets using Views
- Report Builder Pt 4.6 - Datasets using Stored Procedures
- Report Builder Pt 4.7 - Entering and Copying Data into a Report
- Report Builder Pt 5.1 - Basic Tables
- Report Builder Pt 5.2 - Sorting and Interactive Sorting in Tables
- Report Builder Pt 5.3 - Table Headers, Footers and Totals
- Report Builder Pt 5.4 - Repeating and Scrolling Table Headers
- Report Builder Pt 5.5 - Filtering Tables and Datasets
- Report Builder Pt 5.6 - Creating Or Filters in Datasets and Tables
- Report Builder Pt 6.1 - Grouping Rows in the Query Designer
- Report Builder Pt 6.2 - Grouping and Aggregating in a Table
- Report Builder Pt 6.3 - Creating Nested Parent and Child Groups
- Report Builder Pt 6.4 - Table Groups with Detail Rows
- Report Builder Pt 6.5 - Page Breaks and Headers in Table Groups
- Report Builder Pt 6.6 - Collapsible and Expandable Table Groups
- Report Builder Pt 6.7 - Recursive Table Groups
- Report Builder Pt 6.8 - Creating a Basic Matrix
- Report Builder Pt 6.9 - Matrix Nested Groups
- Report Builder Pt 7.1 - Basic Calculated Fields
- Report Builder Pt 7.2 - The IIf and Switch Functions
- Report Builder Pt 7.3 - Divide by Zero Errors
- Report Builder Pt 7.4 - And, Or, AndAlso, OrElse, Xor and Not
- Report Builder Pt 7.5 - Nulls in Expressions
- Report Builder Pt 7.6 - Calculating Date Parts
- Report Builder Pt 7.7 - Calculating Differences Between Dates
- Report Builder Pt 7.8 - Concatenating Values
- Report Builder Pt 7.9 - Trimming and Replacing Text
- Report Builder Pt 7.10 - Calculating First, Last and Middle Names
- Report Builder Pt 7.11 - Splitting and Joining Text
- Report Builder Pt 7.12 - Lookup, LookupSet and MultiLookup Functions
- Report Builder Pt 8.1 - Conditional Formatting in Tables
- Report Builder Pt 8.2 - Alternating Colours for Table Detail Rows
- Report Builder Pt 8.3 - Placeholders
- Report Builder Pt 9.1 - Aggregate Functions and Scope
- Report Builder Pt 9.2 - Percentage of Group Totals in a Table
- Report Builder Pt 9.3 - Percentage of Matrix Row and Column Totals
- Report Builder Pt 9.4 - Highlight Min and Max Values in a Table
- Report Builder Pt 9.5 - Highlight Min and Max Values in a Matrix
- Report Builder Pt 9.6 - Report Variables and Group Variables
- Report Builder Pt 9.7 - The RunningValue Function
- Report Builder Pt 9.8 - Alternating Row Colours in Grouped Tables
- Report Builder Pt 9.9 - The Previous Function
- Report Builder Pt 9.10 - Compare Previous Days, Months and Years
Report Builder 2016 videos | Report Builder Pt 7.9 - Trimming and Replacing Text
Posted by Andrew Gould on 18 December 2020
This video explains how to clean up messy text that you might have imported into a report using. You'll learn how to remove leading and trailing spaces using the Trim functions and how to get rid of unwanted characters using the Replace function in both Visual Basic and SQL.
You can increase the size of the video:
You can view the video in full screen mode as shown on the left, using the icon at the bottom right of the frame.
You can also increase the quality of the video:
You can improve the resolution of the video using another icon at the bottom right of the frame. This will slow down the connection speed, but increase the display and sound quality. This icon only becomes visible when you start playing the video.
Finally, if nothing happens when you play the video, check that you're not using IE in compatibility view.