Search Results

I tried using Jean-Pierre's solution and it worked for me. Thanks everyone.

Chakrapani,

You were very close, this is what got after I ran a script.

number|GGS_LOG_SEQ|NULL
number|GGS_ORACREC_SCN|NULL
number|GGS_LOG_POS|NULL
varchar2|GGS_COMMIT_CHAR|NULL...

I hava a file with following data:

number|CREDIT_ID|NULL
date|SYS_CREATION_DATE|NULL
varchar2|GGS_COMMIT_CHAR|NULL
varchar2|GGS_OP_TYPE|NULL
number|GGS_SCN|NULL|
number|GGS_LOG_SEQ|NULL...

I have a data in a file called data1.dat like this:
70815|1418|V|F70816|1418|V|M
70817|1418|V|M70818|1418|V|F
70819|1418|V|M

I want the output like this:
70815|1418|V|F
70816|1418|V|M...

Following is the CSV file, separated by ","
100,sunil,$1,000,mumbai
101,amit,$10,000,mumbai
102,sailesh,$10,000,00,mumbai

I want the following output:
100,sunil,$1000,mumbai...

I have prepared the shell script. Thanks.

Pls see the shell script:

TestValid()
{
while read -r line
do
echo ${line} | awk -F"|" '{
if (NF == sep_num)
printf("%s\n", $0) >>...

Hi,

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

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...