Shell Programming and Scripting

hi i am using the following code in my shell script

Code:

awk -F":" '{printf("%-20.20s:%-20.20s:%-20.20s:%-20.20s:%-15.15s:%-3.3s:%-19.19s:%-2.2s:%-20.20s:%-15.15s:%-2.2s\n", $1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)}' $DIALPBIN/temp1.txt > ${DIALPBIN}/temp2.txt

actually the 5th field should not contain spaces or any special character.
what is the solution?

To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)

Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.

Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums

******************************************************

Can you please give an excerpt of your input file and the wanted output? Use code tags please.

what my code is doing, it is executing a sql file and the resullset of the query is getting stored in the text file in a fixed format. for that fixed format i have used the following code::

Code:

awk -F":" '{printf("%-20.20s:%-20.20s:%-20.20s:%-20.20s:%-15.15s:%-3.3s:%-19.19s:%-2.2s:%-20.20s:%-15.15s:%-2.2s\n", $1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)}' $DIALPBIN/temp1.txt > ${DIALPBIN}/temp2.tx

now 5th filed is a phone number. in the database it contains brackets like (0124)-23456
but in the file the output should be like 012423456

Could you please help????

Nvm.

Example:

Code:

echo "(0124)-23456"| awk '{gsub(/[()-]/,""); print}'
012423456

So in your awk line you might change following part:

Code:

... $2,$3,$4,(gsub(/[()-]/,"",$5)),$6,$7,...

Have currently no example to test it but it should be alike, sorry.

this is not working..

I missed a closing bracket. Maybe try this again. Corrected it in my former post. If it still does not work, give a complete example line, ty.

---------- Post updated at 02:41 PM ---------- Previous update was at 02:34 PM ----------

Ok, found the real problem you can see by the example how it works:

Code:

echo "aa (0124)-23456 bb"| awk '{gsub(/[()-]/,"",$2); printf("%s %s %s\n", $1,$2,$3)}'
aa 012423456 bb

So keep your line as is but add in front of the printf add the gsub part. Just change the $2 in the gsub into $5.

hi

i am getting these two errors

awk: syntax error near line 1
awk: illegal statement near line 1

---------- Post updated at 07:55 AM ---------- Previous update was at 07:53 AM ----------

gsub is not found..actually mine is a solaris OS.
could u suggest somne other option