Shell Programming and Scripting

modified code that will work for general cases:-

kindly notice that the line ended with ";" like PERL line codes.

Code:

nawk '{sub(/;/,";\n",$0)}1' ORS=""  file.txt

i/p

Code:

IDName  Column1 name    value
ID1     a1      ppp     10;

create table test(
id int(11),
name char);


ID1     a6      ppp     79;

o/p

Code:

IDName  Column1 name    valueID1        a1      ppp     10;
create table test(id int(11), name char);
ID1     a6      ppp     79;

right?

BR

I took the original poster's help request to mean that he wants a script that will take multiline input (from a user or standard input) and merge it into a single line which should be stored in the variable $query. I also assumed that the three-line sql fragment in the script was a poorly-placed sample of the input, as whether it's three lines or one, that code in a sh script will simply generate an error.

Proceeding under those assumptions, my proposed solution is:

Code:

#!/bin/sh

echo 'Enter your query (press Control-D when finished):'
query=$(tr -d \\n)
echo $query

Regards,
Alister