Hi forum members. It has been several years since my last post. Currently I am using fairly large datasets on a day to day basis for handling immigration cases at a law firm. Our Input file is filled out by our secretary staff. The first column is the case ID-sample ID then the second column is the sample ID, third is the relationship status and the fourth is the name.
What I need is a output file where the father (or mother) is compared to the child (daughter or son) so that the output file would be in rows with a specific syntax (please see the output file).
The file is tab seperated
Father and mother would be compared to all children (child, son and daughter)
If it is a son then a M would be used (e.g. ...[Jim Smith][M])
If it is a daughter then a F would be used (e.g.....[Jane Smith][F])
If the name is a child in the third column then it would be left blank (e.g..... [Randy Davis][])
Sometimes the list can have more than one child (e.g. up to 8 children) so then the father would have to be compared to all children in the output format.
Input file
Output file
Above is the output file. It would be best if the script is in perl however any code would help.
THanks
Last edited by kylle345; 09-20-2015 at 10:02 AM..
Reason: forgot to add more detail
Hi,
I have written a perl script to dispaly some statements from a file but i want the output statements to be dispalyed in an HTML format.Is it possible for me to do in perl scripting?
Please help me with ur thoughts.
Thanks In Advance
Meva. (1 Reply)
Hi everyone, is there any way in perl using which we can print the selective words in bold when we write the output to a csv file?
Please find the example below
1. Filename: A
2. name age 12
3. city add 23
Line1 should only be bold. Outputs from other files being read in the... (2 Replies)
Hi,
I am having couple of files which i used to copy from windows to Linux, so now in case of text files (CTRL^M) appears at end of line. I know i can convert this windows format file to unix format file by running dos2unix.
My requirement here is that i want to do it automatically using a... (5 Replies)
Hi,
i need a perl script which reads the file, content is given below. and output in new file.
TARGET DRIVE IO1 IO2 IO3 IO4 IO5
------------ --------- --------- --------- --------- ---------
0a.1.8 266 236 ... (3 Replies)
Input_file_1:
ABC1 DEF11
ABC3 DEF7
ABC7 DEF36
Input_file_2:
DEF7 light 23
DEF11 over 2
DEF11 over 1
DEF17 blue 0
Perl one-liner that join two input file based on columns sharing a value (In this example, column 2 in Input_file_1 and column 1 in... (3 Replies)
Hello,
I need help with a perl script that will process a text file and match virtual server name to profile(s). the rest will be ignored.
Virtual server name follows the word "virtual" in the begging of the line.
There could be multiple profiles assigned to one virtual server.
For example, ... (3 Replies)
Hi Folks,
I have few mailids in a text file and need to check whether the mailid is in correct format or not.
If just to check whether the string is a mailid or not there is a perl module Email::Valid to do the business or we can implement our own logic.
But the mail_ids I am having is... (4 Replies)
Hi,
I have a file with data in the following format
BOX
-1.000000 -1.000000 0.000000
30.00000 14.00000 0.1000000
0.000000 0.000000 0.000000
0.000000
0.000000
CYLINDER
3.595000 2.995000 0.000000
0.5100000 2.000000
Z
0.000000 0.000000
0.000000
I want to convert these files... (1 Reply)
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Hello, I need to get few values from a XML file and output needs to be written in another file with pipe delimited format. The Header & Footer of the Pipe Delimited file will be constant.
The below is my sample XML file. I need to pull the values in between the XML tags <Operator_info to... (15 Replies)
Discussion started by: karthi1305561
15 Replies
LEARN ABOUT LINUX
motd.tail
MOTD.TAIL(5) Debian Administrator's Manual MOTD.TAIL(5)NAME
motd.tail - Template for building the system message of the day
DESCRIPTION
On Debian systems, the system message of the day is rebuilt at each startup, in order to display an accurate information. /etc/motd.tail is
the file to edit permanent changes to the message of the day.
OVERVIEW
The initiation script /etc/init.d/bootmisc.sh prepends a line containing information about the system to /etc/motd.tail and stores the
resulting file in /var/run/motd. /etc/motd is a symbolic link to /var/run/motd. This is done to prevent changes to /etc as the system can
not assume /etc to be writable.
Changes to /etc/motd effectively end up in a file under /var/run which will be regenerated upon reboot.
A symbolic link to a different file, such as /etc/motd.static disables this behaviour.
FILES
/etc/init.d/bootmisc.sh
The initiation script which builds /var/run/motd
/etc/motd
Symbolic link to the system message of the day at /var/run/motd
/etc/motd.tail
Template for building the system message of the day
/var/run/motd
System message of the day file rebuilt at each computer start
SEE ALSO login(1), issue(5), motd(5).
Debian 2007-04-28 MOTD.TAIL(5)