I am having problem in deleting the leading spaces:-
Code:
cat x.csv
baseball,NULL,8798765,Most played
baseball,NULL,8928192,Most played
baseball,NULL,5678945,Most played
cricket,NOTNULL,125782,Usually played
cricket,NOTNULL,678921,Usually played
$ nawk 'BEGIN{FS=","}!a[$1] {print;a[$1]++;next}{print "\t"FS$2FS$3FS$4}' x.csv >y.csv
$ cat y.csv
baseball,NULL,8798765,Most played
,NULL,8928192,Most played
,NULL,5678945,Most played
cricket,NOTNULL,125782,Usually played
,NOTNULL,678921,Usually played
$ sed 's/^[ \t]*//' y.csv > z.csv
$ cat z.csv
baseball,NULL,8798765,Most played
,NULL,8928192,Most played
,NULL,5678945,Most played
cricket,NOTNULL,125782,Usually played
,NOTNULL,678921,Usually played
$ uuencode z.csv z.csv | mailx a.com
when i send it through mail to my personal mail id I can see a box sign in the csv sheet in windows..
can somebody please help me to resolve this
Thanks
Hi,
how to i remove leading and trailing spaces from a line? the spaces can be behind or in front of any field or line
example of a line in the input data:
Amy Reds , 100 , /bin/sh
how to i get it to be: Amy Read,100,/bin/sh
i saw something on this on the Man pages for AWK... (7 Replies)
How would I delete white spaces in a specified file?
Also, I'd like to know what command I would use to take something off a regular expression, and put it onto another.
ie.
.
.
.
expression1 <take_off>
.
.
.
expression2 (put here)
.
.
.
Any help would be great, thanks! (10 Replies)
I am trying to strip all leading and trailing spaces of a shell variable using either awk or sed or any other utility, however unscuccessful and need your help.
echo $SH_VAR | command_line Syntax.
The SH_VAR contains embedded spaces which needs to be preserved. I need only for the leading and... (6 Replies)
hi all...
i have the next question:
i have a flat file with a lot of records (lines). Each record has 10 fields, which are separated by pipe (|). My problem is what sometimes, in the first record, there are white spaces (no values, nothing) in the beginning of the record, like this:
ws ws... (2 Replies)
I have a variable that calls in a string from txt file. Problem is the string comes with an abundance of white spaces trailing it. Is there any easy way to trim the tailing white spaces off at the end? Thanks in advance. (9 Replies)
Hi,
Can anybody suggest me how to combine two strings with two or more white spaces and assign it to a variable?
E.g.
first=HAI
second=HELLO
third="$first $second" # appending strings with more than one white spaces
echo $third
this would print
HAI HELLO
Output appears... (2 Replies)
Hi Experts,
In a file tht i copied from the web , i am not able to remove the leading white spaces. I tried the below , none of them working . I opened the file through vi to check for the special characters if any , but no such characters found.
Your advice will be greatly appreciated.
sed... (5 Replies)
I have about 350 programs in which I have to add 2 lines; one before and one after a specfic line.
The following script does the job except that I lose the indentation.
#!/usr/bin/bash
while read line ... (8 Replies)
OS : RHEL 6.7
Shell : bash
I am trying to remove the leading the spaces in the below file
$ cat pattern2.txt
hello1
hello2
hello3
hello4
Expected output is shown below.
$ cat pattern2.txt
hello1
hello2
hello3
hello4 (2 Replies)
Discussion started by: John K
2 Replies
LEARN ABOUT NETBSD
dm.conf
DM.CONF(5) BSD File Formats Manual DM.CONF(5)NAME
dm.conf -- dungeon master configuration file
DESCRIPTION
The dm.conf file is the configuration file for the dm(8) program. It consists of lines beginning with one of three keywords, badtty, game,
and time. All other lines are ignored.
Any tty listed after the keyword badtty may not have games played on it. Entries consist of two white-space separated fields: the string
badtty and the ttyname as returned by ttyname(3). For example, to keep the uucp dialout, ``tty19'', from being used for games, the entry
would be:
badtty /dev/tty19
Any day/hour combination listed after the keyword time will disallow games during those hours. Entries consist of four white-space separated
fields: the string time, the unabbreviated day of the week and the beginning and ending time of a period of the day when games may not be
played. The time fields are in a 0 based, 24-hour clock. For example, the following entry allows games playing before 8AM and after 5PM on
Mondays:
time Monday 8 17
Any game listed after the keyword game will set parameters for a specific game. Entries consist of five white-space separated fields: the
keyword game, the name of a game, the highest system load average at which the game may be played, the maximum users allowed if the game is
to be played, and the priority at which the game is to be run. Any of these fields may start with a non-numeric character, resulting in no
game limitation or priority based on that field.
The game default controls the settings for any game not otherwise listed, and must be the last game entry in the file. Priorities may not be
negative. For example, the following entries limits the game ``hack'' to running only when the system has 10 or less users and a load aver-
age of 5 or less; all other games may be run any time the system has 15 or less users.
game hack 5 10 *
game default * 15 *
FILES
/etc/dm.conf The dm(8) configuration file.
SEE ALSO setpriority(2), ttyname(3), dm(8)BSD May 31, 1993 BSD