Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Validating a file in ksh

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Validating a file in ksh
# 1  
Old 05-21-2015
Validating a file in ksh
Ladies and Gents,

I need to be able to verify the file and validate the file format. Is there a way to verify this using ksh? Please forgive me, I'm very new to UNIX scripting.

Code:
12345_dbname_1_sqlname.sql

12345   - change number
dbname  - database name
1       - sequence
sqlname - sql script name to be executed.

Regards,
Philani
Last edited by rbatte1; 05-22-2015 at 08:33 AM.. Reason: Wrapped required format in CODE tags to display neater
# 2  
Old 05-21-2015
Wrench
Hello Philani,

There are few questions here:
  1. Is there only one file we need to verify?
  2. Do you want to check a fixed values like change number, dbname etc always or it may differ too?
  3. How frequently we need to verify the file/files ?
  4. What are the os details?

Kindly use code tags for commands/codes/inputs as per forum rules to your reply and every post, please get back to us with same answers so that we can help you more in same.


Thanks,
R. Singh
Last edited by rbatte1; 05-22-2015 at 08:34 AM.. Reason: Set LIST=1 tags instead of text listing
# 3  
Old 05-21-2015
Hello Ravinder,

Thanks for the reply, let me clarify my question.

I have a folder with multiple files, all these files must be in this format (i.e 12345_dbname_1_sqlname.sql).
  • The first text before the underscore must always be a 5 digit number
  • The second one must always be a string (i.e database1, database2 etc)
  • The third one must be also a number (i.e 1, 2, 3, 4,5 etc)
  • The fourth one must be a any text.sql.
The file names will be checked on adhoc basis. This will be running on solaris 10.

Regards,
Philani
Last edited by rbatte1; 05-22-2015 at 08:35 AM.. Reason: Set into a list to make it clearer
# 4  
Old 05-21-2015
Try
Code:
 A=12345_dbname_1_sqlname.sql
[[ "$A" =~ [[:digit:]]{5}_[[:alnum:]]*_[[:digit:]]*_[[:alnum:]]*.sql ]] && echo good || echo bad
good

This User Gave Thanks to RudiC For This Post:
rbatte1
# 5  
Old 05-22-2015
Hi RudiC,

Thanks for the response. I will try and let you know the results.

Regards,
Philani
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. 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: ... (43 Replies)
Discussion started by: shree11
43 Replies

2. 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... (3 Replies)
Discussion started by: shree11
3 Replies

3. 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... (3 Replies)
Discussion started by: karumudi7
3 Replies

4. 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... (10 Replies)
Discussion started by: shellhelp
10 Replies

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... (2 Replies)
Discussion started by: dgeehot
2 Replies

6. 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 Replies)
Discussion started by: asemota
5 Replies

7. 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... (8 Replies)
Discussion started by: trichyselva
8 Replies

8. 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 Replies)
Discussion started by: new2Linux
3 Replies

9. 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... (1 Reply)
Discussion started by: sendhilmani123
1 Replies
Login or Register to Ask a Question