.NET regular expression to replace #$# special ASCII characters

Help pleaseâ?¦ - I have a report with textbox field called â'Bulletsâ' â' using
#$# special ASCII characters (pound-dollar-pound) as bullet delimiter from
legacy print publishing system.
Questions:
1. What is the correct .NET regular expression to replace #$# special ASCII
characters within textbox field to display Bullet textâ?¦?
2. Can textbox field display Bullet textâ?¦?
Please advise MSDN or Books Online references for .NET regular expression
Replace syntax.
Thank you.
MichaelHere is an example
Input Text: tester#$#bullet_1#$#bullet_2#$#bullet_3#$#bullet_4
Regular Expression: (ASCII char Octal) \043\044\043
Replace Expression: (ASCII char Octal) \015\011\052\040\040\040
Question: Is there a Code Customization example for parsing a textbox field
and replacing regular expression characters with HTML Bullets - like
<BR><FONT family=Wingding>something_bullet_symbol</FONT><TAB>
Please advise.
"Michael" wrote:
> Help pleaseâ?¦ - I have a report with textbox field called â'Bulletsâ' â' using
> #$# special ASCII characters (pound-dollar-pound) as bullet delimiter from
> legacy print publishing system.
> Questions:
> 1. What is the correct .NET regular expression to replace #$# special ASCII
> characters within textbox field to display Bullet textâ?¦?
> 2. Can textbox field display Bullet textâ?¦?
> Please advise MSDN or Books Online references for .NET regular expression
> Replace syntax.
> Thank you.
> Michael
>|||I tried this expression
=IIF(Fields!product_Bullets.Value=#$#, Fields!product_Bullets.Value=*)
Got the following error
The value expression for the textbox â'Product_Bulletsâ' contains an error:
[BC30201] Expression expected.
Please advise the correct expression syntax.
"Michael" wrote:
> Here is an example
> Input Text: tester#$#bullet_1#$#bullet_2#$#bullet_3#$#bullet_4
> Regular Expression: (ASCII char Octal) \043\044\043
> Replace Expression: (ASCII char Octal) \015\011\052\040\040\040
> Question: Is there a Code Customization example for parsing a textbox field
> and replacing regular expression characters with HTML Bullets - like
> <BR><FONT family=Wingding>something_bullet_symbol</FONT><TAB>
> Please advise.
> "Michael" wrote:
> > Help pleaseâ?¦ - I have a report with textbox field called â'Bulletsâ' â' using
> > #$# special ASCII characters (pound-dollar-pound) as bullet delimiter from
> > legacy print publishing system.
> >
> > Questions:
> >
> > 1. What is the correct .NET regular expression to replace #$# special ASCII
> > characters within textbox field to display Bullet textâ?¦?
> > 2. Can textbox field display Bullet textâ?¦?
> >
> > Please advise MSDN or Books Online references for .NET regular expression
> > Replace syntax.
> >
> > Thank you.
> > Michael
> >|||I tried this expression - OK
=IIF(Fields!product_Bullets.Value="chr(35) + chr(36) + chr(35)", "",chr(13)
+ chr(42) + chr(9))
"Michael" wrote:
> I tried this expression
> =IIF(Fields!product_Bullets.Value=#$#, Fields!product_Bullets.Value=*)
> Got the following error
> The value expression for the textbox â'Product_Bulletsâ' contains an error:
> [BC30201] Expression expected.
> Please advise the correct expression syntax.
>
> "Michael" wrote:
> > Here is an example
> >
> > Input Text: tester#$#bullet_1#$#bullet_2#$#bullet_3#$#bullet_4
> >
> > Regular Expression: (ASCII char Octal) \043\044\043
> >
> > Replace Expression: (ASCII char Octal) \015\011\052\040\040\040
> >
> > Question: Is there a Code Customization example for parsing a textbox field
> > and replacing regular expression characters with HTML Bullets - like
> > <BR><FONT family=Wingding>something_bullet_symbol</FONT><TAB>
> >
> > Please advise.
> >
> > "Michael" wrote:
> >
> > > Help pleaseâ?¦ - I have a report with textbox field called â'Bulletsâ' â' using
> > > #$# special ASCII characters (pound-dollar-pound) as bullet delimiter from
> > > legacy print publishing system.
> > >
> > > Questions:
> > >
> > > 1. What is the correct .NET regular expression to replace #$# special ASCII
> > > characters within textbox field to display Bullet textâ?¦?
> > > 2. Can textbox field display Bullet textâ?¦?
> > >
> > > Please advise MSDN or Books Online references for .NET regular expression
> > > Replace syntax.
> > >
> > > Thank you.
> > > Michael
> > >|||Please help with regular expression syntax.
I have tried both these two expressions, using ascii hex - but I am still
getting lost on the on whether or not Reporting Services will support the
Replace function including a ascii hex Carriage Return or an ascii hex
Horizontal Tab replace string...?
=Replace(Fields!product_Bullets.Value, "[chr(35) + chr(36) + chr(35)]",
"chr(13) + chr(42) + chr(9)", "1", "-1", "1")
=Replace(Fields!product_Bullets.Value, "([\x23][\x24][\x23])",
"([\xD][\x2A][\x9])", "1", "-1", "1")
Please advise any suggestions for correct regular expression syntax.
"Michael" wrote:
> I tried this expression - OK
> =IIF(Fields!product_Bullets.Value="chr(35) + chr(36) + chr(35)", "",chr(13)
> + chr(42) + chr(9))
> "Michael" wrote:
> > I tried this expression
> >
> > =IIF(Fields!product_Bullets.Value=#$#, Fields!product_Bullets.Value=*)
> >
> > Got the following error
> >
> > The value expression for the textbox â'Product_Bulletsâ' contains an error:
> > [BC30201] Expression expected.
> >
> > Please advise the correct expression syntax.
> >
> >
> > "Michael" wrote:
> >
> > > Here is an example
> > >
> > > Input Text: tester#$#bullet_1#$#bullet_2#$#bullet_3#$#bullet_4
> > >
> > > Regular Expression: (ASCII char Octal) \043\044\043
> > >
> > > Replace Expression: (ASCII char Octal) \015\011\052\040\040\040
> > >
> > > Question: Is there a Code Customization example for parsing a textbox field
> > > and replacing regular expression characters with HTML Bullets - like
> > > <BR><FONT family=Wingding>something_bullet_symbol</FONT><TAB>
> > >
> > > Please advise.
> > >
> > > "Michael" wrote:
> > >
> > > > Help pleaseâ?¦ - I have a report with textbox field called â'Bulletsâ' â' using
> > > > #$# special ASCII characters (pound-dollar-pound) as bullet delimiter from
> > > > legacy print publishing system.
> > > >
> > > > Questions:
> > > >
> > > > 1. What is the correct .NET regular expression to replace #$# special ASCII
> > > > characters within textbox field to display Bullet textâ?¦?
> > > > 2. Can textbox field display Bullet textâ?¦?
> > > >
> > > > Please advise MSDN or Books Online references for .NET regular expression
> > > > Replace syntax.
> > > >
> > > > Thank you.
> > > > Michael
> > > >