Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

[Solved] sed command help

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers [Solved] sed command help
# 1  
Old 02-27-2014
[Solved] sed command help
Hello all.

Im trying very hard to figure this out, but Im a newbie.

I have a file that looks like this....
Code:
6315551234 NJ224
5162224567 SUFF

Im trying to put a command together that will make it into this....
Code:
UM,6315551234,,,,,NJ224,0
UM,5162224567,,,,,SUFF,0

Im all over the place with commands, and all I have so far is this...
Code:
cat lines | awk '{print $1,,,,,$2,}' | sed 's/ /,/g' > TESTFILE

As you can see, Im still learning. Any help would be greatly appreciated.

Moderator's Comments:
Mod Comment Next time please use code tags for your data and code, thanks
Last edited by vbe; 02-27-2014 at 08:08 AM.. Reason: code tags
# 2  
Old 02-27-2014
Code:
sed 's/\([^ ]*\)\(.*\)/UM,\1,,,,,\2,0/' lines

# 3  
Old 02-27-2014
Wow, that was so fast. Thank you so very much. Now I just need to study it so I understand how it functions. Thank you so very much.

---------- Post updated at 08:14 AM ---------- Previous update was at 08:10 AM ----------

Another quick question....

How do I get rid of the space bewtween the ", NJ224"?

UM,8629027923,,,,, NJ224,0
# 4  
Old 02-27-2014
Code:
sed 's/\([^ ]*\) \(.*\)/UM,\1,,,,,\2,0/' lines

# 5  
Old 02-27-2014
Thank you so much. That last change made it easier for me to understand. Very much appreciate your time.
# 6  
Old 02-27-2014
Code:
awk '{print $1",,,,,"$2",0"}' lines

# 7  
Old 02-27-2014
Awk version:
Code:
awk '{print "UM",$1,x,x,x,x,$2,0}' OFS=, file

or
Code:
awk '{print "UM," $1 ",,,,," $2 ",0"}' file

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

[Solved] sed

sed -e 's/console/raw/g' this command will replace the letter pradeep with rawat what if i want to replace a word like FRIENDS with a space simultaneously from the same file i m replacing pradeep. im doing this sed -e 's/console/raw/g' && sed 's/FRIENDS//g' but i dono why this is not happening. (2 Replies)
Discussion started by: console
2 Replies

2. Shell Programming and Scripting

[Solved] Sed error - multiple number options to `s' command

Hi All, I am having two files (file1 & file2) and a filelist.txt file below. file1: $$STRINGVAR1=5 $$STRINGVAR2=10 $$LAST_UPD_DT_TBL1=12/12/2010 12:00:00 $$STRINGVAR3=100 $$LAST_UPD_DT_TBL2=01/01/2010 12:00:00... (8 Replies)
Discussion started by: Chandru_Raj
8 Replies

3. Shell Programming and Scripting

[Solved] SED - Bash - Inserting multi Tab character in the command

Hello. I am using : sed -i -e '/§name_script§/a#'"${MY_TAB11}"'# \ #'"${MY_TAB1}"'The Standard way'"${MY_TAB7}"'# \ #'"${MY_TAB1}"'==============='"${MY_TAB7}"'# \ ' "$CUR_FILE" Is there a better way to define "MY_TAB7","MY_TAB11" in other way than : MY_TAB1=$'\t' MY_TAB2=${MY_TAB1}$'\t'... (2 Replies)
Discussion started by: jcdole
2 Replies

4. Shell Programming and Scripting

[SOLVED] sed -i not available in solaris 5.10

Hi All, i'm writing a script where i have to grep for a pattern and the 3 lines after the pattern and comment them out. Note that i have to do this for multiple files, i am able to grep the pattern and the next 3 lines but since solaris does not recognize the -i option, i was wondering if... (11 Replies)
Discussion started by: Irishboy24
11 Replies

5. Shell Programming and Scripting

[SOLVED] sed command

Help request, I have tsted this line of code for hours. The first line works and the second line returns the message " sed: command garbled.....". This is running on solaris. The "${} variables all have good values when echoed. ## /bin/sed -n '1,25p' ${file} >> ${MailFile} ... (3 Replies)
Discussion started by: millerg225
3 Replies

6. UNIX for Dummies Questions & Answers

[solved]Help with a sed command

So I have a bunch of strings in a file. Example Line ./prcol/trt/conf/conf-app/jobdefinition/trt-pre-extr-trt-step.jdef Intended Result pre-extr-trt-step So far I have parsed it out to the last bit, echo $line | cut -d'/' -f7 | cut -d. -f1Result trt-pre-extr-trt-step So I added a... (2 Replies)
Discussion started by: J-Man
2 Replies

7. Shell Programming and Scripting

[Solved] My sed command not give me a satisfy result

This is my command echo "Test" | sed -f <(sed -e 's/.*/s,&,gI/' mydic) In mydic file,containing 2 columns delimit by comma (,) a,AlphabetA . . . e,AlphabetE . . s,AlphabetS . t,AlphabetT test,testedd . . zebra,zebraaaa The expect result is testedd (0 Replies)
Discussion started by: Runicer
0 Replies

8. Shell Programming and Scripting

[solved] how to separate using sed !

dears, hope evryone doing good in his work , i have a question about something important : how can i use 'sed' so in a script automatically it will take an enter before the number 1 in this line so 2 commands will be taken insted of one big command ?... (0 Replies)
Discussion started by: semaan
0 Replies

9. Shell Programming and Scripting

Solved: AWK SED HELP

Hi, I need to process a file as below. Could you please help to achieve that using awk/sed commands. Input file: --------------- AB | "abcdef 12345" | 7r5561451.pdf PQRST | "fghfghf hgkjgtjhghb ghhgjhg hghjghg " | 76er6ry.pdf 12345 | "fghfgcv uytdywe bww76 jkh7dscbc 78 : nvchtry hbuyt"... (0 Replies)
Discussion started by: viveksr
0 Replies

10. Shell Programming and Scripting

can this been solved with awk and sed?

Hi Masters, ___________________________________________________________________________________ Group of orthologs #1. Best score 3010 bits Score difference with first non-orthologous sequence - yeast:3010 human:2754 YHR165C 100.00% PRP8_HUMAN 100.00%... (16 Replies)
Discussion started by: mskcc
16 Replies
Login or Register to Ask a Question