Visit Our UNIX and Linux User Community


Inserting semicolon at the end of a line


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Inserting semicolon at the end of a line
# 1  
Old 07-24-2013
Inserting semicolon at the end of a line

HI

Am totally confused with sed and translate command command.. My problem is

I have a file like
Code:
# vi test.csv
ABC_IMUY
ERD0_FN
VEG_NON_DES_IYT
BUY4_FLOW
POI_SHD_URDF_IYUT_REDS_CYC
UYT_PMC4_WIND
EX_FRE_FRD_L2_REF_FLICT
JHY_SGT_DSE_L2
IYO_HYTR_FGT_L3_BGT_ICT
CICO_MCX_MCOIE_L3.1_DSA
VGRE_BUWTE_YIURE_RL2L3_SHR
VT_TYEW_UEV_LL4
KODK_IWJXMX_MXEWI_L2ISS_BYW
MOSW_NAS_NIRS_L2_OIY_DSE

I used translate command as
tr '\n' ';' test1.csv > test1.csv_1

I got the output as
Code:
ABC_IMUY;ERD0_FN;


But I need the output as

Code:
# vi test.csv
ABC_IMUY;
ERD0_FN;
VEG_NON_DES_IYT;
BUY4_FLOW;
POI_SHD_URDF_IYUT_REDS_CYC;
UYT_PMC4_WIND;
EX_FRE_FRD_L2_REF_FLICT;
JHY_SGT_DSE_L2;
IYO_HYTR_FGT_L3_BGT_ICT;
CICO_MCX_MCOIE_L3.1_DSA;
VGRE_BUWTE_YIURE_RL2L3_SHR;
VT_TYEW_UEV_LL4;
KODK_IWJXMX_MXEWI_L2ISS_BYW;
MOSW_NAS_NIRS_L2_OIY_DSE;

Please help..Smilie
# 2  
Old 07-24-2013
Try this

Code:
awk '{$2=";"}' test.csv

or

Code:
sed 's/$/;/' test.csv

The translate command works by character. In your code, the newline command is replaced by ";" and the newline disappears. Hence all the lines are merged into a single line.

Last edited by krishmaths; 07-24-2013 at 03:36 AM.. Reason: Added sed solution
# 3  
Old 07-24-2013
why arent u using sed?

Code:
 
sed 's/$/;/g' filename

This User Gave Thanks to vidyadhar85 For This Post:
# 4  
Old 07-24-2013
Code:
awk '{$2=";"}' test.csv

This not working..

Am using ksh shell..

---------- Post updated at 01:47 AM ---------- Previous update was at 01:44 AM ----------

Code:
sed 's/$/;/g' filename

This works very fine.. Thanks
# 5  
Old 07-24-2013
Quote:
Originally Posted by Priya Amaresh
Code:
awk '{$2=";"}' test.csv

This not working..

Am using ksh shell..
I missed to include the print instruction. Corrected in the below statement.

Code:
awk '{$2=";"}1' test.csv

This User Gave Thanks to krishmaths For This Post:
# 6  
Old 07-24-2013
Some awk variation
awk '{print $0";"}' test.csv
awk '{$0=$0";"}1' test.csv
awk 1 ORS=";\n" test.csv

awk '{$2=";"}'
May not be a good solution of the file does contain more than one filed and the purpose is to get ; at end of every line

Last edited by Jotne; 07-24-2013 at 04:22 AM..

Previous Thread | Next Thread
Test Your Knowledge in Computers #970
Difficulty: Medium
The Android operating system includes the Linux kernel.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Inserting a blank line at the end of a .txt file?

Hi there, I am having this problem: a) I am uploading a txt file from windows (notepad) with some Gaussian 09 command lines; b) Gaussian needs in certain command files, that those files have a blank line at the end of the file! c) I open the command file with vi and no blank line at the of... (2 Replies)
Discussion started by: luismga
2 Replies

2. Shell Programming and Scripting

Replace semicolon within double quotes in a file with semicolon delimiter

Hello Team, Could you please help me with the below question? I have a file with the following properties 1) File Delimiter is ; 2) Text columns are within double quotes 3) Numeric columns will not have double quotes 4) File has total 6 columns Please see a sample record from file ... (3 Replies)
Discussion started by: sam99
3 Replies

3. Shell Programming and Scripting

How to have semicolon at the end of every line?

Hi, I wanted to create an automated script that will output a create table statement in unix. Below is the input and the desired output: INPUT: desc ZZ_APL_TIDDATELIST ( TID NUMBER AEX_DATE TIMESTAMP(6) ) desc ZZ_APL_TIDLIST ( TID NUMBER ) desc... (5 Replies)
Discussion started by: reignangel2003
5 Replies

4. Shell Programming and Scripting

Adding semicolon at the end of each line

Hi, I have a script which I need to change. I want to add a semicolon at the end of each line where the line starts with "grant" for e.g. create table(.... ); grant select on TABL1 to USER1 grant select on TABL1 to USER2should become create table(.... ); grant select on TABL1 to... (3 Replies)
Discussion started by: pparthiv
3 Replies

5. UNIX for Dummies Questions & Answers

How move characters following a semicolon to a new line

Hello, I was wondering how I can move this: ABC;>12 BLA;>67 DEF;>22 into this ABC >12 BLA >67 DEF >22 thanks for your help. (1 Reply)
Discussion started by: blakers
1 Replies

6. Shell Programming and Scripting

Replace a string after n semicolon every line

I have a file that is formatted in this way. a1;b2;c33;d4;e5;e;f;f;f;s d;ds;d;a;v;b;g;gr;r;rt;fdf s1;s2;s2;s3;s4; b1;f2;g3;h4;a3c4e;xcsd;fds; sd2;fs4;fs2;sdf3; I want to replace the value just before the 4th semicolon to empty string, regardless the value, such that it looks... (3 Replies)
Discussion started by: alienated
3 Replies

7. UNIX for Dummies Questions & Answers

Inserting a ' at the end of each line

Hi all, I can use the following command to insert a ' at the beginning of each line sed "s/^/'/g" test.txt > test1.txt However, I'm unable to use the following to insert a ' at the end of each line in this way sed "s/$/'/g" test.txt > test1.txt Any... (3 Replies)
Discussion started by: karthiknaidu
3 Replies

8. UNIX for Dummies Questions & Answers

Inserting control characters at the end of each line

How to add control characters at the end of each line in a file? Can anyone help me with this? Thanks, Shobana (2 Replies)
Discussion started by: Shobana_s
2 Replies

9. Shell Programming and Scripting

Inserting a line at the end

Hi All, I am using the below script to enter the URL at the end of file: echo "Enter the URL that should point to the particular microsite" read url sed "$a $url" redirects.virgin-atlantic.com.conf > temp But am getting the below error: ./script.sh:... (7 Replies)
Discussion started by: Shazin
7 Replies

10. Shell Programming and Scripting

put a semicolon at the end of each line of a file

hi, Consider there is a file containing 200 lines. please let me know which command is to be used to put a semicolon at the end of each line. if no single command is there then how it can be achieved. (1 Reply)
Discussion started by: surjyap
1 Replies

Featured Tech Videos