Val Rule not working

[sachin_thombre]

Hello SAP Team, Need your inputs for setting up validation rule

Requirement: Users should not be able to enter "|" Pipe delimiter in Text Field for Company Code "ABC" & Vendor Recon "999999"

Issue: I have setup the validation rule as below, but it is only working when "|" is entered in text field without entering any other text in that field. In actual business scenario Pipe Delimiter is entered as "text |" OR "text| text"

Need your inputs how to setup "check" rule, which should pickup validations when text is having (a) Only pipe delimiter Eg: "|" (b) combination of pipe & text Eg: "Testing | testing"

Validation Rule:

Prerequisite: (sets used here)

Company Code IN CO_CODES AND

G/L Account IN RECON_GL

Check:

Text <> ' |'

Message:

Pipe delimiter is not allowed to enter in text field.

[turkaj]

Hello Sachin,

Can't you rearrange your check as follows?

"Check:
Text NS '|'

Regards
Jim

[sachin_thombre]

Hi Jim - I do not see NS, how do we enter NS can you please guide?

[turkaj]

Try it with:

NOT ( Text LIKE '*|*' )

[sachin_thombre]

Thanks for replying, but it did not work, I am now thinking of using user exits