Check for null values in a columns. I have dozen of CSV files in a directory. Post: 303008958

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to check Null values in a file column by column if columns are Not NULLs

Hi All, I have a table with 10 columns. Some columns(2nd,4th,5th,7th,8th and 10th) are Not Null columns. I'll get a tab-delimited file and want to check col by col and generate seperate error code for each col eg:102 if 2nd col value is NULL and 104 if 4th col value is NULL so on... I am a...

2. UNIX for Dummies Questions & Answers

Check for null values in a column

Hi All, I have a file with 10 columns and get the required data for nine columns properly except 8th. In 8th column i have both NULL and NON NULL values...i.e certain records have values for all the columns including 8th column and certain records have 8th column as NULL.My requisite is,without...

3. Shell Programming and Scripting

csv 4 columns values comparison!

Hi all, i have a csv file which as the following data: 294;F03;2000;40441 294;F03;2000;40443 284;F01;5400;44051 284;F01;5700;45666 the file holds 11689 lines. I was trying to get a script running to output results from this file that for each line with the condition: if a line is found...

4. Shell Programming and Scripting

Check for null values in columns

Hi , I have below data with fixed with of 52 bytes having three columns value data. 01930 MA GLOUCESTER 02033 02025 COHASSET 01960 MA ...

5. Shell Programming and Scripting

Check null values column

hi, I had a small question.I had a file from which i need to extract data. I have written the below script to check if the file exists and if it exists extract requierd columns from the file. IFILE=/home/home01/Report_1.csv OFILE=/home/home01/name.csv.out1 if #Checks if file exists...

6. Shell Programming and Scripting

Script to check for null values in a column

Hi Guys, I am new to shell script.I need your help to write a shell script. I have a csv file which has 13 columns separated by , I have written below script to fetch required 5 columns. awk -F, '(NR==1){h3=$3;h4=$4;h8=$8;h9=$9;h13=$13;next}(NF>1) \ {print...

7. Shell Programming and Scripting

Match columns from two csv files and update field in one of the csv file

Hi, I have a file of csv data, which looks like this: file1: 1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628 2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312...

8. UNIX for Dummies Questions & Answers

Find Null values in Columns and fail execution by displaying error message

Hi All, I am new to shell scripting. I have a requirement as part of my job to find out null/empty values in column 2 and column 3 from a CSV file and exit the further execution of script by displaying a simple error message. I have developed a script to do this by reading various articles...

9. Shell Programming and Scripting

Replace null values in csv with zero

Hi, i have another issue: i have three files: FILE 1 ServiceEventHandler, Processed,Percentage 5285337,100% FILE 2 Wallet, Processed,Percentage 5285337,100%

10. Shell Programming and Scripting

Multiple columns replace with null values.

I am trying to replace the partcular columns(Col3,col5,col20,col44,col55,co56,col59,col60,col61,col62,col74,col75,col88,col90,col91,col93,col94,col95) with empty Input file Col1,col2,col3,col4,col5------,col100 1,2,3,4,5,---------,100 3,4,5,6,7,---------,300 Output : ...

LEARN ABOUT DEBIAN

saslfinger

saslfinger(1)						      General Commands Manual						     saslfinger(1)

NAME

       saslfinger - A utility to collect SMTP AUTH relevant configuration for Postfix

SYNOPSIS

       saslfinger [-chs]

DESCRIPTION

       saslfinger  is  a utility to collect SMTP AUTH relevant configuration for Postfix. Depending on how you run it, it will search for informa-
       tion on server-side or client-side SMTP AUTH configuration settings in Postfix and Cyrus SASL.

OPTIONS

       -c     If you run saslfinger with the option -c it will collect data required for client-side SMTP AUTH.  Client-side  SMTP  AUTH  is  when
	      Postfix smtp daemon uses SMTP AUTH to authenticate itself with a remote mail server that offers SMTP AUTH.

	      saslfinger will try to telnet to all hosts listed in smtp_sasl_password_maps, if it may read smtp_sasl_password_maps

	      The  telnet  test  verifies  your host is able to reach the remote servers and shows what AUTH mechanisms they offer - in some cases
	      this is required to debug client-side SMTP AUTH.

	      Important: By default smtp_sasl_password_maps must be read-only to root, since these maps contain the  usernames	and  passwords	to
	      authenticate.  If  you  run  saslfinger  as  root access will be no problem, but saslfinger will fail if you lack the permissions to
	      access smtp_sasl_password_maps.

	      If you want to run the telnet test, but don't want to run saslfinger as root change permissions of smtp_sasl_password_maps  so  that
	      the user running saslfinger may access smtp_sasl_password_maps while you debug.

	      *note: You don't need to worry about saslfinger doing anything with the username or password stored next to the remote hosts in your
	      smtp_sasl_password_maps; saslfinger completely ignores these informations!

       -h     If you run saslfinger with the option -h it will print a little help message that tells you about the options you can use.

       -s     If you run saslfinger with the option -s it will collect data required for server-side SMTP AUTH.  Server-side  SMTP  AUTH  is  when
	      Postfix smtpd daemon offers SMTP AUTH to mail clients.

FILES

       saslfinger - the script you need to run.

       saslfinger.1 - the man page you are currently reading.

AUTHOR

       Patrick Koetter, <patrick.koetter@state-of-mind.de>, http://www.state-of-mind.de

       You will find the newest version of saslfinger at http://postfix.state-of-mind.de/patrick.koetter/saslfinger/.

BUGS

       Please report bugs to <patrick.koetter@state-of-mind.de>

Manuals 							       User							     saslfinger(1)