Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SSRS - Format string with REGEX function

Mar 31 2012 12:00AM by Alpesh Gorasia   

The Regex functions are useful for changing the format of existing strings, for example, suppose you want to display Phone no in (ddd) ddd-dddd format instead of ddd-ddd-dddd. To do this, Right click on the required textbox --> click expression... and enter below expression:

=System.Text.RegularExpressions.Regex.Replace("301-222-6666", "(\d{3})[ -.]*(\d{3})[ -.]*(\d{4})", "($1) $2-$3")

Output : (301) 222-6666

Read More..   [69 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Alpesh Gorasia
131 · 1% · 392
14
 
4
 
10
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

Your Comment


Sign Up or Login to post a comment.

"SSRS - Format string with REGEX function" rated 5 out of 5 by 14 readers
SSRS - Format string with REGEX function , 5.0 out of 5 based on 14 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]