Search Results

I am a beginner to scripting, please help me in this regard.

How do I create a script that provides a count of distinct values of all the fields in the pipe delimited file ? I have 20 different...

I am a beginner to scripting, please help me in this regard.

How do I create a script that provides a count of distinct values of all the fields in the pipe delimited file ? I have 20 different...

Hi experts,
I am new to scripting. I have a requirement as below.

File1:

A|123|NAME1
A|123|NAME2
B|123|NAME3

File2:

C|123|NAME4
C|123|NAME5
D|123|NAME6

1) I have 2 merge both the...

awk 'BEGIN{OFS=FS=","}{$4=$5=$19=""}{print}' input.csv > output.csv

Hi,
I have a file with 104 columns delimited by comma.

I have to replace fields 4,5 and 19 with null values and after replacing the columns in the file , the file should be still comma delimited....

$ awk -F" " 'BEGIN{printf "%s %s %s\n", "FIRST_NAME,", "LAST_NAME,","MAIL_ID"} /key1/{print $2,",",$3,",",$4}' test.txt > test.csv

Thankx for the reply,

I tested this with duplicate values and also unique muliple values in the column of the file and its always returning 1

data in the file

,,02132007
,,03132007
...

Hi,

I am new to unix and I need help in solving below mentioned issue, really appreciate ur help.

I have a file

sam, john, 2324, 07142007
tom, thomson, 2343, 07142007
john, scott, 2478,...