Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Shell script to format a .CSV data
Top Forums Shell Programming and Scripting Shell script to format a .CSV data Post 302163503 by fpmurphy on Friday 1st of February 2008 06:57:11 AM
Old 02-01-2008
You mention SC3 and SC4 but the data example you gave is:

AcquiredMethod, AssetID, AssetLifecycleStatus, SC1, SC2, DC1, DC2

BY DC1 and DC2 do you mean SC3 and SC4
 

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

format csv file using shell script

i have a report.csv file from oracle datavase In that file data is like this with report heading and date SALES DAILY REPORT DATE: 06-26-2007 REPORT NAME: SALES DATA AA.BB.CCCC.DDDD,BBBBB,06-26-2007,0,BEGIN,END ZZ.VV.DDDD.XXXXXXX,MMMMMM,06-25-2007,18,BEGIN,END... (3 Replies)
Discussion started by: raosurya
3 Replies

2. UNIX for Advanced & Expert Users

shell script to format .CSV data

Hi all, I have written a shell script to search a specified directory (e.g. /home/user) for a list of specific words (shown as ${TMPDIR}/wordlist below). The script works well enough, but I was wondering if there was a way to display the line number that the word is found on? Thanks! cat... (1 Reply)
Discussion started by: tmcmurtr
1 Replies

3. 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

4. Shell Programming and Scripting

Reading the data from CSV and performing search through shell script

Hello, I am working on building a script that does the below actions together in my Linux server. 1) First, have to read the list of strings mentioned in CSV and store it in the shell script 2) Second, pick one by one from the string list, and search a particular folder for files that... (2 Replies)
Discussion started by: vikrams
2 Replies

5. Shell Programming and Scripting

Need perl or shell script to sort vertical lines to horizontal line in csv format

Need perl or shell script to sort vertical lines to horizontal line in csv format My file like below ------------------------- ================================================================================ PATH PINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845 ... (4 Replies)
Discussion started by: sreedhargouda.h
4 Replies

6. Shell Programming and Scripting

Format CSV file from a shell script

I have a shell script which creates a CSV files. there are 3 fields, field1, field2 and comp. I will generates the values for field1 and field2 and Want to compare both. If field1>filed2 then comp should be success written in green in CSV file, else it should fail in red color. How can I change the... (5 Replies)
Discussion started by: sauravrout
5 Replies

7. UNIX for Dummies Questions & Answers

Shell script to extract data from csv file

Hi Guys, I am new to shell script.I need your help to write a shell script. I need to write a shell script to extract data from a .csv file where columns are ',' separated. The file has 7 columns having values say column 1,column 2.....column 7 as below along with their values. Name, Address,... (7 Replies)
Discussion started by: Vivekit82
7 Replies

8. Shell Programming and Scripting

Shell script to extract data from csv file

Hi everyone, I have a csv file which has data with different heading and column names as below. Static Data Ingested ,,,,,,,,,,,,Known Explained Rejections Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10 ,... (14 Replies)
Discussion started by: Vivekit82
14 Replies

9. Programming

Python or Shell script to Grep strings from input file and output in csv format

Hi Experts, I am writing a python script to grep string from file and display output in csv file as in attached screenshot https://drive.google.com/file/d/1gfUUdfmQma33tz65NskThYDhkZUGQO0H/view Input file(result_EPFT_config_device) Below is the python script i have prepared as of... (1 Reply)
Discussion started by: as7951
1 Replies

LEARN ABOUT DEBIAN

locale::recodedata::iso_2033_1983

Locale::RecodeData::ISO_2033_1983(3pm)			User Contributed Perl Documentation		    Locale::RecodeData::ISO_2033_1983(3pm)

NAME

       Locale::RecodeData::ISO_2033_1983 - Conversion routines for ISO_2033_1983

SYNOPSIS

       This module is internal to libintl.  Do not use directly!

DESCRIPTION

       This module is generated and contains the conversion tables and routines for ISO_2033-1983.

COMMENTS

       The following comments have been extracted from the original charmap:

	version: 1.0
	repertoiremap: mnemonic,ds
	 source: ECMA registry
	alias ISO-IR-98
	alias E13B

       Please note that aliases listed above are not necessarily valid!

CHARACTER TABLE

       The following table is sorted in the same order as the original charmap.  All character codes are in hexadecimal.  Please read 'ISO-10646'
       as 'ISO-10646-UCS4'.

	Local | ISO-10646 | Description
       -------+-----------+-------------------------------------------------
	   00 |  00000000 | NULL (NUL)
	   01 |  00000001 | START OF HEADING (SOH)
	   02 |  00000002 | START OF TEXT (STX)
	   03 |  00000003 | END OF TEXT (ETX)
	   04 |  00000004 | END OF TRANSMISSION (EOT)
	   05 |  00000005 | ENQUIRY (ENQ)
	   06 |  00000006 | ACKNOWLEDGE (ACK)
	   07 |  00000007 | BELL (BEL)
	   08 |  00000008 | BACKSPACE (BS)
	   09 |  00000009 | CHARACTER TABULATION (HT)
	   0A |  0000000A | LINE FEED (LF)
	   0B |  0000000B | LINE TABULATION (VT)
	   0C |  0000000C | FORM FEED (FF)
	   0D |  0000000D | CARRIAGE RETURN (CR)
	   0E |  0000000E | SHIFT OUT (SO)
	   0F |  0000000F | SHIFT IN (SI)
	   10 |  00000010 | DATALINK ESCAPE (DLE)
	   11 |  00000011 | DEVICE CONTROL ONE (DC1)
	   12 |  00000012 | DEVICE CONTROL TWO (DC2)
	   13 |  00000013 | DEVICE CONTROL THREE (DC3)
	   14 |  00000014 | DEVICE CONTROL FOUR (DC4)
	   15 |  00000015 | NEGATIVE ACKNOWLEDGE (NAK)
	   16 |  00000016 | SYNCHRONOUS IDLE (SYN)
	   17 |  00000017 | END OF TRANSMISSION BLOCK (ETB)
	   18 |  00000018 | CANCEL (CAN)
	   19 |  00000019 | END OF MEDIUM (EM)
	   1A |  0000001A | SUBSTITUTE (SUB)
	   1B |  0000001B | ESCAPE (ESC)
	   1C |  0000001C | FILE SEPARATOR (IS4)
	   1D |  0000001D | GROUP SEPARATOR (IS3)
	   1E |  0000001E | RECORD SEPARATOR (IS2)
	   1F |  0000001F | UNIT SEPARATOR (IS1)
	   20 |  00000020 | SPACE
	   30 |  00000030 | DIGIT ZERO
	   31 |  00000031 | DIGIT ONE
	   32 |  00000032 | DIGIT TWO
	   33 |  00000033 | DIGIT THREE
	   34 |  00000034 | DIGIT FOUR
	   35 |  00000035 | DIGIT FIVE
	   36 |  00000036 | DIGIT SIX
	   37 |  00000037 | DIGIT SEVEN
	   38 |  00000038 | DIGIT EIGHT
	   39 |  00000039 | DIGIT NINE
	   3A |  00002446 | OCR BRANCH BANK IDENTIFICATION
	   3B |  00002447 | OCR AMOUNT OF CHECK
	   3C |  00002448 | OCR DASH
	   3D |  00002449 | OCR CUSTOMER ACCOUNT NUMBER
	   7F |  0000007F | DELETE (DEL)

AUTHOR

       Copyright (C) 2002-2009, Guido Flohr <guido@imperia.net>, all rights reserved.  See the source code for details.

       This software is contributed to the Perl community by Imperia (<http://www.imperia.net/>).

SEE ALSO

       Locale::RecodeData(3), Locale::Recode(3), perl(1)

POD ERRORS

       Hey! The above document had some coding errors, which are explained below:

       Around line 732:
	   =cut found outside a pod block.  Skipping to next block.

perl v5.10.1							    2009-06-23				    Locale::RecodeData::ISO_2033_1983(3pm)
All times are GMT -4. The time now is 08:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy