I would like to copy 2 parts of a csv file from Unix to an XL sheet. However to save time I do not want to format the column ever time I cut and paste into XL(Text2Column). I've used awk -F, '{Print $1, $2....}'. Is there a script or code that can automatically format the csv for XL columns?
... (3 Replies)
I have a requirement in which i have to read a file which has multiple columns seperated by a pipe "|" from this i have to read each column values seperately and create a comma seperated row for the column and write to another file.
eg:
Input file:
ColA ColB
1 2
2 x
3 y... (5 Replies)
Hi,
I have a directory that contains say 100 files named sequencially like input_1.25_50_C1.txt
input_1.25_50_C2.txt
input_1.25_50_C3.txt
input_1.25_50_C4.txt
..
..
..
input_1.25_50_C100.txt
an example of the content in each of the file is:
"NAME" "MEM.SHIP"
"cgd1_10" "cgd1_10"... (9 Replies)
Hello there,
I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process.
Input in the csv file is ,
1,234,"abc,12,gh","GH234TY",34
I need output like below,... (8 Replies)
Hi,
I have a large number of files which are written as csv (comma-separated values).
Does anyone know of simple sed/awk command do achieve this?
Thanks!
---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ----------
Guess I asked this too soon. Found the... (0 Replies)
Hello,
I have a text file as:-ABC
BCD
CDF
DEF
EFGI need to convert as 'ABC', 'BCD', 'CDF', 'DEF', 'EFG' using a unix command
anybody can help me out on this.
Regards,
Jas
Please wrap all code, files, input & output/errors in CODE tags.
It makes them easier to read and preserves... (12 Replies)
Hi Experts,
Please support
I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6.
... (3 Replies)
Hi All,
Hope you are doing Great!!!.
Today i have came up with a problem to say exactly it was for performance improvement.
I have written code in perl as a solution for this to cut in specific range, but it is taking time to run for files thousands of lines so i am expecting
a sed... (9 Replies)
Discussion started by: mad man
9 Replies
LEARN ABOUT ULTRIX
mvwprintw
printw(3cur)printw(3cur)Name
printw, mvprintw, mvwprintw, wprintw - formatted write to a window
Syntax
#include <cursesX.h>
int printw(fmt [, arg] ...)
char *fmt;
int wprintw(win, fmt [, arg] ...)
WINDOW *win;
char *fmt;
int mvprintw(y, x, fmt [, arg] ...)
int y, x;
char *fmt;
int mvwprintw(win, y, x, fmt [, arg] ...)
WINDOW *win;
int y, x;
char *fmt;
Description
The routine adds a string to the default window starting at the current cursor position. This routine causes the string that would nor-
mally be output by to be output by
The routine adds a string to the specified window starting at the current cursor position. This routine causes the string that would nor-
mally be output by to be output by
The routine adds a string to the default window starting at the specified cursor position. This routine causes the string that would nor-
mally be output by to be output by
The routine adds a string to the specified window starting at the specified cursor position. This routine causes the string that would
normally be output by to be output by
All these routines are analogous to It is advisable to use the field width options of to avoid leaving unwanted characters on the screen
from earlier calls.
Return Values
The and functions return OK on success and ERR on error.
See Alsoaddstr(3cur), waddstr(3cur), printf(3s)printw(3cur)