Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Format column datas
Top Forums Shell Programming and Scripting Format column datas Post 302969400 by rdrtx1 on Tuesday 22nd of March 2016 10:25:35 AM
Old 03-22-2016
try:
Code:
awk '
BEGIN {c["a"]="CHR(32),R,"; c["n"]="CHR(48),L,";}
NF==1 {
   print "<?xml version=\"1.0\" encoding=\"GB2312\"?>";
   print "<convGrp>";
   print "   <grpid>" $1 "</grpid>";
   print "   <script>";
   print "   <![CDATA[";
}
NF==3 && c[$2] {
   print "      SET = FILL($" $1 "," c[$2] $3 ")";
}
END {
   print "   ]]>";
   print "   </script>";
   print "</convGrp>";
}
' data

This User Gave Thanks to rdrtx1 For This Post:
hhdzhu
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

select datas from an input file

I have a file containing a list of references and I want to run a script that will make the same action for each reference. The input file changes every hour, it's why I want to use a script that can read in a file, record by record, and run a specific action for the reference readed. Thanks... (1 Reply)
Discussion started by: dde
1 Replies

2. Shell Programming and Scripting

Blank characters between Datas

Hello, I read a file whose in lines are datas and between thses datas there is blank characters (10, 12 or 5 or 1 .......) So when i use the command while read line in the script(see under) there is also only one character between the datas and the others blank characters are not here. ... (3 Replies)
Discussion started by: steiner
3 Replies

3. UNIX for Dummies Questions & Answers

Format a column of text

Hi I have a LONG ! column of text and I would like to format this into several columns. so from this abcd efgh ijkl mnop qrst uvwx yz12 to this abcd efgh ijkl mnop qrstu vwx yz12 (2 Replies)
Discussion started by: mlucas
2 Replies

4. Shell Programming and Scripting

AWK CSV to TXT format, TXT file not in a correct column format

HI guys, I have created a script to read 1 column in a csv file and then place it in text file. However, when i checked out the text file, it is not in a column format... Example: CSV file contains name,age aa,11 bb,22 cc,33 After using awk to get first column TXT file... (1 Reply)
Discussion started by: mdap
1 Replies

5. Shell Programming and Scripting

How to format a column

Hi everybody I want to manipulate the output of this command: df -h to something like this: df -h | awk '{print"\t\t "$1"\t\t"$6"\t\t"$2"\t\t" $4}' | sed 's/Mounted/Mount Point/g' | sed 's/Avail/Free Space/g'but my problem is: if for example the mounting point is a long name everything beside... (3 Replies)
Discussion started by: ialbert
3 Replies

6. Shell Programming and Scripting

arranging datas if input file is not having also...!!

hi, my input file is containg uid, eriMaster ,eriResign, ericontry, dept. some of the uid are not having all info. out put should include all info irrespctive of datas of input file if any one data is missing, then it has to print Null or zero..then continue with the existing one. here... (0 Replies)
Discussion started by: hegdeshashi
0 Replies

7. Shell Programming and Scripting

Format Column

I need a script that takes it input wither it be from a file or inputed as variables and sort that into three columns. Thanks (3 Replies)
Discussion started by: prottheman
3 Replies

8. Shell Programming and Scripting

Print separated datas

Hi People !! I need your help. I have a a txt file "example" with it datas. 11:35 10/12/2003 10.10.10.1 God.com 5 country Responsable of ASN 11:37 12/12/2003 10.10.10.1 FATHER.COM 5 country Responsable of ASN 11:40 14/12/2003 10.10.10.3 www.mother 6... (6 Replies)
Discussion started by: ras
6 Replies

9. UNIX for Dummies Questions & Answers

Comparing datas in two excel file

Hi All, i have two excel sheets with same column name as below col1 col2 col3 ---- ---- ----- 1 121 156 24 456 788 45 444 777 765 32 77 col1 col2 col3 ---- ---- ----- 24 456 ... (1 Reply)
Discussion started by: arunmanas
1 Replies

10. Homework & Coursework Questions

How to display in column format?

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I would like to know how to display my output to this format below: 5000 Bash 300 zsh 0 sh ... (4 Replies)
Discussion started by: scopiop
4 Replies

LEARN ABOUT DEBIAN

vuname

VIEW-OS(1)						      General Commands Manual							VIEW-OS(1)

NAME

       vuname - print view information

SYNOPSIS

       vuname [OPTION]...

DESCRIPTION

       Print certain view information.	With no OPTION, same as -s.

OPTIONS

       -a, --all
	   print all information, in the following order, except omit -p and -i if unknown.

       -s, --kernel-name
	   print the kernel name

       -n, --nodename
	   print the network node hostname

       -r, --kernel-release
	   print the kernel release

       -v, --kernel-version
	   print the kernel version

       -m, --machine
	   print the machine hardware name

       -p, --processor
	   print the processor type or "unknown"

       -i, --hardware-platform
	   print the hardware platform or "unknown"

       -o, --operating-system
	   print the operating system

       -U, --serverid
	   print the view-os server id

       -V, --viewid
	   print the view id

       -N, --viewname
	   print the view name

       -x, --nouname
	   do not use uname (without this flag the command behaves like uname		when it runs on a non View-OS enabled environment).

       -q, --quiet
	   quiet mode: error messages suppressed

       --help
	   display a help message and exit

       --version
	   output version information and exit

SEE ALSO

       umview(1),uname(1)

AUTHORS

       View-OS is a project of the Computer Science Department, University of Bologna. Project Leader: Renzo Davoli.
       <http://www.sourceforge.net/projects/view-os>

       Howto's and further information can be found on the project wiki <wiki.virtualsquare.org>.

VIEW-OS: a process with a view					   June 11, 2007							VIEW-OS(1)
All times are GMT -4. The time now is 04:17 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy