Search results for query: *

Thanks LKBrwnDBA. It was me and how I was outputing the files. The script works fine. ( "To become Wise, first you must ask Questions")

Hi LKBrwnDBA. Noticed the slight change in your code. I have now implemented this but I still get the original line that was duplicated in the original file. For example: Part of what's in the duplicated file after running the code: 10012;119;KIRKCALDY 119;2005-03-13...

Okay. I have tried all three examples presented to me. These examples work, BUT what I am after is that say I have 2 lines with the 18 field showing the following: 10020;128;DERBY EAST ST 128;2005-03-13 09:21:09;Ms.;Sara;Sandringham;45;The Hollow;Cheapside;;GTX 1BB;;;;;;357888888888888;NOK...

Thanks guys. Will give your recommendations a go. ( "To become Wise, first you must ask Questions")

To re-cap yes I need to remove any line that is duplicated and have this transferred to another file. For example: These 3 lines are the same: 1BB;;;;;;357888888888888;NOK 8310 GSM C HOT;P;cond-des;VODAFONE;5;;;;;;;;flt dsc;0;chrge cond;1003052S;12345;2005-03-14 13:14:15; 10020;128;DERBY...

Need all of the duplicate lines stripping out. This will then be used as a pointer to the people who have ftp'ed the file, so they can then make a decision to which line should have been included in the first place. Thanks. ( "To become Wise, first you must ask Questions")

Hi All, I have done a search on this subject and found many a question and answer. But this one is a slightly different issue. I need to check the 18th field (';' is the seperator) and remove any lines that have duplication in the 18th field and move these to another file. Here is some...

Thanks PHV. Will give it a go. ( "To become Wise, first you must ask Questions")

Hi All, Little bit new to 4gl, although have done a few ISQL (Informix 7 SE SQL on AIX platform), scripts etc... Currently I have a project where a file is presented to me in a comma seperated value format. From this I have managed to write an AIX Korn Shell Script to check for errors...

Thanks for your input ericbrunson. But will your scripts/programs remove the offending lines that have blank fields from the original file? and place them into another one? ( "To become Wise, first you must ask Questions")

Okay. I'll try the python. Thanks for your contribution ericbrunson. ( "To become Wise, first you must ask Questions")

Ah forgot to mention. I am Using AIX 4.3.3 ML9. Not sure if I have python installed. I do have perl. ( "To become Wise, first you must ask Questions")

Hi all, Currently I have been given the task to error check a file generated via an Informix Database. Basically if fields 6 to 11 (Seprated by ';') are blank then I need to strip these lines to a file. But leave any un-erronous lines in the original file. Here is some example data: 1)...

Chacalinc. Damn, I eally must look more carefully. Yep Sorry PHV that now works with the correct field postion (7). I first will check if PHV's donation script will do the job for the other lines. If not I will post some example data. Thanks guys. ( "To become Wise, first you must...

Hi PHV. Tried your code. This is what the output ended as: 07963213829;2616007;04;MPRC - WIP ;2004-01-15 17:01 2004-01-15 17:01 2004-01-15 17:01;Y;A/P SE0086 FLEXI CONN ; ; ; 2;351884002137232 ...

Okay. I have now managed to create 1 output file from an Informix database. Here is some example data: 07963213829;2616007;04;MPRC - WIP ;2004-01-15 17:01;Y;A/P SE0086 FLEXI CONN ; ; ; 2;351884002137232 ; ;;1...

Hi all, This may be an easy thing I am missing. But is there a way I can extract lines of text out of 8 files and combine them into just 1 file. I have tried looking at using 'sed' for this but not sure how to do it. Currently using AIX 4.3.3 ML9. Thanks. ( "To become Wise, first...

Thanks for the replies people. I am learning new things everyday. ( "To become Wise, first you must ask Questions")

Thanks yet again PHV. Your genius. ( "To become Wise, first you must ask Questions")

Hi again, From the code PHV has kindly donated: ##-- Check if amount of ; is correct, if not e-mail --## awk -F';' 'NF!=37{print NR,$0}' /dump_area/p4uin/p4uin.csv > /tmp/p4uerr.err [ -s /tmp/p4uerr.err ] && { /usr/local/bin/mpack -s "P4u File cannot be loaded due to field length for...