Sponsored Content
Full Discussion: Leading white spaces
Top Forums Shell Programming and Scripting Leading white spaces Post 302453697 by scripter12 on Thursday 16th of September 2010 05:26:44 AM
Old 09-16-2010
Leading white spaces

Hi,

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
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Leading and Trailing Spaces

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)
Discussion started by: sleepster
7 Replies

2. UNIX for Dummies Questions & Answers

deleting white spaces

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)
Discussion started by: cary530
10 Replies

3. Shell Programming and Scripting

Strip leading and trailing spaces only in a shell variable with embedded spaces

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)
Discussion started by: jerardfjay
6 Replies

4. Shell Programming and Scripting

delete white spaces

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)
Discussion started by: DebianJ
2 Replies

5. Shell Programming and Scripting

trimming white spaces

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)
Discussion started by: briskbaby
9 Replies

6. Shell Programming and Scripting

Two or more white spaces in string

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)
Discussion started by: harish_oty
2 Replies

7. Shell Programming and Scripting

remove leading spaces from a line

Hi friends I need some help, I have a file which looks as follows TEMP 014637065 014637065 517502 517502 RTE 517502 517502 RTE AWATER_TEST 12325 23563 588323 2323 5656 32385 23235635 ANOTHER_TEST 12 5433 FTHH 5653 833 TEST 123 123 3235 5353 353 53 35 353 535 3 YTERS GJK JKLS ... (6 Replies)
Discussion started by: lijojoseph
6 Replies

8. Shell Programming and Scripting

Not able to remove leading spaces

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)
Discussion started by: panyam
5 Replies

9. Shell Programming and Scripting

Preserve leading white space

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)
Discussion started by: jgt
8 Replies

10. Shell Programming and Scripting

Trying to remove leading spaces

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
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
All times are GMT -4. The time now is 11:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy