I have used Perl scripting to convert XLSX file to TXT file using Perl module Spreadsheet::XLSX.
I processed one XLSX file having one column and 65k rows of data .
Strangely ,It is merging data for every 2047 row and I could see data in TXT file as Ex: Suppose in XLSX file ,if 2047 row data is A and 2048 row data is B .
In respective converted TXT file ,for 2047 row data is AB (merging 2047 +2048 data of XLSX ) which it should not print like this .it should print 2047 row as A and 2048 row as B in converted TXT file .
This is the same scenario for every 2047 records repetively in the same converted TXT file
At 4094 row in TXT - merging 4094 + 4095 data of XLSX
At 6141 row in TXT - merging 6141 + 6142 data of XLSX
So finally,comparing with XLSX file records and converted TXT file records of the above file(65K rows), Iam missing around 40 to 60 records/rows in TXT file.
I tried using changing the TXT file to UTF-8 format ,but no luck.
Could anyone please let me know solution to overcome this .
For refernece below is the Perl script used for conversion ,
Hi ,
Thanks for the reply..
Tried that ,\n is giving the new line character for every record and avoding 2047 line issue. And also it is randomly giving blank records .More importantly, I should read this converted TXT file form other application .And that application doesn't entertains any new characters expect the records (data) parsed .
Thanks.Raj
---------- Post updated at 03:10 AM ---------- Previous update was at 01:30 AM ----------
Hi Every one ,
Looking for suggestions or any quick responses on this ..If any one have the idea upon the issue .
Or ANyone who has encountered and debugged this issue ..please respond..
Hi guys,
I'm new here. I have a problem at work. One of our scripts was eventually having a bug and only detected recently. Here's the issue and background:
Bash Script which calls AWK script
Awk script returns a string as per below (example):var1='00000-123'So, when we convert it, the... (18 Replies)
Hi,
I have a xml script, I converted it to .txt with values comma seperated using awk function. But I want the output values should be inside double quotes
My xml script (Workorders.xml) is shown like below:
<?xml version="1.0" encoding="utf-8" ?>
<scbm-extract version="3.3">... (8 Replies)
Hi All,
Am needing advise on how to convert xls file to xlsx format on Solaris unix command line or scripting. I tried searching online but it looks like I need to either use Perl packages of Excel or Python packages or some other 3rd party tool. Problem is to install any of these will require... (2 Replies)
Hello folks
I have a txt file of information about journal articles from different fields. I need to convert this information into a format that is easier for computers to manipulate for some research that I'm doing on how articles are cited. The file has some header information and then details... (8 Replies)
I have a table as following
Archive id Line Author Time Text
1fjj34 3 75jk5l 03:20 this is an evidence regarding ...
1fjj34 4 gjhhtrd 03:21 we have seen those documents before
1fjj34 10 645jmdvvb 04:00 Will you consider such an offer?... (0 Replies)
HI All,
I have a text file memory.txt which has following values.
Average: 822387 7346605 89.93 288845 4176593 2044589 51883 2.47 7600
i want to convert this file in csv format and i am using following command to do it.
sed s/_/\./g <... (3 Replies)
I think I know the answer to this :rolleyes: but thought I'd ask anyway. You never know.
Does anyone know of a program or utility that will run on any unix platform and convert Microsoft Excel files to ascii/plain text files that unix can understand ?
Thanks in advance.
Floyd (3 Replies)
Dear all,
I have a file with 5L records. one of the record in the file is as shown below.
MARIA THOMAS
BASIL
1000 FM 1111 MD
GHANA
YY 77354 4774
99999999 1234567
I need to convert this record in below format
"","","","","MARIA","THOMAS","BASIL","","1000 FM 1111 MD","STE... (1 Reply)
HI..
i have this problem..i want to copy a text file from linux and import it into an access file..but so many junk characters are coming in between..what i have to do..
plz help..
thanx in advance, (4 Replies)
Hello,
I transferred some .txt files from windows to Unix. When i used the editor in Unix to open up the file, all the <cr> show up. How to I get rid of all of them? (4 Replies)