I have a csv file which has no header. the file has 15 fields and needs to go out with a header of 8 fields.
The header content needs to have some variables and some fixed that i have set up:
variable header fields
OUTFILE_YEAR=`date '+%y'`
DATE=`date '+%d%m%y'`
TIME=`date '+%H:%M:%S'`... (6 Replies)
Hi,
I create a csv file and the output looks like below
Arun,E001
Sathish,E003
Now i need to include the below header and the output should like below
Name,Number
Arun,E001
Sathish,E003
Please guide me.
Thanks (4 Replies)
I have about 20 CSV's that all look like this:
"","","","","","","","","","","","","","","",""What I've been told I need to produce is the exact same thing, but with each file now containing the start_code from every other file where the email matches.
It doesn't matter if any of the other... (1 Reply)
Hi,
I am trying to add a header record to all the .csv files in a directory.
I am using the below sed commnad
sed -i '1 i \abc,sam,xyz,tip,pep,rip' xyz.csv
but this is not adding the header and I am not getting any error,pls tell me if any thing is wrong in the code.
Thanks,
Shruthi (2 Replies)
Friends,
I need help with the following in UNIX.
Merge all csv files in one folder considering only 1 header row and ignoring header of all other files.
FYI - All files are in same format and contains same headers.
Thank you (4 Replies)
Dear List,
I have a file of csv data which has a different line per compliance check per host. I do not want any omissions from this csv data file which looks like this:
date,hostname,status,color,check
02-03-2012,COMP1,FAIL,Yellow,auth_pass_change... (3 Replies)
Hi All,
Could anyoone please let me know how do I get sqlplus column header once in csv file
Scripts are below:
cat concreq.sh
#!/bin/bash
. $HOME/.profile
while ; do
sqlplus apps/pwd <<-EOF
set lines 100 pages 100
col "USER_CONCURRENT_QUEUE_NAME" format a40;
--set termout off... (5 Replies)
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Hi Folks,
I have a requirement to develop a shell script. PFB my requirement,
Requirement:
I need to check an empty line after the end of each header in respective file and if a empty line is present simply echo file OK and if empty line is not present echo "Adding empty line" and add an... (6 Replies)
Discussion started by: tpk
6 Replies
LEARN ABOUT PHP
intlcalendar.setfirstdayofweek
INTLCALENDAR.SETFIRSTDAYOFWEEK(3) 1 INTLCALENDAR.SETFIRSTDAYOFWEEK(3)IntlCalendar::setFirstDayOfWeek - Set the day on which the week is deemed to start
Object oriented style
SYNOPSIS
public bool IntlCalendar::setFirstDayOfWeek (int $dayOfWeek)
DESCRIPTION
Procedural style
bool intlcal_set_first_day_of_week (IntlCalendar $cal, int $dayOfWeek)
Defines the day of week deemed to start the week. This affects the behavior of fields that depend on the concept of week start and end
such as IntlCalendar::FIELD_WEEK_OF_YEAR and IntlCalendar::FIELD_YEAR_WOY.
PARAMETERS
o $cal
- The IntlCalendar resource.
o $dayOfWeek
- One of the constants IntlCalendar::DOW_SUNDAY, IntlCalendar::DOW_MONDAY, , IntlCalendar::DOW_SATURDAY.
RETURN VALUES
Returns TRUE on success. Failure can only happen due to invalid parameters.
EXAMPLES
Example #1
IntlCalendar.setFirstDayOfWeek(3)
<?php
ini_set('date.timezone', 'Europe/Lisbon');
ini_set('intl.default_locale', 'es_ES');
$cal = IntlCalendar::createInstance();
$cal->set(2013, 5 /* June */, 30); // A Sunday
var_dump($cal->getFirstDayOfWeek()); // 2 (Monday)
echo IntlDateFormatter::formatObject($cal, <<<EOD
week of month : 'W'
week of year : 'ww
EOD
), "
";
$cal->setFirstDayOfWeek(IntlCalendar::DOW_SUNDAY);
echo IntlDateFormatter::formatObject($cal, <<<EOD
week of month : 'W'
week of year : 'ww
EOD
), "
";
The above example will output:
int(2)
local day of week: 7
week of month : 4
week of year : 26
local day of week: 1
week of month : 5
week of year : 27
PHP Documentation Group INTLCALENDAR.SETFIRSTDAYOFWEEK(3)