Search Results

hi Rudi

i did and it works fine now with all entries (165) , the first line in VI file was empty , after i remove it it works fine , i wonder if this empty line make the command skip the execution...

hi Rudic

whe i did sample with only 3 entries in the VI file it work ok , when i make my bigger sample (165 entry in VI ) it again copy all the dump lines (which is about 4M lines for about 180K...

here is the OS

-bash-3.00$ uname -a
SunOS ALU_STC_GW 5.10 Generic sun4u sparc SUNW,Sun-Blade-100
-bash-3.00$

i dont know how to get grep version , however i found this fgrep and when i use...

Hi Rudic

i gt this error :

-bash-3.00$ grep -if dec18PND.csv EP-ports-faults_20161218.csv > file2.csv
grep: illegal option -- f
Usage: grep -hblcnsviw pattern file . . .
-bash-3.00$


...

Dears experts

i have UNIX file that contain 4 million lines , i need to extract all lines that have entiries saved in VI file , i have below comand but it takes tooooo long time :

for i in...

Thanks Rudic and all friends replied , answers are perfect and i have it clear now.

Hello dear friend.

it works perfectly , thanks alot

-bash-3.00$ nawk -F, '(FNR==NR) { A[$1]++; next } (A[$1]>=5 && $1~/MUR|ULY|Klj|KAL|KHU|MAT|ADL|YSM|AMA|SIN|ZAM|MAL|SUL/) { print $0, A[$1] }...

Thanks alot Rudic , it works perfectly ..

---------- Post updated at 10:23 AM ---------- Previous update was at 10:13 AM ----------

Hello Rudic
on last code you give , if i want to get lines...

Hello dears

it seems working ok now , below is the command :


-bash-3.00$ nawk -F, 'FNR==NR{A[$1]++;next} ($1 in A){print $0 FS A[$1]}' INTCONT-IS.CSV INTCONT-IS.CSV > newintwithcount.CSV
...

Hello friends

i run it and i got below error (sorry i am still beginner )"

-bash-3.00$ awk -F, 'FNR==NR{A[$1]++;next} ($1 in A){print $0 FS A[$1]}' INTCONT-IS.CSV intwithcount.CSV
awk:...

Hello Singh

Thanks alot ,
i have only one separator which is (,) , for example the following is one entry : M205-00-106_AMDRN:1-0-6-22

so is the above still valid or there is a change to be...

Dears

i want to extract lines only that have first entry repeated 3 times or above , ex data :

-bash-3.00$ cat INTCONT-IS.CSV
M205-00-106_AMDRN:1-0-6-22,12-662-4833,intContact,2016-11-15...

Dear friends

i have big file and i want to export the filw with new column for the lines that have same duplicate value in first column : ex : , ex :


-bash-3.00$ cat INTCONT-IS.CSV...