Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Conditionally add character at end of line

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Conditionally add character at end of line
# 8  
Old 10-30-2014
Try egrep.

@cero: That's removing the last char!
This User Gave Thanks to RudiC For This Post:
cero
# 9  
Old 10-30-2014
@Rudi
thanks for the check - not my day today (didn't get enough sleep)...
# 10  
Old 10-30-2014
RudiC,
When I try:
Code:
sed -E 's/(;|.)$/;/' MyFile.csv

it replaces the last character on every line with a semicolon instead of adding a semicolon to the end of lines that don't already have one.

Try:
Code:
sed '/[^;]$/s/$/;/' MyFile.csv

These 3 Users Gave Thanks to Don Cragun For This Post:
jim mcnamara RudiC shamrock
# 11  
Old 10-30-2014
Longhand using builtins only, OSX 10.7.5, default shell and terminal...
Code:
#!/bin/sh
# add_char.sh
> /tmp/text
> /tmp/txt
echo 'web9331801;01/01/2014 23:39:35;;"93962";353150256;
web9331802;01/01/2014 23:44:29;;"479288";353153538;
web9331803;01/01/2014 00:00:11;;"877219";352215572
web9331805;01/01/2014 00:00:11;;"877219";352215572
web9331807;01/01/2014 00:00:14;;"624588";352215598
web9331801;01/01/2014 23:39:35;;"93962";353150256;
web9331802;01/01/2014 23:44:29;;"479288";353153538;
web9331803;01/01/2014 00:00:11;;"877219";352215572
web9331805;01/01/2014 00:00:11;;"877219";352215572
web9331807;01/01/2014 00:00:14;;"624588";352215598
web9331801;01/01/2014 23:39:35;;"93962";353150256;
web9331802;01/01/2014 23:44:29;;"479288";353153538;
web9331803;01/01/2014 00:00:11;;"877219";352215572
web9331805;01/01/2014 00:00:11;;"877219";352215572
web9331807;01/01/2014 00:00:14;;"624588";352215598
web9331801;01/01/2014 23:39:35;;"93962";353150256;
web9331802;01/01/2014 23:44:29;;"479288";353153538;
web9331803;01/01/2014 00:00:11;;"877219";352215572
web9331805;01/01/2014 00:00:11;;"877219";352215572
web9331807;01/01/2014 00:00:14;;"624588";352215598' > /tmp/text
while read line
do
	if [ "${line:$((${#line}-1)):1}" == ";" ]
	then
		printf "$line\n" >> /tmp/txt
	else
		printf "$line"';'"\n" >> /tmp/txt
	fi
done < /tmp/text
cat /tmp/txt

Results...
Code:
Last login: Thu Oct 30 19:10:57 on ttys000
AMIGA:barrywalker~> cd ~/Desktop/Code/Shell
AMIGA:barrywalker~/Desktop/Code/Shell> chmod 755 add_char.sh
AMIGA:barrywalker~/Desktop/Code/Shell> ./add_char.sh
web9331801;01/01/2014 23:39:35;;"93962";353150256;
web9331802;01/01/2014 23:44:29;;"479288";353153538;
web9331803;01/01/2014 00:00:11;;"877219";352215572;
web9331805;01/01/2014 00:00:11;;"877219";352215572;
web9331807;01/01/2014 00:00:14;;"624588";352215598;
web9331801;01/01/2014 23:39:35;;"93962";353150256;
web9331802;01/01/2014 23:44:29;;"479288";353153538;
web9331803;01/01/2014 00:00:11;;"877219";352215572;
web9331805;01/01/2014 00:00:11;;"877219";352215572;
web9331807;01/01/2014 00:00:14;;"624588";352215598;
web9331801;01/01/2014 23:39:35;;"93962";353150256;
web9331802;01/01/2014 23:44:29;;"479288";353153538;
web9331803;01/01/2014 00:00:11;;"877219";352215572;
web9331805;01/01/2014 00:00:11;;"877219";352215572;
web9331807;01/01/2014 00:00:14;;"624588";352215598;
web9331801;01/01/2014 23:39:35;;"93962";353150256;
web9331802;01/01/2014 23:44:29;;"479288";353153538;
web9331803;01/01/2014 00:00:11;;"877219";352215572;
web9331805;01/01/2014 00:00:11;;"877219";352215572;
web9331807;01/01/2014 00:00:14;;"624588";352215598;
AMIGA:barrywalker~/Desktop/Code/Shell> _

# 12  
Old 10-30-2014
More variations
Code:
sed 's/;\{0,1\}$/;/' file

GNU sed -r / BSD sed -E:
Code:
sed -E 's/;?$/;/' file

Code:
sed 's/[^;]$/&;/' file

--
For a fixed number of fields:
Code:
awk -v n=6 '{$n=x}1' FS=\; OFS=\; file

Last edited by Scrutinizer; 10-30-2014 at 05:15 PM..
# 13  
Old 10-30-2014
Quote:
Originally Posted by wisecracker
Longhand using builtins only, OSX 10.7.5, default shell and terminal...
... ... ...
Code:
while read line
do
	if [ "${line:$((${#line}-1)):1}" == ";" ]
	then
		printf "$line\n" >> /tmp/txt
	else
		printf "$line"';'"\n" >> /tmp/txt
	fi
done < /tmp/text

... ... ...
This happens to work with the supplied sample data (since it does not contain any % or \ characters, but it is very dangerous to use a user-supplied string as a format operand to printf.

This would be much safer:
Code:
while read -r line
do	if [ "${line:$((${#line}-1)):1}" == ";" ]
	then	printf '%s\n' "$line"
	else	printf '%s;\n' "$line"
	fi
done < /tmp/text > /tmp/txt

(Note also the addition of the -r option to read.)
Last edited by Don Cragun; 10-30-2014 at 04:43 PM.. Reason: Simplify output redirection.
This User Gave Thanks to Don Cragun For This Post:
wisecracker
# 14  
Old 10-30-2014
And here's the inversed corollary of Don Cragun's code...Smilie
Code:
sed '/;$/!s/$/;/' file
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to add a character at end of line?

Hai, I have got a small requirement in my script. and i am using bash shell. I need to add a dot (.) for some particular line in a file. Say for example, $Cat rmfile 1 This is line1 2 This is line2 3 This is line3 O/p should be : $Cat rmfile 1 This is line1 2 This is line2. #... (2 Replies)
Discussion started by: Sivajee
2 Replies

2. Shell Programming and Scripting

How to remove new line character at end of file.

I need to remove new line character from end of file. Suppose here are content. a|b|c|d|r a|b|c|d|r a|b|c|d|r <new line> that means file contains 4 lines but data is there in 3 lines. so I want that only 3 lines should be there in file. Please help (20 Replies)
Discussion started by: varun940
20 Replies

3. Shell Programming and Scripting

Add text at the end of line conditionally

Hi All, I have a file as below: cat myfile abcdef NA rwer tyujkl na I wish to add the text ".txt" at the end of all lines except the lines starting with NA or na. I know i can add text at the end of line using following command but I am not sure how to valiate the condition. (14 Replies)
Discussion started by: angshuman
14 Replies

4. Shell Programming and Scripting

add character to every end-of line in file

Hi All I have a file which conatins record.the length of every records is 47. problem : in the end of record i don't have a "\015" character. i want to add this "\015" charcter in the end of every record. the file contains something like 700 records. i've tried with sed command - nothing. ... (8 Replies)
Discussion started by: naamas03
8 Replies

5. Shell Programming and Scripting

add character to the end of each line in file

hi all i have 32 lines in file. the length of each line is 82 , i want that in the end of each line , means in postion 83-84 to put two characters 0d(=\015), 0a(=\012) i want that the 0d will be in postion 83 and the 0a will be in postion 84 in each line of the file how shall i do it ? ... (7 Replies)
Discussion started by: naamas03
7 Replies

6. Shell Programming and Scripting

Adding a special character at the end of the line

I used following to add * at the end of the line in file1. It adds * at the end but has a space before it for some lines but some other lines it adds exactly after the last character. How do I take out the space ? sed 's/$/*/' file1 > file2 example: contents of file1 : ... (2 Replies)
Discussion started by: pitagi
2 Replies

7. UNIX for Dummies Questions & Answers

How to add new line character at the end of a file

hi all, i have this question: How to add new line character at the end of a file???? i need this because i am loading a file to sybase and i have problems with the last record thanks for your help (5 Replies)
Discussion started by: DebianJ
5 Replies

8. UNIX for Dummies Questions & Answers

stripping last character from end of each line

Hi, sorry for being dumb but I have a file with a variable amount of records (day to day it differs) but is fixed at 80 characters wide. Unfortunately the 80th and last charachter in each line is a "^M" carriage return character which i want to get rid of. Is there a really easy command that i can... (6 Replies)
Discussion started by: hcclnoodles
6 Replies

9. Shell Programming and Scripting

end of the line character

How do i determine what the end of the line character is in a text file. for eg. is it \n or \f or \t etc.. Is there a unix command for this? (5 Replies)
Discussion started by: zomboo
5 Replies

10. UNIX for Dummies Questions & Answers

End of line character in BAsh

I'm trying to match the end of line character in a shell script under bash. What I have done it got is a loop that reads each line of a file into a temp variable and then I get each letter of that variable and do some work on it. One think I want to do it check if the character I checking if the... (1 Reply)
Discussion started by: Rukshan
1 Replies
Login or Register to Ask a Question