Print records which do not have expected number of fields in a comma delimited file Post: 302594381

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting Tab delimited file to Comma delimited file in Unix

Hi, Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix Thanks!!

2. Shell Programming and Scripting

Parse apart strings of comma separated data with varying number of fields

I have a situation where I am reading a text file line-by-line. Those lines of data contain comma separated fields of data. However, each line can vary in the number of fields it can contain. What I need to do is parse apart each line and write each field of data found (left to right) into a file....

3. UNIX for Dummies Questions & Answers

Sort the fields in a comma delimited file

Hi, I have a comma delimited file. I want to sort the fields alphabetically and again store them in a comma delimited file. For example, My file looks like this. abc,aaa,xyz,xxx,def pqr,ggg,eee,iii,qqq zyx,lmo,pqr,abc,fff and I want my output to look like this, all fields sorted...

4. UNIX for Dummies Questions & Answers

AWK ??-print for fields within records in a file

Hello all, Would appreciate if someone can help me out on the following requirement. INPUT FILE: -------------------------- TPS REPORT abc def ghi jkl mon pqr stu vrs lll END OF TPS REPORT TPS REPORT field1 field2 field3 field4 field5 field6

5. UNIX for Advanced & Expert Users

Problem while counting number of fields in TAB delimited file

I'm facing a strange problem, please help me out. Here we go. I want to count number of fields in particular file. filename and delimiter character will be passed through parameter. On command prompt if i type following i get 27 as output (which is correct) cat customer.dat | head -1 | awk...

6. Shell Programming and Scripting

Count number of column in a comma delimited file

I have a comma (,) delimited file. 106232145,"medicare","medicare,medicaid",789 I would like to count the number of fields in each line. I tried the below code awk -F ',' '{print NF-1}' This returns me the result as 5 instead of 4. This is because the awk takes...

7. UNIX for Dummies Questions & Answers

appending a command to print a file in a comma delimited format

Hi everyone, i have a file that I had grep'd from something else lets call it file1.txt which consists variable files and lines due to different scenarios/inputs 1782 9182 fe35 ac67 how can I print this in this manner? 1782,9182,fe35,ac67 also if i had piped the new output...

8. UNIX for Dummies Questions & Answers

How to convert a comma delimited string to records or lines of text?

Hi, I am not sure if I've posted this question before. Anyway, I previously asked about converting lines of text into a comma delimited string. Now I am needing to do the other way around ... :( :o Can anyone advise how is this possible? Example as below: Converting records/lines to...

9. UNIX for Dummies Questions & Answers

Make all records with the same number of fields (awk)

Hi, input: AA|BB|CC DD|EE FF what I am trying to get: AA|BB|CC DD|EE| FF|| I tried to create first an UDF for printing repeats, but I think I have an issue with my END section or my array: function repeat(str, n, rep, i) { for(i=1 ;i<n;i++) rep=rep str return rep } ...

10. UNIX for Beginners Questions & Answers

Need help on an old post - How to convert a comma delimited string to records or lines of text?

Hi, Apologies in advance to the moderator if I am posting this the wrong way. I've searched and found the solution to an old post but as it is a very old post, I don't see an option to update it with additional question. The question I have is in relation to the following post: How to...

LEARN ABOUT DEBIAN

xlhtml

xlhtml(1)						      General Commands Manual							 xlhtml(1)

NAME

       xlhtml - A program for converting Microsoft Excel Files .xls

SYNOPSIS

       xlhtml  [-a] [-asc] [-csv] [-xml] [-bcNNNNNN] [-bi/path] [-c] [-dp] [-v] [-fw] [-m] [-nc] [-nh] [-tcNNNNNN] [-te] [-xc:N-N] [-xp:N] [-xr:N-
       N] FILE

DESCRIPTION

       This manual page explains the xlhtml program. The program xlhtml is used to convert Microsoft Excel Spreadsheet files into either  html	or
       tab  delimitted ASCII. The program can be interfaced with helper scripts for viewing email attachments. Most use of this program is through
       the helper scripts and one would probably rarely resort to using the commandline interface.

OPTIONS

       -a     aggressively optimize html by removing </TR> </TD> or VALIGN="bottom". Some older browsers may not display properly in this mode.

       -asc   Ascii out of -dp and extraction data (-xc, -xp, -xr)

       -csv   Output in Comma Separated Values of -dp and extraction data (-xc, -xp, -xr)

       -xml   Output in XML of -dp and extraction data (-xc, -xp, -xr)

       -bc    Override the background color. e.g. -bc808080	for gray

       -bi    Use background image. e.g. -bi/home/httpd/icon/tar.gif

       -c     Centers the tables horizontally

       -dp    Dump page count and max columns and rows per page

       -v     Prints program version

       -fw    suppress formula warnings about accuracy

       -m     No encoding for multibyte

       -nc    tells it not to colorize the output.

       -nh    Suppress header and body tags in html output

       -tc    Override the text color. e.g. -tcFF0000	  for red

       -te    Trims empty rows & columns at the edges of a worksheet

       -xc    Columns (separated by a dash) for extraction (zero based)

       -xp    Page for extraction (zero based), one page only

       -xr    Rows (separated by a dash) to be extracted (zero based)

       An example of the extraction command line is: xlhtml -fw -asc -xp:0 -xr:2-6 -xc:0-1 Test.xls

       The extraction output is: Formatted output of cells by column left to right, columns separated by a tab, end of row is: 0x0A, end of  file:
       



AUTHOR

       Steve Grubb, Charles N Wyble

xlhtml								   May 15, 2002 							 xlhtml(1)