Validating a file in ksh Post: 302944691

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Validating inputs from a file

Hi, I have a file called inputs. Now that file has the values like this: 1 2 3 Now In my script called 'get.sh' I do this : exec < inputs read a b c d Now I know that there will not be any value in d. How can I check it. I need the exact condition for checking whether the variable has...

2. Shell Programming and Scripting

validating a file or directory

Hi there, im writing a script and trying the get the 2nd parameter and check it if its valid file or valid directory, Example: ./test -a quiz1 i need to check quiz1 ($2) if it matches any name of a file or directory. Thanks

3. Shell Programming and Scripting

validating a file based on conditions

i have a file in unix in which the records are like this aaa 123 233 aaa 234 222 aaa 242 222 bbb 122 111 bbb 122 123 ccc 124 222 In the output i want only the below records aaa ccc The validation logic is 1st column and 2nd column need to be considered if both columns values are...

4. Shell Programming and Scripting

Shell script for validating fields in a file

Hi, I have not used Unix in a very long time and I am very rusty. I would appreciate any help I can get from the more experienced and experts in Shell script. I am reading one file at a time from a folder. The file is a flat file with no delimeters or carriage return. Col1 through col6 is...

5. UNIX for Dummies Questions & Answers

Validating a file

Pardon my ignorance but I am lost on how to do this I have a file called "Sample.txt", it is pipe delimited, it should have 13 fields. But some of the records do not, I would like to set up a shell script where I can pass in a parameter "Sample.txt" and it would split the file into records...

6. Shell Programming and Scripting

validating data in columns and writing them to new file

I have a file that contains records in the below format: 23857250998423948239482348239580923682396829682398094823049823948 23492780582305829852095820958293582093585823095892386293583203248 23482038509825098230958235234230502958205983958235820358205892095...

7. Shell Programming and Scripting

Validating the file

Hello All, I have the following file. The first column is Type. Always the file will have one H and one T type in between all D type reocrds. Need todo some validations. H|ABCD D|TAB N0003107809CD2013-11-14|RYAN|FRY|7 DR|RICHMOND HILL|GA|32431|X|C95|000009999|000000001|TAB||C0001 D|TAB...

8. Shell Programming and Scripting

Validating XML file using XSD in UNIX

Hi, I have a xml file and a xsd file(xml schema file). Here using unix script i wanted to validate the xml file by referring to xsd file. The validation is in terms of Datatype,Field length and null values. If the data present in the xml file is not matching in terms of datatype,field length...

9. Shell Programming and Scripting

Csv file parsing and validating

Hi, I have basic knowledge on unix shell scripting(not an expert). My requirement is reading the csv file using the schema defined in the configuration file and if the condition is not mached then move the unmatched record to a error file and matched good records into other file. In brief: ...

LEARN ABOUT DEBIAN

cvm-sql

cvm-sql(7)						 Miscellaneous Information Manual						cvm-sql(7)

NAME

       cvm-sql - CVM SQL Framework

QUERY SUBSTITUTION

       $VAR  and  ${VAR} are replaced with the quoted value of the environment variable named VAR.  Use the second form when VAR contains anything
       other than alpha-numeric or underscore (_) characters.  Do not include quotes in the query.  The variables account and domain  contain  the
       account and domain names given by the CVM client.  $$ is replaced with a single dollar sign.

QUERY RESULTS

       The query must produce the following fields exactly in order.  All required fields must not be null or empty.

       1.     Password, encrypted with crypt(3) (required)

       2.     Actual account name (required)

       3.     User ID (integer) (required)

       4.     Group ID (integer) (required)

       5.     Directory (required)

       6.     Real name (optional)

       7.     Login shell (optional)

       8.     Group name (optional)

       9.     Domain name (optional)

       10.    System account name (optional)

       11.    System account directory (optional)

       12.    Mailbox path (optional)

DEFAULT QUERY

       SELECT  password, username, userid, groupid, directory, realname, shell, groupname, domain, sys_username, sys_directory FROM accounts WHERE
       username=$account AND domain=$domain

SEE ALSO

       cvm-mysql(8), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8),  cvm-test-
       client(8)

	http://untroubled.org/cvm/cvm.html

																	cvm-sql(7)