Filter more data in single column

Shell Programming and Scripting
1

Hi All,

One of my source file column name RelationshipNumber. I need to filter below mentioned records in RelationshipNumber column.

 
RelationshipNumber:
S45678
D89763
Y09246579
A91234

If it is available in above mentioned column, then I need to print the entire line from my source file.

 
Source File Name is : US_Relation_File.txt
File Delimiter : |

I can able to extract data only one data at a time based on below mentioned condition. But don't know how to filter multiple data from the same column.

awk -F'|' ' $1=="S45678" ' US_Relation_File.txt

Kindly help me how to achieve this

2

Add other RelationshipNumber conditions with Logical OR as below

awk -F'|' ' $1=="S45678" || $1 =="D89763" ' US_Relation_File.txt
3

Thanks Anbu for your kind reply :slight_smile: