Source txt to be imported in xls as .csv Post: 302513091

Sponsored Content

Top Forums Shell Programming and Scripting Source txt to be imported in xls as .csv Post 302513091 by shruthidwh on Tuesday 12th of April 2011 10:02:20 AM

04-12-2011

Registered User

Source txt to be imported in xls as .csv

Hi ,

I am getting data as below for one of my table as below in a .txt format.I am manually opening a xls sheet, and then selecting import data from option and importing the data in to xls and then saving it as .csv file and this .csv file I am using for one of the shell script.

I am trying to automate the first part that is converting the pipe delimeter data from a .txt file to a .csv file

as I have more than 800 files( in my folder \root\edw\INT\source\) with same .txt extension as to be converted to a .csv files and then use then for my processing.

GEO_ID|GEO_NAME|GEO_PART|GEO_AREA|GEO_REF_NAME|
GEO_PRO_VALUE|GEO_POPULATION|GEO_YEAR|GEO_CROSS_JOIN|
GEO_JOIN2|GEO_MAN_ID|GEO_COUNT|

The above header is from my source file, I need to convert this to a .csv file.

I tried searching in the forum for .txt to .csv files and used some of the commands but I am not getting the required output,is there any option in unix which is similar to import data and select the notepad which we do in xls manually.

Please suggest how can I do this in unix.

Thx,
Shruthi

shruthidwh

View Public Profile for shruthidwh

Find all posts by shruthidwh

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting csv to xls

Hi, Can anyone tell the option to change the file type in unix. i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format. Thanks in advance, Milton.

2. Shell Programming and Scripting

From xls to csv file

Can we convert an xls file into csv format in Unix Thanks Suresh

3. Shell Programming and Scripting

How to input .txt file into .xls spreadsheet

I need to take the totals from my script and input them into a excel spreadsheet. Right now, I just copy and paste. Is there an easier way? 3906 is the total jobs in ABEND state 4005 is the total jobs in SUCC state 1050 is the total jobs in HOLD state

4. Shell Programming and Scripting

xls to csv

how to convert a xls file into .csv file? is tghere any command in unix for that? please help thanks

5. Shell Programming and Scripting

converting xls file to txt file and xls to csv

I need to convert an excel file into a text file and an excel file into a CSV file.. any code to do that is appreciated thanks

6. Shell Programming and Scripting

how to convert XLS to CSV and DOC/RTF to TXT

Hi, i don't know anything about PERL. Can anyone help me providing PERL scripts for 1. converting XLS to CSV (and vice-versa) 2. converting DOC/RTF to TXT Thanks much Prvn

7. Shell Programming and Scripting

How to read from txt file and write it to xls?

Hello All, I just want help in coding a simple shell script since i am a newbie for UNIX and i started learning unix and shell scripting basics recently. I am having a data like this in .txt file. Product Name : XYZ Price : 678.1 Best Buy Price : 600 Product Name : ABC Price : 465...

8. Shell Programming and Scripting

CSV to XLS

Ok, every morning at my office we send out excel sheets to Economy people with statistics for yesterdays trading. All the trading run's in Redhat or Solaris environments. We run a script on a Redhat server whitch generates the stats in CSV format. After we download we open it in Excel and...

9. Shell Programming and Scripting

Oracle to CSV to XLS

I would like to know if have one way with read table from oracle converter in CSV o TXT and After converter in XLS or spreedsheet Thanks so much JAvier

10. Shell Programming and Scripting

Csv to xls

Hello I have a script which converts log to csv. Now I need to have xls. Is there any easy way/command which can convert csv to xls?:confused: preferably just using bash and not perl,... is it possible?

LEARN ABOUT DEBIAN

obd2csv

obd2csv(1)						      General Commands Manual							obd2csv(1)

NAME

       obd2csv - Convert obdgpslogger(1) logs to csv files

SYNOPSIS

       obd2csv [ options ]

DESCRIPTION

       Convert obdgpslogger(1) logs to csv files

OPTIONS

       -o|--out <output filename>
	      Output to this .csv file

       -d|--db <database>
	      Work from logs stored in this database file

       -s|--start <time>
	      Only dump rows more recent than this

       -e|--end <time>
	      Only dump rows older than this

       -z|--gzip
	      gzip compress output using zlib [if available]

       -v|--version
	      Print out version number and exit.

       -h|--help
	      Print out help and exit.

NOT OPTIONS

       These options aren't intended for end-users, they're for the GUI.

       -p|--progress
	      Print out progress. It will occasionally print a number in the range [0..100], indicating progress percentage.

SEE ALSO

       obdgpslogger(1), obd2kml(1), obd2gpx(1), obdsim(1), obdgui(1), obdlogrepair(1)

AUTHORS

       Gary "Chunky Ks" Briggs <chunky@icculus.org>

																	obd2csv(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting csv to xls

Discussion started by: miltony

2. Shell Programming and Scripting

From xls to csv file

Discussion started by: sureshg_sampat

3. Shell Programming and Scripting

How to input .txt file into .xls spreadsheet

Discussion started by: wereyou

4. Shell Programming and Scripting

xls to csv

Discussion started by: infyanurag