Sponsored Content
Top Forums Shell Programming and Scripting Read csv file, convert the data and make one text file in UNIX shell scripting Post 302984888 by greet_sed on Wednesday 2nd of November 2016 08:48:19 AM
Old 11-02-2016
May i ?

with little change and without interim you can use RudiC solution, following might work:

Code:
awk -F, -vOFS="|" '
        {L2 = $1-length($2)
         L3 = $1-length($3)
         $5 = substr($4, 4, 1)=="1"?"B":"A"
         $4 = $1
	 $1 = "E" 
         $2 = sprintf ("%s%0*d%*s", $2, L2, 0, L3, "")
         $3 = sprintf ("%s%d%*s", $3, 10^L3-1, L2, "")
        }
1
'  file

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

shell script to read data from text file and to load it into a table in TOAD

Hi....can you guys help me out in this script?? Below is a portion text file and it contains these: GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001 GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001 GEF001 000093625 MKL005675 000001... (1 Reply)
Discussion started by: pallavishetty
1 Replies

2. Shell Programming and Scripting

Shell script to read lines in a text file and filter user data

hi all, I have this file with some user data. example: $cat myfile.txt FName|LName|Gender|Company|Branch|Bday|Salary|Age aaaa|bbbb|male|cccc|dddd|19900814|15000|20| eeee|asdg|male|gggg|ksgu|19911216||| aara|bdbm|male|kkkk|acke|19931018||23| asad|kfjg|male|kkkc|gkgg|19921213|14000|24|... (4 Replies)
Discussion started by: srimal
4 Replies

3. Shell Programming and Scripting

How to read the data from the text file in shell script?

I am having one text file and i need to read that data from my shell script. I will expain you the scenario: Script look like: For name type 1: For age type 2: For Salary type3: echo "Enter the input:" read the data if input is 1 then go to the Text file and print the... (2 Replies)
Discussion started by: dineshmurs
2 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. Shell Programming and Scripting

Read data from .csv file through shell script & modify

I need to read data from a file called "test.csv" through shell script where the file contains values like name,price,descriptor etc. There are rows where descriptor (& in some rows name) are written as string & other characters like "car_+" OR "bike*" etc where it should contains strings like... (3 Replies)
Discussion started by: raj100
3 Replies

6. Shell Programming and Scripting

Request for file read option in Unix shell scripting

Hi Friends, I would like to read all the record from one txt file to other file txt For example I have two txt file a.txt and b.txt. I need to read a.txt record by record and I need add the system date @ end of each record before moving it to b.txt. Could you please share the coding for... (4 Replies)
Discussion started by: vinoth124
4 Replies

7. Shell Programming and Scripting

Awk to convert a text file to CSV file with some string manipulation

Hi , I have a simple text file with contents as below: 12345678900 971,76 4234560890 22345678900 5971,72 5234560990 32345678900 71,12 6234560190 the new csv-file should be like: Column1;Column2;Column3;Column4;Column5 123456;78900;971,76;423456;0890... (9 Replies)
Discussion started by: FreddyDaKing
9 Replies

8. Shell Programming and Scripting

Shell scripting:from text file to CSV

Hello friends, I have a file as follows: "empty line" content1 content2 content3 content1 content2 content3 content1 content2 content3 It starts with an empty line, how can i get a csv like this: (12 Replies)
Discussion started by: kraterions
12 Replies

9. UNIX for Dummies Questions & Answers

Shell script to read lines in a text file and filter user data Shell Programming and Scripting

sxsaaas (3 Replies)
Discussion started by: VikrantD
3 Replies

10. UNIX for Beginners Questions & Answers

Shell - Read a text file with two words and extract data

hi I made this simple script to extract data and pretty much is a list and would like to extract data of two words separated by commas and I would like to make a new text file that would list these extracted data into a list and each in a new line. Example that worked for me with text file... (5 Replies)
Discussion started by: dandaryll
5 Replies
explain_sprintf_or_die(3)				     Library Functions Manual					 explain_sprintf_or_die(3)

NAME
explain_sprintf_or_die - formatted output conversion and report errors SYNOPSIS
#include <libexplain/sprintf.h> int explain_sprintf_or_die(char *data, const char *format, ...); int explain_sprintf_on_error(char *data, const char *format, ...); DESCRIPTION
The explain_sprintf_or_die function is used to call the sprintf(3) system call. On failure an explanation will be printed to stderr, obtained from the explain_sprintf(3) function, and then the process terminates by calling exit(EXIT_FAILURE). The explain_sprintf_on_error function is used to call the sprintf(3) system call. On failure an explanation will be printed to stderr, obtained from the explain_sprintf(3) function, but still returns to the caller. data The data, exactly as to be passed to the sprintf(3) system call. format The format, exactly as to be passed to the sprintf(3) system call. RETURN VALUE
The explain_sprintf_or_die function only returns on success, see sprintf(3) for more information. On failure, prints an explanation and exits, it does not return. The explain_sprintf_on_error function always returns the value return by the wrapped sprintf(3) system call. EXAMPLE
The explain_sprintf_or_die function is intended to be used in a fashion similar to the following example: int result = explain_sprintf_or_die(data, format, ...); SEE ALSO
sprintf(3) formatted output conversion explain_sprintf(3) explain sprintf(3) errors exit(2) terminate the calling process COPYRIGHT
libexplain version 0.52 Copyright (C) 2010 Peter Miller explain_sprintf_or_die(3)
All times are GMT -4. The time now is 03:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy