Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: UNIX/PERL script to convert XML file to pipe delimited format
Top Forums Shell Programming and Scripting UNIX/PERL script to convert XML file to pipe delimited format Post 302959482 by karthi1305561 on Tuesday 3rd of November 2015 11:55:46 AM
Old 11-03-2015
Code:
#!/usr/bin/ksh
BIN_DIR=$HOME/scripts
DATA_DIR=$HOME/scripts/config/data
CONFIG_DIR=$HOME/scripts/config
FILE=$DATA_DIR/SAMPLE.xml
DATE=`date -u +%Y%m%d`
MAILUSERS="abcd@gmail.com"
cd $DATA_DIR
touch SAMPLE_Query_$DATE.log
sample_query -operator -outputfile $FILE >> SAMPLE_Query_$DATE.log
if [ $? -eq 0 ]; then
   echo "SAMPLE Operator Report Created Successfully at `date`" >> SAMPLE_Query_$DATE.log
else
   echo "Error in creating SAMPLE Operator FILE" | mail -s "report failed @ $(hostname) at `date`" $MAILUSERS >> SAMPLE_Query_$DATE.log
exit
fi
#find  $DATA_DIR/SAMPLE_Query*.log -mtime +2 -exec rm {} \; -print >> SAMPLE_Query_$DATE.log
perl $BIN_DIR/karthi.pl $FILE > $DATA_DIR/ZA1P.NDM.SAMPLE.INTERFACE.GRP(+1)

In the above script i'm passing the perl script command and using the symbol ">" to redirect the output.
Last edited by Don Cragun; 11-04-2015 at 03:57 AM.. Reason: Add CODE tags.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

convert a pipe delimited file to a':" delimited file

i have a file whose data is like this:: osr_pe_assign|-120|wg000d@att.com|4| osr_evt|-21|wg000d@att.com|4| pe_avail|-21|wg000d@att.com|4| osr_svt|-11|wg000d@att.com|4| pe_mop|-13|wg000d@att.com|4| instar_ready|-35|wg000d@att.com|4| nsdnet_ready|-90|wg000d@att.com|4|... (6 Replies)
Discussion started by: priyanka3006
6 Replies

2. Shell Programming and Scripting

how to convert this file into comma delimited format

Hi experts, I need urget help! I have the a text file with this format: Types of fruits Name of fruits 1,1 Farm_no,1 apple,1 pineapple,1 grapes,1 orange,1 banana,1 2,2--->this is the record seperator Farm_no,2 apple,1 pineapple,1 grapes,3 orange,2 banana,1 3,3--->this is the... (1 Reply)
Discussion started by: natalie23
1 Replies

3. UNIX for Advanced & Expert Users

Urgent! need help! how to convert this file into comma delimited format

Hi experts, I need urget help! I have the a text file with this format: Types of fruits Name of fruits 1,1 Farm_no,1 apple,1 pineapple,1 grapes,1 orange,1 banana,1 2,2--->this is the record seperator Farm_no,2 apple,1 pineapple,1 grapes,3 orange,2 banana,1 3,3--->this is the... (2 Replies)
Discussion started by: natalie23
2 Replies

4. UNIX for Dummies Questions & Answers

How to convert a text file into tab delimited format?

I have a text file that made using text editor in Ubuntu. However the text file is not being recognized as space or tab delimited, the formatting seems to be messed up. How can I convert the text file into tab delimited format? (3 Replies)
Discussion started by: evelibertine
3 Replies

5. Shell Programming and Scripting

Convert CSV file (with double quoted strings) to pipe delimited file

Hi, could some help me convert CSV file (with double quoted strings) to pipe delimited file: here you go with the same data: 1,Friends,"$3.99 per 1,000 listings",8158here " 1,000 listings " should be a single field. Thanks, Ram (8 Replies)
Discussion started by: Ram.Math
8 Replies

6. Shell Programming and Scripting

How to convert a space delimited file into a pipe delimited file using shellscript?

Hi All, I have space delimited file similar to the one as shown below.. I need to convert it as a pipe delimited, the values inside the pipe delimited file should be as highlighted... AA ATIU2345098809 009697 005374 BB ATIU2345097809 005445 006518 CC ATIU9685098809 003215 003571 DD... (7 Replies)
Discussion started by: nithins007
7 Replies

7. UNIX for Dummies Questions & Answers

Need to convert a pipe delimited text file to tab delimited

Hi, I have a rquirement in unix as below . I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column. ex: Input Text file: 1|A|apple 2|B|bottle excel file to be generated as output as... (9 Replies)
Discussion started by: raja kakitapall
9 Replies

8. UNIX for Advanced & Expert Users

Convert CSV file to nested XML file using UNIX/PERL?

we have a CSV which i need to convert to XML using Perl or Unix shell scripting. I was able to build this XML in oracle database. However, SQL/XML query is running for long time. Hence, I'm considering to write a Perl or shell script to generate this XML file. Basically need to build this XML... (3 Replies)
Discussion started by: laknar
3 Replies

9. Shell Programming and Scripting

Convert pipe demilited file to vertical tab delimited

Hi All, How can we convert pipe delimited ( or comma ) file to vertical tab (VT) delimited. Regards PK (4 Replies)
Discussion started by: prasson_ibm
4 Replies

10. Shell Programming and Scripting

Linux convert Comma delimited file to pipe

I have file in linux with comma delimited and string fields in double quotations ", I need to convert them to pipe delimiter please share your inputs. Example: Input: "2017-09-30","ACBD,TVF","01234",NULL,18,NULL,"686091802","BANK OF ABCD, LIMITED, THE",790456 Output: ... (4 Replies)
Discussion started by: shieksir
4 Replies

LEARN ABOUT DEBIAN

wiki-toolkit-revert-to-date

WIKI-TOOLKIT-REVERT-TO-DATE(1p) 			User Contributed Perl Documentation			   WIKI-TOOLKIT-REVERT-TO-DATE(1p)

NAME

       wiki-toolkit-revert-to-date - Revert the state of a Wiki::Toolkit instance to an earlier point in time.

SYNOPSIS

	 # Removes any changes made to a Wiki::Toolkit instance since a given date
	 #  (and optionally time), restoring it to the state at that point.

	 wiki-toolkit-revert-to-date --type postgres
		  --name mywiki 
		  --user wiki  
		  --pass wiki 
		  --host 'db.example.com' 
		  --port 1234 
		  --date 2007-01-05 
		  --time 11:23:21

DESCRIPTION

       Takes three mandatory arguments:

       type
	   The database type.  Should be one of 'postgres', 'mysql' and 'sqlite'.

       name
	   The database name.

       date
	   The date to revert the state back to, in the format YYYY-MM-DD

       five optional arguments:

       time
	   The time (on the specified date) to revert the state back to, in the format hh:mm:ss. If not specified, will use midnight.

       user
	   The user that connects to the database. It must have permission to create and drop tables in the database.

       pass
	   The user's database password.

       host
	   The hostname of the machine the database server is running on (omit for local databases).

       port
	   The port number that the database server is expecting connections to.

AUTHOR

       Nick Burch

COPYRIGHT

	    Copyright (C) 2006 Nick Burch.  All Rights Reserved.

       This code is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

       Wiki::Toolkit

perl v5.14.2							    2011-09-25					   WIKI-TOOLKIT-REVERT-TO-DATE(1p)
All times are GMT -4. The time now is 07:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy