Text value

[NavinReddy]

Hello Dear Experts,

i want to get the data to avoiding brackets data on textbox

i have tried but i'm not able to do it. can some one help me to get the exact answer

Textbox = Total Pricing Exception Rate (BCF1542) %,

Trying to get out put excluding '(BCF1542)' data

Textbox =Total Pricing Exception Rate %

Best Regards,

Niranjan

[sunny_talwar · Accepted solution]

May be this:

=SubField(FieldName, '(', 1) & '%'

or may be this:

=SubField(FieldName, '(', 1) & SubField(FieldName, ')', 2)

[NavinReddy]

Thank you so muchsunny its working fine