Apending some special character in file

Question

I have one file. I want to add ' at evry line beginning.also after first word complete I want to put ' again and then , after that I want repeat the same first word in 'same word'. How can I do this ?

e.g.

abc
xyz
pqr
mno

will be converted into

'abc','abc'
'xyz','xyz'
'pqr','pqr'
'mno','mno'

I have thousands of such lines.How can I achieve this ? I am using ubuntu 16.04.

I am getting output as shown below .

What I want is :

Regards.

Answer 1

Use sed:

sed "s/.*/'&','&'/" filename

s/foo/bar replaces foo by bar. .* matches the whole line, & in the replacement section inserts the whole match.

Answer 2

You have already got a sed answer. Here are a few alternatives:

---

awk: Setting single quote as variable q (for readability) and out as the record surrounded by single quotes, then printing out with desired formatting:

awk -v q="'" '{out=q$0q; print out","out}'

---

bash: Reading each line, setting up variable out to contain the line surrounded by single quotes, and finally printing in desired format:

while IFS= read -r line; do out="'$line'"; printf '%s,%s\n' "$out" "$out"; done

---

python: Reading each line, and printing in desired format using print() function:

#!/usr/bin/env python3
with open('file.txt') as f:
    for line in f:
        line = line.rstrip()
            print("'{}','{}'".format(line, line))

---

perl: Replacing each line (.*) with proper formatting, $& in the replacement stands for the matched portion, in this case the whole line:

perl -pe "s/.*/'$&','$&'/" 

---

Example:

% cat file.txt 
abc
xyz
pqr
mno

% awk -v q="'" '{out=q$0q; print out","out}' file.txt
'abc','abc'
'xyz','xyz'
'pqr','pqr'
'mno','mno'

% while IFS= read -r line; do out="'$line'"; printf '%s,%s\n' "$out" "$out"; done <file.txt
'abc','abc'
'xyz','xyz'
'pqr','pqr'
'mno','mno'

% perl -pe "s/.*/'$&','$&'/" file.txt
'abc','abc'
'xyz','xyz'
'pqr','pqr'
'mno','mno'