Validation of character separated lines in a file

kolesunil · #1 (**permalink**) 05-27-2008

Hi,

I have a file with "|" separated fields. If the line doesn't contain n "|" (say 2), then put this line in a file called invalid_file.txt. If it does put this row in a file called valid_file.txt.

For e.g. A file contain following rows:

Code:

Hi|Hello
How|Are|You
Hello

then
invalid_file.txt should contain:

Code:

How|Are|You
Hello

valid_file.txt should contain:

Code:

Hi|Hello

Any help is highly appreciated.

Thanks,
SK

kolesunil · #2 (**permalink**) 05-27-2008

I have prepared the shell script. Thanks.

Pls see the shell script:

Code:

TestValid()
{
while read -r line
do
echo ${line} | awk -F"|" '{
if (NF == sep_num)
   printf("%s\n", $0) >> fname"_valid_rec";
else
   printf("%s\n", $0) >> fname"_invalid_rec"
}' sep_num="${2}" fname="${1}"
done < ${1}
}

while read -r col1 col2
do
if [ -f ${col1}"_valid_rec" ]; then
  rm ${col1}"_valid_rec"
fi
if [ -f ${col1}"_invalid_rec" ]; then
  rm ${col1}"_invalid_rec"
fi
TestValid ${col1} ${col2}
if [ -f ${col1}"_invalid_rec" ]; then
   mv ${col1} ${col1}"_org"
fi
if [ -f ${col1}"_valid_rec" ]; then
   mv ${col1}"_valid_rec" ${col1}
fi
done < para_new.cfg

Franklin52 · #3 (**permalink**) 05-27-2008

With awk you can do this with a oneliner:

Code:

awk 'BEGIN{FS=OFS="|"}NF==2{print $0 > "valid_file.txt";next}{print $0 > "invalid_file.txt"}' file

Use nawk or /usr/xpg4/bin/awk on Solaris if you get errors.

ripat · #4 (**permalink**) 05-27-2008

You could have used awk:

Code:

awk -F "|" 'NF!=2' file > output

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
"\|" separated file validations	kolesunil	Shell Programming and Scripting	1	05-27-2008 05:19 AM
Separate lines in a single '\|' separated line	hidnana	Shell Programming and Scripting	3	03-17-2008 10:16 AM
Replace a perticular character of all lines of a file	abovais	Shell Programming and Scripting	1	12-11-2007 05:35 AM
two lines into one colon separated line...	tonlu	Shell Programming and Scripting	2	03-30-2005 10:27 AM
character validation	ruffenator	High Level Programming	9	05-02-2002 02:13 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by