Sponsored Content
Full Discussion: Converting excel to text
Top Forums Shell Programming and Scripting Converting excel to text Post 302073693 by sssow on Wednesday 17th of May 2006 12:26:45 AM
Old 05-17-2006
Not sure if it helps, may be you can try saving the file as csv or tab delimited text file

There may be better ways that others may post
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

convert Text to Excel

I have some text data generated by a perl script and want to put it into an excel sheet. Is there a perl script that can do this for me, i.e, convert text data to excel? (1 Reply)
Discussion started by: Pavankk
1 Replies

2. UNIX for Advanced & Expert Users

Problem in converting password protected excel file to csv file in unix

I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner. I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
2 Replies

3. Shell Programming and Scripting

KSH - Text from input file truncated while converting it to excel

Dear Members, I am using the attached script to convert a input file delimited by '|' to excel. However, while processing the attribute change_reason, the whole content of the text under change_reason is not displayed completely in the cell in excel. It is truncated after only first few words.... (1 Reply)
Discussion started by: Yoodit
1 Replies

4. UNIX for Dummies Questions & Answers

Converting a text file with irregular spacing into a space delimited text file?

I have a text file with irregular spacing between values which makes it really difficult to manipulate. Is there an easy way to convert it into a space delimited text file so that all the spaces, double spaces, triple spaces, tabs between numbers are converted into spaces. The file looks like this:... (5 Replies)
Discussion started by: evelibertine
5 Replies

5. Shell Programming and Scripting

Converting excel to '|' delimiter

Hi All, Can you please suggest me how to convert excel format to ‘|' delimiter file. I need to use perl script Thanks Rama (5 Replies)
Discussion started by: murari83.ds
5 Replies

6. Shell Programming and Scripting

Converting specific Excel file tabs to CSV in Python

Hi list, This is probably something really simple, but I am not particularly familiar with Python so I thought I would ask as I know that python has an excel module. I have an excel document with multiple tabs of data and graphs. One of the tabs is just data which I require to have dumped to... (8 Replies)
Discussion started by: landossa
8 Replies

7. Shell Programming and Scripting

Converting txt file to Excel file

Hi All, I have a text file with below content. TradeDate Name SecurityMnc ReasonDesc ======================================= 20120501 Robin ABC FO System Defect 20120502 Robin ABC FO System Defect I would want this in an excel file in 4 columns,... (3 Replies)
Discussion started by: robinbannis
3 Replies

8. Programming

converting data from excel sheet to oracle using toad

guys i have data in excel sheet , how do i convert that data to database table (2 Replies)
Discussion started by: Gl@)!aTor
2 Replies

9. Shell Programming and Scripting

Shell Script for converting file to Excel or CSV

Hi I have a dat file which has "n" number of columns. The file is delimited. The number of columns keep varying as the file is generated out of DB queries. Could you please help me in writing a script which will generate a XLS or CSV file out of the dat file. (5 Replies)
Discussion started by: Vee
5 Replies

10. Shell Programming and Scripting

Error while Converting Excel to CSV using xls2csv

I am using xls2csv to convert a xls file into a regular .csv file. However, while using the command as xls2csv fromfile.xls > tofile.csv I am getting the following error. fromfile.xls is not OLE file or Error I also tried to specify the comma as delimiter but did not help... xls2csv -c\,... (7 Replies)
Discussion started by: dhruuv369
7 Replies
XmTabList(library call) 												   XmTabList(library call)

NAME
XmTabList -- Data type for a tab list SYNOPSIS
#include <Xm/Xm.h> XmTabList DESCRIPTION
XmTabList is the data type for a tab list. A tab list consists of tab stop list entries (XmTabs). Whenever a tab component is encountered while an XmString is being rendered, the origin of the next X draw depends on the next XmTab. If a tab stop would cause text to overlap, the x position for the segment is reset to follow immediately after the end of the previous segment. Tab lists are specified in resource files with the following syntax: resource_spec: tab WHITESPACE [, WHITESPACE tab ]* The resource value string consists of one or more tabs separated by commas. Each tab identifies the value of the tab, the unit type, and whether the offset is relative or absolute. For example: tab := float [ WHITESPACE units ] float := [ sign ] [[ DIGIT]*. ]DIGIT+ sign := + where the presence or absence of sign indicates, respectively, a relative offset or an absolute offset. Note that negative tab values are not allowed. units indicates the unitType to use as described in the XmConvertUnits reference page. For example, the following specifies a tab list consisting of a one inch absolute tab followed by a one inch relative tab: *tabList: 1in, +1in For resources of type, dimension, or position, you can specify units as described in the XmNunitType resource of the XmGadget, XmManager, or XmPrimitive reference page. RELATED
Refer to the Motif Programmer's Guide for more information about tabs and tab lists. XmTabListCopy(3), XmTabListFree(3), XmTabListGet- Tab(3), XmTabListInsertTabs(3), XmTabListRemoveTabs(3), XmTabListReplacePositions(3), and XmTabListTabCount(3). XmTabList(library call)
All times are GMT -4. The time now is 12:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy