12-14-2011
Need help with formatting file in UNIX
hi, please help me with the below
1)i have a file like below with data
389096
389097
389098
..and i need some thing like below
'389096','ZZ1111'
'389097','ZZ1111'
'389098','ZZ1111'
2)i have a file like below with data
8300003225
8300003223
8300006494
..and i need the first digit replaced with letter z like
z300003225
z300003223
z300006494
thanks
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i have a txt file in which it contains some lines each line contains some 350-400 characters
but when i read the file line by line in ksh it is telling the max characters in each line is between 100-127 characters
in each line it contains some values with some spaces in between
when i try to... (2 Replies)
Discussion started by: trichyselva
2 Replies
2. Shell Programming and Scripting
#! /bin/ksh
############################
# AFI Monitor Script
############################
. /db2/uszlad48/sqllib/db2profile
export mondir=/home/script/krishna
export monlog=$mondir/Error_Report_`date +%Y%m%d`.log
echo "connect to database r2pdev" >>$monlog
db2 connect to r2pdev user... (1 Reply)
Discussion started by: regnumber
1 Replies
3. Shell Programming and Scripting
Hi,
I am using the following format command for formatting my text file in unix.
awk -F":" '{ printf "%-50s%-1s%-50s\n", $1,":", $2}' filename > targetfile
The target file is then sent as an attachment via email.
When I view the target file in notepad multiple lines get spanned as a... (2 Replies)
Discussion started by: AAA
2 Replies
4. Shell Programming and Scripting
Hi ,
I have a text file noname.txt containing 1000+ records like this. One of the record I have given below.
Input will b e like this
BOT:
2010/06/01 00:25:59
21 = "private"
Access-Method = 31
NCC = GBR
01 =... (5 Replies)
Discussion started by: smalya
5 Replies
5. Shell Programming and Scripting
while read l
do
vTimeCreated=`perl -e '@d=localtime ((stat(shift))); printf "%02d-%02d-%04d %02d:% 02d:%02d\n", $d,$d+1,$d+1900,$d,$d,$d' ${l}`
echo "${l} || ${vTimeCreated}" >> ${fPrefx}_Output_Files_${vDate}.txt
done < servername.txt Using the above code to format date time for each of the... (0 Replies)
Discussion started by: HeadBang
0 Replies
6. Shell Programming and Scripting
Hi,
Am using the following command to create a csv file
paste File_1.csv File_4.csv File_7.csv >Out1.csv
paste File_2.csv File_5.csv File_8.csv >>Out1.csv
paste File_3.csv File_4.csv File_9.csv >>Out1.csv
Input Data:
Expected Output:
Column 1 Column 2 ... (2 Replies)
Discussion started by: meva
2 Replies
7. Shell Programming and Scripting
hi folks
am running the shell script below
#!/bin/bash
sqlplus 'scott@orcl/tiger'<<ENDSQL >> outputlogfile.csv
SET PAGES 0
SET HEAD ON
SET ECHO OFF
SET FEEDBACK OFF
SET LINESIZE 100
SET PAGESIZE 100
SET SERVEROUTPUT ON
--# Fire the query on database
select *
from employee;
... (2 Replies)
Discussion started by: coolboy98699
2 Replies
8. Shell Programming and Scripting
Hi Techies,
i need in n UNIX to Windows file formatting.
i have created a csv file using a script and mailed it to my email, when i open the file with Excel sheet it looks like below
Collector_no|_|Collector_Name|_|SE_Count|_|Installed_Domains|_|CPU_Sys|_|CPU_Idle|_|Memory_Util... (9 Replies)
Discussion started by: mahi_mayu069
9 Replies
9. Shell Programming and Scripting
Hi
I have a shell variable storing DATE in YYYY-MM-DD format
is there a way i extract required field say only DD
Also, would be great if there is a way which could take date format as well so that code is generic for any date format eg DDMMYYYY or DD/MM/YYYY or YYYY/MM/DD etc.
Thanks (4 Replies)
Discussion started by: skyineyes
4 Replies
10. Shell Programming and Scripting
Hi All,
Here is an oracle command to list out the bug fix patches applied on Oracle Software.
(hostname)/home/oracle-> $ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed
The output of this command is as follows(Pasting only relevant section):
List of Bugs fixed by Installed Patches:
... (3 Replies)
Discussion started by: veeresh_15
3 Replies
LEARN ABOUT MOJAVE
pod::parselink5.18
Pod::ParseLink(3pm) Perl Programmers Reference Guide Pod::ParseLink(3pm)
NAME
Pod::ParseLink - Parse an L<> formatting code in POD text
SYNOPSIS
use Pod::ParseLink;
my ($text, $inferred, $name, $section, $type) = parselink ($link);
DESCRIPTION
This module only provides a single function, parselink(), which takes the text of an L<> formatting code and parses it. It returns the
anchor text for the link (if any was given), the anchor text possibly inferred from the name and section, the name or URL, the section if
any, and the type of link. The type will be one of "url", "pod", or "man", indicating a URL, a link to a POD page, or a link to a Unix
manual page.
Parsing is implemented per perlpodspec. For backward compatibility, links where there is no section and name contains spaces, or links
where the entirety of the link (except for the anchor text if given) is enclosed in double-quotes are interpreted as links to a section
(L</section>).
The inferred anchor text is implemented per perlpodspec:
L<name> => L<name|name>
L</section> => L<"section"|/section>
L<name/section> => L<"section" in name|name/section>
The name may contain embedded E<> and Z<> formatting codes, and the section, anchor text, and inferred anchor text may contain any
formatting codes. Any double quotes around the section are removed as part of the parsing, as is any leading or trailing whitespace.
If the text of the L<> escape is entirely enclosed in double quotes, it's interpreted as a link to a section for backward compatibility.
No attempt is made to resolve formatting codes. This must be done after calling parselink() (since E<> formatting codes can be used to
escape characters that would otherwise be significant to the parser and resolving them before parsing would result in an incorrect parse of
a formatting code like:
L<verticalE<verbar>barE<sol>slash>
which should be interpreted as a link to the "vertical|bar/slash" POD page and not as a link to the "slash" section of the "bar" POD page
with an anchor text of "vertical". Note that not only the anchor text will need to have formatting codes expanded, but so will the target
of the link (to deal with E<> and Z<> formatting codes), and special handling of the section may be necessary depending on whether the
translator wants to consider markup in sections to be significant when resolving links. See perlpodspec for more information.
SEE ALSO
Pod::Parser
The current version of this module is always available from its web site at <http://www.eyrie.org/~eagle/software/podlators/>.
AUTHOR
Russ Allbery <rra@stanford.edu>.
COPYRIGHT AND LICENSE
Copyright 2001, 2008, 2009 Russ Allbery <rra@stanford.edu>.
This program is free software; you may redistribute it and/or modify it under the same terms as Perl itself.
perl v5.18.2 2013-11-04 Pod::ParseLink(3pm)