Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
=SubField(FieldName, '(', 1) & '%'
or may be this:
=SubField(FieldName, '(', 1) & SubField(FieldName, ')', 2)
May be this:
=SubField(FieldName, '(', 1) & '%'
or may be this:
=SubField(FieldName, '(', 1) & SubField(FieldName, ')', 2)
Thank you so muchsunny its working fine