C
Curious
Hi,
I have a table with the following column names:
BOOK, CCY, IR(1Y), IR(2Y), IR(1M), IR(2M), IR(3M), IR(6M)
I want to strip "IR" as well as "(" and ")" off those column names. I
want the column names to be
BOOK, CCY, 1Y, 2Y, 1M, 2M, 3M, 6M
I use regular expression as below:
column.ColumnName =
System.Text.RegularExpressions.Regex.Replace(column.ColumnName,
"^IR(*)", string.Empty);
However, this give me a runtime error: "parsing \"^IR(*)\" -
Quantifier {x,y} following nothing."
Could anyone advise how to get it fixed?
I have a table with the following column names:
BOOK, CCY, IR(1Y), IR(2Y), IR(1M), IR(2M), IR(3M), IR(6M)
I want to strip "IR" as well as "(" and ")" off those column names. I
want the column names to be
BOOK, CCY, 1Y, 2Y, 1M, 2M, 3M, 6M
I use regular expression as below:
column.ColumnName =
System.Text.RegularExpressions.Regex.Replace(column.ColumnName,
"^IR(*)", string.Empty);
However, this give me a runtime error: "parsing \"^IR(*)\" -
Quantifier {x,y} following nothing."
Could anyone advise how to get it fixed?