I am calling SQL script in my UNIX Shell script and trying to create the CSV file and my last column value of each row is 23 blank spaces.
In my SQL script,the last column is like below.
RPAD(' ',23,' ') -- Padding 23 blank Spaces
The CSV file is generated but the sapce(23 spaces) is... (2 Replies)
hi,
I have a doubt in replacing characters with blank.
My requirement is that, i have one file and looks like below
4:ALTER SYSTEM DISCONNECT SESSION '193,191' IMMEDIATE;
6:ALTER SYSTEM DISCONNECT SESSION '205,7274' IMMEDIATE;
5:ALTER SYSTEM DISCONNECT SESSION '206,34158' IMMEDIATE;... (4 Replies)
Hi everyone,
I was wondering how could from a file where each row is separated by tabulations, the row values where are in blank replace them by a string or value.
My file has this form:
26/01/09 13:45:00 0 0
26/01/09 14:00:00 1495.601318 0
26/01/09 14:15:00 1495.601318 0 ... (4 Replies)
Hi,
I need help to remove blank rows at the end of file.
Sample data:
"Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91
"Tønsberg, Brygga Kino SF",Tønsberg,202-1,Tønsberg SF 4,202-1-4
,,,,
,,,,
,,,,
,,,,
Expected data:
"Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91
"Tønsberg, Brygga... (6 Replies)
Hi experts,
My csv file looks like this
U;cake;michael;temp;;;;
U;bread;john;temp;;;;
U;cocktails;sarah;temp;;;;
I'd like to change the value fo 2nd column to cf+random number , which will look maybe something like this
U;cf20187;michael;temp;;;;
U;cf8926;john;temp;;;;... (7 Replies)
Hello,
I have some data in a text file where fields are separated by blank lines. There are only 6 fields however some fields have several lines of data as I will explain. Also data in a particular field is not consistently the same size but does end on a blank line. The first field start with... (6 Replies)
Hi All,
I have many of files(.csv) of the format given below.
Date,Name,Location
04/02/2012,A,India
,B,China
,C,USA
Like this I have 1000's of rows and many columns in all my files.
I need a shell script to copy down the Date(in this example column1) to the next 2 rows below(in the... (8 Replies)
Hi,
i have a csv file which have headers and values of it like below :
headers --> CI Ref SerialNumber LastScanDate
values --> VMware-42,VMware-42,Tue, 20 May 2014 11:03:44 +0000
i want to have a above csv in below format :
headers --> CI Name CI Description CI Ref... (6 Replies)
Hi guys,
New to the forum, and been messing around with Linux for about a year now. I'm still very much a rookie, so just assume that I'm a total idiot:
I currently have a shell that spits out a CSV number string of about 8 numbers as follows:
1.00,2.00,3.00 ... ,8.00I need to assign a... (7 Replies)
I'm monitoring a WLAN network to keep track of new SSIDs popping up. The SSIDs are stored along with the AP MAC address and a few other parameters in a CSV file. A typical line could look like this:
18:70:9f:e3:80:aa 10:11:15 MyNetwork 2437
Now, the problem is that some networks use SSIDs... (4 Replies)
Discussion started by: Zooma
4 Replies
LEARN ABOUT CENTOS
vte
vte(1) User Commands vte(1)NAME
vte - virtual terminal emulator
SYNOPSIS
vte [-2] [-A] [-a] [-B image] [-b] [-C] [-c command] [-D] [-d] [-f font] [-g] [-h] [-i] [-k] [-n] [-r] [-S] [-s] [-T] [-t terminal-type]
DESCRIPTION
vte is simply a window wrapped around the vte embeddable terminal emulation control, which does most of the work for gnome-terminal. vte is
used mainly to test the control. Most users do not need to use vte directly, but use gnome-terminal instead.
OPTIONS
The following options are supported:
-2 Toggle double buffering. Enabled by default.
-A Toggle antialiasing. The default is that of the current GTK+ default.
-a Toggle audible bell on/off. If audible bell is enabled, visible bell is disabled. If audible bell is disabled, visible bell
is enabled. Audible bell enabled by default.
-B image Use image as background.
-b Toggle cursor blinking. Enabled by default.
-C Open a "console" connection.
-c command Fork the specified command.
-D Use dingus clicking: as the cursor moves over text matching a certain pattern, the matched text is highlighted and the cur-
sor changes shape. Disabled by default.
-d Toggle update debugging. Disabled by default.
-f font Specify the font to use. Default font is "Sans 12".
-g Toggle whether to set geometry hints if font is changed. Enabled by default.
-h Toggle highlighting. Disabled by default.
-i Toggle whether to obey attempts to set the icon name, if applications running in the terminal request this.
-k Toggle whether to keep program running after GTK main loop. Disabled by default.
-n Specify the number of scrollback lines. Minumum number of scrollback lines is 100. Default number of scrollback lines is
100.
-r Toggle whether to set cursor color to pale red. Disabled by default.
-S Toggle launching a shell. Enabled by default.
-s Toggle whether to scroll background image along with text. This option is only useful when combined with the -B option.
Disabled by default.
-T Use transparent background. Overrides the -B option.
-t terminal-typeSpecify the terminal type to emulate.
EXTENDED DESCRIPTION
vte is designed to emulate the xterm program provided by the X Consortium. In turn, xterm is an almost complete emulation of the DEC VT102
terminal. vte supports the same extensions to VT102 as those provided by xterm, through special escape sequences.
xterm is an evolving program. Recent changes to xterm have been been incorporated into vte. This includes emulation of the newer DEC VT220
escape sequences.
EXAMPLES
Example 1: Launching the Virtual Terminal Emulator
example% vte
ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables:
VTE_PROFILE_MEMORY Virtualize memory allocation for debugging purposes.
EXIT STATUS
The following exit values are returned:
0 Application exited successfully
>0 Application exited with failure
FILES
The following files are used by this application:
/usr/bin/vte Executable for virtual terminal emulator
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWvte |
+-----------------------------+-----------------------------+
|Interface stability |External |
+-----------------------------+-----------------------------+
SEE ALSO gnome-terminal(1), xterm(1), libvte(3)NOTES
Written by Johan Steyn, Sun Microsystems Inc., 2004.
SunOS 5.10 6 Sep 2004 vte(1)
01-16-2017
[bash] - Replace blank and string in csv file
i was not familiar with bash... so i hope in your help.