|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Converting csv file to flat file
Post 303023608 by rohit_shinez on Wednesday 19th of September 2018 11:47:21 PM
09-20-2018
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a file in this format.
P1 P2 P3.........................
A001 v11 v21 v31......................
A002 v12 v22 v32............................
A003 v13 v23 v33..........................
A004 v14 v24 v34..............................
.
.
.
A00n... (2 Replies)
Discussion started by: vskr72
2 Replies
2. Shell Programming and Scripting
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... (14 Replies)
Discussion started by: rkumudha
14 Replies
3. Shell Programming and Scripting
Hi,
Request To guide me in writing a shell program for the following requirement:
Example:if the Input File contains the follwing data
Input File Data:
80723240029,12,323,443,88,98,7,98,67,87
80723240030,12,56,6,,,3,12,56,6,7,2,3,12,56,6,7,2,3,88,98,7,98,67,87... (5 Replies)
Discussion started by: srinikal
5 Replies
4. UNIX for Advanced & Expert Users
I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner.
I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
2 Replies
5. UNIX for Advanced & Expert Users
Hi All,
I wrote a script to extract data from Oracle DB and place it in a text file , and I have coverted .txt file into comma seperated .csv file and I sent it to my mail box .
I can get .xls file in my inbox.I am getting all data in same column and in different rows , without column... (1 Reply)
Discussion started by: krthkmuthu
1 Replies
6. UNIX for Dummies Questions & Answers
Open to a sed/awk/or perl alternative so that i can stick command into my bash script.
This is a problem I resolve using a combination of cut commands - but that is getting convoluted. So would really appreciate it if someone could provide a better solution which basically replaces all... (3 Replies)
Discussion started by: svn
3 Replies
7. Shell Programming and Scripting
Hello Friends,
I am new to UNIX shell scripting. Using bash....Could you please help me in converting a flat file into an XML style output file.
Flat file: (Input File entries looks like this)
John Miller: 617-569-7996:15 Bunting lane, staten Island, NY: 10/21/79: 60600
The... (4 Replies)
Discussion started by: humkhn
4 Replies
8. UNIX for Advanced & Expert Users
Hi All,
I am new to this forum, could any one help me out in resolving the below issue.
Input of the flat file contains several lines of text for example find below:
5022090,2,4,7154,88,,,,,4/1/2011 0:00,Z,L,2
5022090,3,1,6648,88,,,,,4/1/2011 0:00,Z,,1... (0 Replies)
Discussion started by: av_sagar
0 Replies
9. Shell Programming and Scripting
Hi Friends,
I want to convert a XML file to flat file.
Sample I/p:
<?xml version='1.0' encoding='UTF-8' ?>
<DataFile xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' contactCount='4999' date='2012-04-14' time='22:00:14' xsi:noNamespaceSchemaLocation='gen
.xsd'>
<Contact... (3 Replies)
Discussion started by: karumudi7
3 Replies
10. Shell Programming and Scripting
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"... (3 Replies)
Discussion started by: mprakasheee
3 Replies
LEARN ABOUT PHP
datetimezone
DATETIMEZONE(3) 1 DATETIMEZONE(3) The DateTimeZone class INTRODUCTION
Representation of time zone. CLASS SYNOPSIS
DateTimeZone DateTimeZone Constants o const integer$DateTimeZone::AFRICA1 o const integer$DateTimeZone::AMERICA2 o const integer$DateTimeZone::ANTARCTICA4 o const integer$DateTimeZone::ARCTIC8 o const integer$DateTimeZone::ASIA16 o const integer$DateTimeZone::ATLANTIC32 o const integer$DateTimeZone::AUSTRALIA64 o const integer$DateTimeZone::EUROPE128 o const integer$DateTimeZone::INDIAN256 o const integer$DateTimeZone::PACIFIC512 o const integer$DateTimeZone::UTC1024 o const integer$DateTimeZone::ALL2047 o const integer$DateTimeZone::ALL_WITH_BC4095 o const integer$DateTimeZone::PER_COUNTRY4096 Methods o public DateTimeZone::__construct (string $timezone) o public array DateTimeZone::getLocation (void ) o public string DateTimeZone::getName (void ) o public int DateTimeZone::getOffset (DateTime $datetime) o public array DateTimeZone::getTransitions ([int $timestamp_begin], [int $timestamp_end]) o publicstatic array DateTimeZone::listAbbreviations (void ) o publicstatic array DateTimeZone::listIdentifiers NULL ([int $what = DateTimeZone::ALL], [string $country]) PREDEFINED CONSTANTS
o DateTimeZone::AFRICA -Africa time zones. o DateTimeZone::AMERICA -America time zones. o DateTimeZone::ANTARCTICA -Antarctica time zones. o DateTimeZone::ARCTIC -Arctic time zones. o DateTimeZone::ASIA -Asia time zones. o DateTimeZone::ATLANTIC -Atlantic time zones. o DateTimeZone::AUSTRALIA -Australia time zones. o DateTimeZone::EUROPE -Europe time zones. o DateTimeZone::INDIAN -Indian time zones. o DateTimeZone::PACIFIC -Pacific time zones. o DateTimeZone::UTC -UTC time zones. o DateTimeZone::ALL -All time zones. o DateTimeZone::ALL_WITH_BC -All time zones including backwards compatible. o DateTimeZone::PER_COUNTRY -Time zones per country. PHP Documentation Group DATETIMEZONE(3)