use awk to read variable length csv Post: 302121203

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a fixed length output from a variable length input

Is there a command that sets a variable length? I have a input of a variable length field but my output for that field needs to be set to 32 char. Is there such a command? I am on a sun box running ksh Thanks

2. Shell Programming and Scripting

Using awk to search variable length records

New to awk and need some help. I have a script that I would like to make more compact. I want to read a file and grab every field, from every record, except the last field. The records are variable length and have varying number of fields. A record will have at least two fields, but can have...

3. Shell Programming and Scripting

Read the csv file and assign the values in to variable

I have a csv file with the values seperated by commas.I want to extract these values one by one and assign to a variable using shell script.Any ideas or code?

4. Shell Programming and Scripting

Split variable length and variable format CSV file

Dear all, I have basic knowledge of Unix script and her I am trying to process variable length and variable format CSV file. The file length will depend on the numbers of Earnings/Deductions/Direct Deposits. And The format will depend on whether it is Earnings/Deductions or Direct Deposits...

5. Shell Programming and Scripting

changing a variable length text to a fixed length

Hi, Can anyone help with a effective solution ? I need to change a variable length text field (between 1 - 18 characters) to a fixed length text of 18 characters with the unused portion, at the end, filled with spaces. The text field is actually field 10 of a .csv file however I could cut...

6. UNIX for Dummies Questions & Answers

Writing awk script to read csv files and split them

Hi Here is my script that calls my awk script #!/bin/bash set -x dir="/var/local/dsx/csv" testfile="$testfile" while getopts " f: " option do case $option in f ) testfile="$OPTARG";; esac; done ./scriptFile --testfile=$testfile >> $dir/$testfile.csv It calls my awk...

7. Shell Programming and Scripting

Parse variable length status,timestamp CSV

I have the output of a process which on status change of the object being processed appends status,timestamp to the record in the text file... so i end up with output something like: task123,TERMINAL,glob,5,INITIAL,2012-02-27 16:48:07,PREPARING,2012-02-27 16:49:06,SCHEDULED,2012-02-27...

8. Shell Programming and Scripting

awk read column csv and search in other csv

hi, someone to know how can i read a specific column of csv file and search the value in other csv columns if exist the value in the second csv copy entire row with all field in a new csv file. i suppose that its possible using awk but i m not expertise thanks in advance

9. UNIX for Advanced & Expert Users

How to read variable length file on UNIX generated by Mainframe?

Hi All, We have variable block file generated on Mainframe. We have to process the file on unix. So we FTPed the file on binary (as it has packed decimal fields). but i don't know how to read the file on unix. As you know variable block file will have a data like record length followed by...

10. UNIX for Dummies Questions & Answers

Help with awk, where line length and field position are variable

I have several questions about using awk. I'm hoping someone could lend me a hand. (I'm also hoping that my questions make sense.) I have a file that contains pipe separated data. Each line has similar data but the number of fields and the field position on each line is variable. ...

LEARN ABOUT REDHAT

mouse_waitforupdate

mouse_waitforupdate(3)						Svgalib User Manual					    mouse_waitforupdate(3)

NAME

       mouse_waitforupdate - wait for an mouse update

SYNOPSIS

       #include <vgamouse.h>

       void mouse_waitforupdate(void);

DESCRIPTION

       This reads in mouse events from the mouse buffer and updates the internal svgalib variables which store the current mouse position and but-
       ton states. If there are no events the function does not return until one occurs.

SEE ALSO

       svgalib(7),  vgagl(7),  libvga.config(5),  eventtest(6),  mouse_close(3),  mouse_init(3),  mouse_getposition_6d(3),   mouse_setposition(3),
       mouse_setscale(3),  mouse_setwrap(3),  mouse_setxrange(3),  mouse_getx(3),  mouse_waitforupdate(3),  vga_setmousesupport(3), mouse_seteven-
       thandler(3), vga_waitevent(3)

AUTHOR

       This manual page was edited by Michael Weller <eowmob@exp-math.uni-essen.de>. The exact source of the referenced function as well as of the
       original documentation is unknown.

       It is very likely that both are at least to some extent are due to Harm Hanemaayer <H.Hanemaayer@inter.nl.net>.

       Occasionally  this might be wrong. I hereby asked to be excused by the original author and will happily accept any additions or corrections
       to this first version of the svgalib manual.

Svgalib (>;= 1.2.11)						   27 July 1997 					    mouse_waitforupdate(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a fixed length output from a variable length input

Discussion started by: r1500

2. Shell Programming and Scripting

Using awk to search variable length records

Discussion started by: synergy_texas

3. Shell Programming and Scripting

Read the csv file and assign the values in to variable

Discussion started by: rajbal

4. Shell Programming and Scripting

Split variable length and variable format CSV file

Discussion started by: chechun