Problem with the flat file Post: 52315

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with a flat file!!!

Hi All, I get a flat file everyday with some records being invalid.Some records come with less number '|'.I just want to add the missing '|'s ,So the it doesnt give an error insufficient fields while loading...There area total of 32 pipes in each record. Input: ASADASD |Y|B|SDFGDSDFD| ...

2. Shell Programming and Scripting

Help with a Flat File!!!

Hi All, I need a help with a shelll script program.I get a '|' separated file which sometime has a encrypted column.And this encryption sometime breaks the last column data into a new line and this is not picked by the ETL.So when i run a script,it should append back the broken new line data...

3. Solaris

problem with flat file

Hi, I have two flat files which is generated by some automated process. When I tried to view both files in vi editor using vi command both looks same. But I typed =>cat TEST_WESM900033 &&HDR|M9SLRBR|0003|020012|012408|M9 &&TLR|0wes /usr5/datafiles/batch/M9 =>cat TEST_WESM90004...

4. Shell Programming and Scripting

Flat file

Hi I have a flat file looking this QWER 2:35 7044 00001 ROUT 1188 EA SS ASD 2:36 7044 00010 ROUT BSD 2:37 7044 00011 ROUT END QWER 3:35 7044 00011 ROUT 1088 EA SS ASD 3:36 7044 00010 ROUT BSD 3:37 7044 00011 ROUT...

5. Shell Programming and Scripting

Flat File in HP-UX

Hi I have a file like below . IF the record starts with ASD then change the 20th offset to "K" follwed by that 20th offset value & if the record starts with ASDR then change the 38th offset to "K" followed by 38th offset value . But here the condition is the next value ...

6. Shell Programming and Scripting

Awk to convert a flat file to CSV file

Hi , I have a file with contents as below: Contract Cancellation Report UARCNCL LOS CODE DATE REAS TYPE AMOUNT AMOUNT LETTER BY ========= ======= ==== ==== ==== ========= ==== ==== 8174739 7641509 1S NONE CRCD 30-JUN-2008 NPAR N .00 .00 CCAN 8678696 8091709 1S NONE DDEB 30-JUN-2008...

7. Programming

compare XML/flat file with UNIX file system structure

Before i start doing something, I wanted to know whether the approach to compare XML file with UNIX file system structure. I have a pre-configured file(contains a list of paths to executables) and i need to check against the UNIX directory structure. what are the various approches should i use ? I...

8. Shell Programming and Scripting

Searching for Log / Bad file and Reading and writing to a flat file

Need to develop a unix shell script for the below requirement and I need your assistance: 1) search for file.log and file.bad file in a directory and read them 2) pull out "Load_Start_Time", "Data_File_Name", "Error_Type" from log file 4) concatinate each row from bad file as...

9. Shell Programming and Scripting

reading a csv file and creating a flat file

hi i have written a script for reading a csv file and creating a flat file, suggest if this script can be optimized #---------------- FILENAME="$1" SCRIPT=$(basename $0) #-----------------------------------------// function usage { echo "\nUSAGE: $THIS_SCRIPT file_to_process\n"...

10. UNIX for Beginners Questions & Answers

Flat File Validation

Hi Team there is a requirement to do validate on Flat files using Shell Scripting. Suppose we have two flat files ( F1, F2). Validation 1. Row count between F1 and F2 a) Write it in a file with results of count of each file and differences if any 2. Apply checksum or any...

LEARN ABOUT DEBIAN

bp_bioflat_index

BP_BIOFLAT_INDEX(1p)					User Contributed Perl Documentation				      BP_BIOFLAT_INDEX(1p)

NAME

       bioflat_index.pl - index sequence files using Bio::DB::Flat

DESCRIPTION

	Create or update a biological sequence database indexed with the
	Bio::DB::Flat indexing scheme.	The arguments are a list of flat files
	containing the sequence information to be indexed.

USAGE

	bioflat_index.pl <options> file1 file2 file3...

	Options:

	    --create		  Create or reinitialize the index.  If not specified,
				  the index must already exist.

	    --format   <format>   The format of the sequence files.  Must be one
				  of "genbank", "swissprot", "embl" or "fasta".

	    --location <path>	  Path to the directory in which the index files
				  are stored.

	    --dbname <name>	  The symbolic name of the database to be created.

	    --indextype <type>	  Type of index to create.  Either "bdb" or "flat".
				  "binarysearch" is the same as "flat".

       Options can be abbreviated.  For example, use -i for --indextype.

       The following environment variables will be used as defaults if the corresponding options are not provided:

	    OBDA_FORMAT      format of sequence file
	    OBDA_LOCATION    path to directory in which index files are stored
	    OBDA_DBNAME      name of database
	    OBDA_INDEX	     type of index to create

perl v5.14.2							    2012-03-02						      BP_BIOFLAT_INDEX(1p)