Sponsored Content
Top Forums Shell Programming and Scripting Auto correct a csv file using UNIX shell script. Post 302889101 by karthik_ak on Wednesday 19th of February 2014 12:49:42 AM
Old 02-19-2014
The code by Don removes the entire line before and after the first broken line.

The Code by Scrutinizer aslo does the same and each line repeats itself.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Modifying a csv file from Shell Script

Hi all, I have some script that creates a temp csv file. What I need to do is do some search and replace and modify the file from my shell script. I know the commands to open the file and then apply the reg ex but wasnt sure how I could do this from a script and modify the file? Any help... (2 Replies)
Discussion started by: not4google
2 Replies

2. UNIX for Advanced & Expert Users

Unix Shell Script with output to CSV File

Hi, I have a unix shell script that is outputting results from an SQL query to a *.csv file, using utl_file.put_line. The resulting file is then sent out via e-mail as a mail attachment. The issue I have is that when the mailed attachment is opened in Excel the first column is shown as... (1 Reply)
Discussion started by: heather.morton@
1 Replies

3. Shell Programming and Scripting

how to create csv file using shell script

I have a file in multiple directory which has some records in the following format File: a/latest.txt , b/latest.txt, c/latest.txt -> Name=Jhon Age=27 Gender=M Street=LA Road Occupation=Service I want to generate a csv file from the above file as follows File: output.csv -> ... (9 Replies)
Discussion started by: rjk2504
9 Replies

4. Shell Programming and Scripting

Exporting data as a CSV file from Unix shell script

Friends...This is the first time i am trying the report generation using shell script... any suggestions are welcome. Is there a way to set the font size & color when i am exporting the data from unix shell script as a CSV file ? The following sample data is saved as a .csv file in the... (2 Replies)
Discussion started by: appu2176
2 Replies

5. UNIX for Dummies Questions & Answers

Help to parse csv file with shell script

Hello ! I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so... As said in the title, I want to read a csv file with a bash script. Here is a sample of the file: ... (4 Replies)
Discussion started by: Grhyll
4 Replies

6. Post Here to Contact Site Administrators and Moderators

Auto correct a csv file using UNIX shell script.

Hi All, There are list of 4-5 .csv files which has 12 columns.In some cases one of the record is split into 2 records. What needs to be done is this split record has to be auto corrected and placed in the csv file. Eg: Let us consider sample.csv file and in normal conditions the file... (1 Reply)
Discussion started by: karthik_ak
1 Replies

7. Shell Programming and Scripting

Read csv file, convert the data and make one text file in UNIX shell scripting

I have input data looks like this which is a part of a csv file 7,1265,76548,"0102:04" 8,1266,76545,"0112:04" I need to make the output data should look like this and the output data will be part of text file: 7|1265000 |7654899 |A| 8|12660000 |76545999 |B| The logic behind the... (6 Replies)
Discussion started by: RJG
6 Replies

8. Shell Programming and Scripting

Help with Shell Scrip in Masking particular columns in .csv file or .txt file using shell script

Hello Unix Shell Script Experts, I have a script that would mask the columns in .csv file or .txt file. First the script will untar the .zip files from Archive folder and processes into work folder and finally pushes the masked .csv files into Feed folder. Two parameters are passed ... (5 Replies)
Discussion started by: Mahesh G
5 Replies

9. UNIX for Beginners Questions & Answers

How to zip csv files having specific pattern in a directory using UNIX shell script?

I have files in a Linux directory . Some of the file is listed below -rw-rw-r--. 1 roots roots 0 Dec 23 02:17 zzz_123_00000_A_1.csv -rw-rw-r--. 1 roots roots 0 Dec 23 02:18 zzz_121_00000_A_2.csv -rw-rw-r--. 1 roots roots 0 Dec 23 02:18 zzz_124_00000_A_3.csv drwxrwxr-x. 2 roots roots 6 Dec 23... (4 Replies)
Discussion started by: Balraj
4 Replies

10. Shell Programming and Scripting

How to auto correct a failing command?

If a command is not found, e.g. nawk, this is how I fix the problem ] && NAWK=/usr/bin/gawk ] && NAWK=/usr/bin/nawk ] && NAWK=/usr/bin/awkI use $NAWK an the set the appropriate value based on the system it runs. How can I implement a similar fix for a command found but illegal argument.... (6 Replies)
Discussion started by: mohtashims
6 Replies
TAPECALC(1)						      General Commands Manual						       TAPECALC(1)

NAME
tapecalc - full-screen editing calculator USAGE
tapecalc [options] [file-specifications] SYNOPSIS
Tapecalc is a fixed-point calculator that operates as a full-screen editor. DESCRIPTION
Tapecalc performs fixed-point computation. It is designed for use as a checkbook or expense-account balancing tool. Tapecalc maintains a running result for each operation. You may scroll to any position in the expression list and modify the list. Enter data by typing numbers (with optional decimal point), separated by operators. An output transcript may be saved and reloaded for further editing. Scripts are loaded from left to right (with the "output" processed first). OPTIONS
Command line options of tapecalc are: -h Prints the list of options. -i interval Sets compounding interval for interest computation. -o script Specify file in which to save output transcript. -p num Sets precision (number of digits after the decimal place). OPERATIONS
Computations: The operators are all single-character: + begins an addition - begins a subtraction ~ negates the result * begins a multiplication / begins a division % begins an interest computation (uses interval): rate=number. $ begins a sales-tax computation: rate=number. ( opening parenthesis. This may enclose a unary '-', more parentheses, or data (implicit unary '+'). ) closing parenthesis, expects another operator, not data. = flushes out the current number, forces re-computation of the running result. A space flushes out the current number-input, and (by default) sets the next operator to be the same as the current one. You may repeat the last arithmetic operation of any type: a repeats the last '+' (default 0). s repeats the last '-' (default 0). n repeats the last '~'. m repeats the last '*' (default 1). d repeats the last '/' (default 1). i repeats the last '%' (default 4). t repeats the last '$' (default 4). You may toggle the prefix operator of any number by typing a single character: A toggles the operator to '+'. S toggles the operator to '-'. N toggles the operator to '~'. M toggles the operator to '*'. D toggles the operator to '/'. I toggles the operator to '%'. T toggles the operator to '$'. Editing: As you enter data, you may edit it. A backspace deletes the last digit of the current number (if it is visible). Use the arrow keys or vi-style 'h' and 'l' to move left and right within the line. Other editing commands include u undoes the last x/X command (restricted to restoring the current data only). x deletes the current data. If the data is null, deletes the following line. X deletes the current data. If the data is null, deletes the preceding line and moves up. o opens a new line after the current line. O opens a new line before the current line. # edit the associated comment. An "open" permits you to insert a new operator and data into the expression list. You may type an operator character (e.g., '+'), and continue with the new data, or an operator-repeat (e.g., 'A'). In either case, you may edit the new data, just as you would the old data. A 'u' (or other toggle, such as 'o', 'O', or 'q') typed after an open will undo the open (and close it). Scrolling/cursor movement: H move to the top line on the screen. M move to the middle line on the screen. L move to the last line on the screen CTL/F scroll forward one screen. CTL/B scroll backward one screen. j move forward one line. k move backward one line. z<CR> move the current line to the top of the screen. z. move the current line to the middle of the screen. z- move the current line to the bottom of the screen. Like vi, tapecalc allows you to jump to a particular line with a ":" command :$ jumps to the last entry :1 jumps to the first entry. Scripts: Transcript files are formatted to permit line-oriented entries: <operator><value><tab><ignored><tab># comment The transcripts saved by tapecalc contain the running result in the "ignored" part. To exit without saving a transcript, type 'Q'. A nor- mal exit, by typing 'q', saves the list of operators, data (and running result) in the specified file. You can read and write scripts without leaving tapecalc. reads a script at the current entry :e file clears the current script and reads a script from the file. :f shows the current script name. :r file :w file writes a script to the specified file. ENVIRONMENT
Tapecalc runs in a portable UNIX(R) environment. FILES
Tapecalc is a single binary module, with a help file tapecalc.hlp installed in the same directory. FUTURE WORK
It would be nice to be able to change the precision within the program. In particular, the interest and sales tax computations would be more useful if their precision was independent of the running total. AUTHOR
Thomas Dickey SEE ALSO
wc (1), vi (1) TAPECALC(1)
All times are GMT -4. The time now is 07:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy