Converting form field to table format Post: 302605891

Sponsored Content

Top Forums Shell Programming and Scripting Converting form field to table format Post 302605891 by before4 on Friday 9th of March 2012 01:31:44 AM

03-09-2012

Registered User

Quote:

Originally Posted by ygemici

Code:

# awk -vfs=',' 'BEGIN{printf "%s%s%s\n","Name"fs,"Address"fs,"Phone";}{
if($0!~/^ *$/) a[++x]=$NF;else b[x]=x-1};END{for(i=1;i<=x;i++)if(i-1==b[i]&&b[i]!=0||i==x)printf "%s\n",a[i];
else{printf "%s"fs,a[i]}}' infile
Name,Address,Phone
Andi,none,82728
Peter,none,98799

regards
ygemici

Thank you.. but i can got the wrong output and also did not work for Name field more than 1 word( ie. Andi ruby) and when the field has empty value

Code:

$ awk -V | head -1
GNU Awk 4.0.0

$ cat data.txt
   Name = Andi
Address = none
   Phone = 82728

   Name = Peter
Address = none
   Phone = 98799

$ awk -vfs=',' 'BEGIN{printf "%s%s%s\n","Name"fs,"Address"fs,"Phone";}{ \
if($0!~/^ *$/) a[++x]=$NF;else b[x]=x-1};END{for(i=1;i<=x;i++)if(i-1==b[i]&&b[i]!=0||i==x)printf "%s\n",a[i]; \
else{printf "%s"fs,a[i]}}' data.txt
Name,Address,Phone
Andi,none,82728,                                         ,Peter,none,98799

Quote:

Originally Posted by Scrutinizer

Yes, the previous solution only works if the empty line between the records is completely empty (two linefeeds).
Try this instead:

Code:

awk -F '=[ \t]*' '$1~/Name/{p=$2;if(getline)p=p OFS $2;if(getline)print p,$2}' OFS=, infile

it's working , i tried to understand the code but can not get in.. i tried to modified for form that contain more than 3 fields ( name, address, phone,email etc.) but can not get the output it's only display the 3 fields.

Last edited by before4; 03-09-2012 at 05:15 AM..

before4

View Public Profile for before4

Find all posts by before4

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting %## back to special characters from an HTML form

I have an HTML form that sends email to a large list of users one at a time by matching an email address in peoplesoft to their username. It works great, except that special characters are converted to %## format. Is there a library of these I can use to sed them back (yes this is a crappy UNIX...

2. Shell Programming and Scripting

help on formatting output (Table Form)

Data in File ABC:DEFGHI:123 ABCZYE:DEFI:123 ABCFGD:DEF:123 ABCEERRRRR:DEFGHI:123 Expected Format 1 ABC DEFGHIFE 123 2 ABCZYE DEFI 123 3 ABCFGD DEF 123 4 ABCEERRRRR DEFGHI 123 However when i enter the following...

3. Shell Programming and Scripting

Converting html table data into multiple variables.

Hi, Basically what I am trying to do is the following. I have created a shell script to grab timetabling information from a website using curl then I crop out only the data I need which is a table based on the current date. It leaves me with a file that has the table I want plus a small amount...

4. Shell Programming and Scripting

Converting windows format file to unix format using script

Hi, I am having couple of files which i used to copy from windows to Linux, so now in case of text files (CTRL^M) appears at end of line. I know i can convert this windows format file to unix format file by running dos2unix. My requirement here is that i want to do it automatically using a...

5. Shell Programming and Scripting

Cgi to dump xml data from form input field

Hi All, I am trying to write a shell script which takes parse the web form find the input field and dump the data of that field into one xml file. The form looks like, <input type="button" id="btnSave" value="Save" onclick="saveXmlData()"/> <form name="submitForm"...

6. Linux

How do I format a Date field of a .CSV file with multiple commas in a string field?

I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below: column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10 "12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in...

7. Shell Programming and Scripting

Getting data in table form

Hi, I have a csv file from which i am fetching few columns as below: IFILE=/home/home1/Report1.csv OFILE=/home/home1/`date +"%m%d%y%H%M%S"`.dat if #Checks if file exists and readable then awk -F "," '(NR>4) {print $1,$6,$2,$3,$4,$5,$6}' ${IFILE} >> ${OFILE} fi cat $OFILE | mail...

8. Web Development

Php help to copy form field if empty

I have an input form with several fields. What I would like to achieve is to auto populate or copy certain fields if they are empty when the form is submitted. I would like to use php if not then javascript but not jquery if possible - I have sort of had a go but I really have no idea...

9. Shell Programming and Scripting

JSON structure to table form in awk, bash

Hello guys, I want to parse a JSON file in order to get the data in a table form. My JSON file is like this: { "document":{ "page": }, { "column": } ] }, { ...

LEARN ABOUT CENTOS

end

END(7)							  PostgreSQL 9.2.7 Documentation						    END(7)

NAME

       END - commit the current transaction

SYNOPSIS

       END [ WORK | TRANSACTION ]

DESCRIPTION

       END commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a
       crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT(7).

PARAMETERS

       WORK, TRANSACTION
	   Optional key words. They have no effect.

NOTES

       Use ROLLBACK(7) to abort a transaction.

       Issuing END when not inside a transaction does no harm, but it will provoke a warning message.

EXAMPLES

       To commit the current transaction and make all changes permanent:

	   END;

COMPATIBILITY

       END is a PostgreSQL extension that provides functionality equivalent to COMMIT(7), which is specified in the SQL standard.

SEE ALSO

       BEGIN(7), COMMIT(7), ROLLBACK(7)

PostgreSQL 9.2.7						    2014-02-17								    END(7)

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting %## back to special characters from an HTML form

Discussion started by: 98_1LE

2. Shell Programming and Scripting

help on formatting output (Table Form)

Discussion started by: blurboy

3. Shell Programming and Scripting

Converting html table data into multiple variables.

Discussion started by: domsmith

4. Shell Programming and Scripting

Converting windows format file to unix format using script

Discussion started by: sarbjit

5. Shell Programming and Scripting

Cgi to dump xml data from form input field

Discussion started by: jdp

6. Linux

How do I format a Date field of a .CSV file with multiple commas in a string field?

Discussion started by: dhruuv369

7. Shell Programming and Scripting

Getting data in table form

Discussion started by: Vivekit82

8. Web Development

Php help to copy form field if empty

Discussion started by: barrydocks

9. Shell Programming and Scripting

JSON structure to table form in awk, bash

Discussion started by: Gescad

LEARN ABOUT CENTOS

end