Hi guys,

Could anyone suggest how to move a line above it in a large text file, for instance:

input:
----------
link=abc1
uid=S2

link=abc2
uid=S3

link=abc3
uid=S4

output looking for:
-------------------
uid=S2,link=abc1
uid=S3,link=abc2
uid=S4,link=abc3


any ideas appreciated.

perl -pe '$/ = undef; $_=<>; s/(link=\w+)\n(uid=\w+)\n/\2,\1/sg' FILE

sed -n '/link/{h;n;G;s/\n/,/p}' filename > newfilename
Let us know if you would like the above translated.

Best SED tutorial here:
http://www.grymoire.com/Unix/Sed.html

And I thought SED was inscrutable......

You were faster, but my code is shorter.....

Nice, I haven't seen anyone use sed like that in a while!

Now, use sed to solve the palindrome problem!

Thanks guys, I have tested works great. I had some garbage in my text it looks like that's where I got stuck but manually fixed those...for now it does the job well. Appreciated everyone.

pixellany is a god!

Hello guys,

I tried awk,sed,perl versions above but none did work for the desired output.

Could anyone help please?

Thanks much


input:

dn: uid=ABC,ou=htec,o=cm.com
cquestion: What's your e-mail?
dn: uid=BBB,ou=htec,o=cm.com
cquestion: What's your e-mail?
dn: uid=CCC,ou=htec,o=cm.com
cquestion: What's yout pet's name?
dn: uid=DDD,ou=htec,o=cm.com
cquestion: What's your e-mail?
dn: uid=EEE,ou=htec,o=cm.com
cquestion: What's last name?

output:

dn: uid=ABC,ou=htec,o=cm.com,cquestion: What's your e-mail?
dn: uid=BBB,ou=htec,o=cm.com,cquestion: What's your e-mail?
dn: uid=CCC,ou=htec,o=cm.com,cquestion: What's yout pet's name?
dn: uid=DDD,ou=htec,o=cm.com,cquestion: What's your e-mail?
dn: uid=EEE,ou=htec,o=cm.com,cquestion: What's last name?

I tried this awk:
This worked a bit ok but needed to put comma in between and remove the dn: from each line ... Could anyone help to edit?

awk '{
if (NR%2==1)
str=$0
if (NR%2==0)
print NR/2" "str" "$0
}' FILEIN > FILEOUT

You've been trying since July???.....

When you say that something does not work, it's best to describe exactly what happens or does not happen.

The code I gave you works for the original example--to wit: put the second line in front of the first, 4th in front of the third, etc.

Your current example (2nd line after the 1st) should also be pretty straightforward with SED---it will be a relatively small change to what I had before.

Hi - No, it was working for that file ...I was working on something new.... Pls give me sometime; I will retest it....

You have all the time you want........

Hi Again ... Using sed I get this error:

sed: command garbled: /cquestion/{h;n;G;s/\n/,/p}

perl was working for a smaller file... but for this one that about 250k lines...doing nothing but printing the same file.....

can you please help ?

example:

INPUT:
dn: uid=AAAA,ou=abcd,o=abc.com
cquestion: Where is your favorite vacation spot?

dn: uid=BBBB,ou=abcd,o=abc.com
cquestion: Where is your favorite colour?

dn: uid=CCCC,ou=abcd,o=abc.com
cquestion: What is your last name?

ouput should be like:

dn: uid=AAAA,ou=abcd,o=abc.com,cquestion: Where is your favorite vacation spot?
dn: uid=BBBB,ou=abcd,o=abc.com,cquestion: Where is your favorite colour?
dn: uid=CCCC,ou=abcd,o=abc.com,cquestion: Where is your last name?

.
.
.

these are about 250k lines....

thank you very much...

You would need to post the complete command you used.

BUT---that command I gave you is not what you want now (because you now want things in a different order)

First, let's look at what the original does:
Translation:
-n (suppress printing)
/link/ (for lines containing "link")
h (copy the line to the hold register)
n (get the next line)
G (recall the line from the hold register and append it to what you just read)
<<at this point we have detected the line containing "link", gotten the next line, and then added the first one after it>>
s/\n/,/ (replace the newline char. with a ",")
p (print out the final result)

In your most recent example, you want to key on the line containing "dn", and then add the next line after. The code will be similar, but, instead of appending from the hold register to the working register (G), you'll want to append to the hold register (H)

Go all the way back to my original post and look at the link--it explains all this quite well.