Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Each line dilimited by ; in output

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Each line dilimited by ; in output
# 1  
Old 06-16-2012
Each line dilimited by ; in output
HI,

I am having a file as under :

Code:
A3/APT "ABCDEFG" 789 120612   1501
BLOCK SUPER
R        LVB   NDV   BLO
W2JO    10    680    20

I am using the under-noted script to get the outpur as under :
Code:
awk '/^A...P.|^O/ {if(b) print b;b=$0;next} NF {b=b$0" "} END {print b}' myfile

A3/APT "ABCDEFG" 789 120612   1501      BLOCK SUPER R        LVB   NDV   BLO W2JO    10    680    20

I wanted to get the output each line delimited by ";" as under :
Code:
A3/APT "ABCDEFG" 789 120612   1501;      BLOCK SUPER; R        LVB   NDV   BLO; W2JO    10    680    20

Please suggest.
# 2  
Old 06-16-2012
Code:
tr '\n' ';' < file | cat - <(echo)

# 3  
Old 06-16-2012
Quote:
Originally Posted by bartus11
Code:
tr '\n' ';' < file | cat - <(echo)

Thanks! But it did not succeeded in my case.Smilie
# 4  
Old 06-16-2012
Lightbulb
Well, I agree wuth bartus11 though....

Code:
 
$ cat  vanand420
3/APT "ABCDEFG" 789 120612   1501
BLOCK SUPER
R        LVB   NDV   BLO
W2JO    10    680    20

Code:
$  cat  vanand420 | tr '\n' ';'
3/APT "ABCDEFG" 789 120612   1501;BLOCK SUPER;R        LVB   NDV   BLO;W2JO    10    680    20;

# 5  
Old 06-16-2012
Quote:
Originally Posted by dipanchandra
Well, I agree wuth bartus11 though....

Code:
 
$ cat  vanand420
3/APT "ABCDEFG" 789 120612   1501
BLOCK SUPER
R        LVB   NDV   BLO
W2JO    10    680    20

Code:
$  cat  vanand420 | tr '\n' ';'
3/APT "ABCDEFG" 789 120612   1501;BLOCK SUPER;R        LVB   NDV   BLO;W2JO    10    680    20;

Thanks..might be shell issue. I am using bash on CYGWIN.
# 6  
Old 06-16-2012
Quote:
Originally Posted by vanand420
Thanks! But it did not succeeded in my case.Smilie
Uhm... strange. And what did happen?

However, try also this alternative:

Code:
mapfile -t line <myfile; for i in ${!line[@]}; do echo -n "${line[$i]};"; done; echo

This User Gave Thanks to Lem For This Post:
vanand420
# 7  
Old 06-16-2012
@vanand420
Please post what you typed and what output was produced. Also please highlight what went wrong. I can see that a trailing semi-colon might be a problem as might be the absence of any line terminator after conversion.


Just in case:
99% of all text file processing problems on Cywin are caused because a text data file contains Microsoft line terminators (carriage_return line-feed) not unix line terminators (line_feed).
Please post the output from this enquiry on your input data file:
Code:
sed -n l filename

A line terminator displayed as just a Dollar Sign is normal for unix.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Get an output of lines in pattern 1st line then 10th line then 11th line then 20th line and so on.

Input file: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 (6 Replies)
Discussion started by: Sagar Singh
6 Replies

2. Shell Programming and Scripting

How to read the output of a command line by line and pass it as a variable?

Hi, I have some 2000 names in a table like below. Java Oracle/SQL ANSI SQL SQL,DWH,DB DB&Java And by using for loop in my code i am able to get a single word but if there is any special character or space then it is considering as a next line. I have to execute the below queries in... (10 Replies)
Discussion started by: Samah
10 Replies

3. UNIX for Beginners Questions & Answers

Output to file print as single line, not separate line

example of problem: when I echo "$e" >> /home/cogiz/file.txt result prints to file as:AA BB CC I need it to save to file as this:AA BB CC I know it's probably something really simple but any help would be greatly appreciated. Thank You. Cogiz (7 Replies)
Discussion started by: cogiz
7 Replies

4. Shell Programming and Scripting

sed command to replace a line in a file using line number from the output of a pipe.

Sed command to replace a line in a file using line number from the output of a pipe. Is it possible to replace a whole line piped from someother command into a file at paritcular line... here is some basic execution flow.. the line number is 412 lineNo=412 Now i have a line... (1 Reply)
Discussion started by: vivek d r
1 Replies

5. Shell Programming and Scripting

Joining multi-line output to a single line in a group

Hi, My Oracle query is returing below o/p ---------------------------------------------------------- Ins trnas value a lkp1 x a lkp1 y b lkp1 a b lkp2 x b lkp2 y ... (7 Replies)
Discussion started by: gvk25
7 Replies

6. Shell Programming and Scripting

Bash - Loading a command's output line by line into an array

I have been trying this a lot of different ways and haven't found too much online. Here's what I've got so far: j=0 declare -a first zero=(`cat $tmpfile`) for i in "${zero}" do command $i >> "${first}" ... (4 Replies)
Discussion started by: Azrael
4 Replies

7. Shell Programming and Scripting

Converting line output to column based output

Hi Guys, I am trying to convert a file which has a row based output to a column based output. My original file looks like this: 1 2 3 4 5 6 1 2 3 1 2 3 (8 Replies)
Discussion started by: npatwardhan
8 Replies

8. Shell Programming and Scripting

single line input to multiple line output with sed

hey gents, I'm working on something that will use snmpwalk to query the devices on my network and retreive the device name, device IP, device model and device serial. I'm using Nmap for the enumeration and sed to clean up the results for use by snmpwalk. Once i get all the data organized I'm... (8 Replies)
Discussion started by: mitch
8 Replies

9. Shell Programming and Scripting

how to make a line BLINKING in output and also how to increase font size in output

how to make a line BLINKING in output and also how to increase font size in output suppose in run a.sh script inside echo "hello world " i want that this should blink in the output and also the font size of hello world should be big .. could you please help me out in this (3 Replies)
Discussion started by: mail2sant
3 Replies
Login or Register to Ask a Question