Create Readable Text

Closed

Description

Need a plug-in, or external program that imports a delimited file. This might also be a Visual Basic macro for Excel. Take your pick! I'd prefer a standalone executable (with source code provided as part of the deliverable) but I'm also attracted to simple solutions that don't cost a lot.

This plug-in or program will take a simple Excel table with "x" rows and "y" columns and convert it into readable text. A simple table is defined as a table with only one row of column headers and only one column of row headers and no subheadings.

If this was a plug-in for Excel the user would define the table using a named range or select the table, or enter the number of rows and columns -- whatever works best. The plug-in would then parse the data and produce text output that can be either copied to the clipboard and used in another application or saved to a text file.

If the table looks like this (where Hdr A is the column heading for column 2, RHdr 1 is the row heading for row 1, etc.):

Hdr A Hdr B Hdr C

RHdr 1 data data data

RHdr 2 data data data

RHdr 3 data data data

The output would look like this:

RHdr 1, CHdr A: data; CHdr B: data; CHdr C: data

RHdr 2, CHdr A: data ; CHdr B: data; CHdr C: data

RHdr 3, CHdr A: data ; CHdr B: data; CHdr C: data

That would be good for starters. An step up would allow the user to choose the format of the output -- maybe they want to repeat the Row headers (RHdr) as:

RHdr 1, CHdr A: data;

RHdr 1,CHdr B: data;

RHdr 1,CHdr C: data

RHdr 2, CHdr A: data ;

RHdr 2, CHdr B: data;

RHdr 2, CHdr C: data

RHdr 3, CHdr A: data ;

RHdr 3, CHdr B: data;

RHdr 3, CHdr C: data

A more sophisticated version would deal with complex tables (tables with more than one row of column headers or more than one column of row headers.)

Please state what programming language and version you would use, the timeframe for completion, and the cost for additional work such as minor revisions by the hour.

Thanks!

Skills: .NET, Anything Goes, C Programming, C# Programming, Visual Basic

See more: what programming language is this, what programming language, what is visual basic programming, what is the best programming language, visual programming language, visual basic x, visual basic cost, visual basic 6.0 programming language, the d programming language, the best programming language, programming language d, programming in excel 2013, parse programming, m programming language, macro programming in excel, define programming language, create a programming language, convert one programming language to another, b programming language, best programming language, excel programming language, d programming language, Pick basic, hdr, standalone executable

Project ID: #4807208

Awarded to:

RajeshAndavar

Hey, Check your PM.

$30 USD in 3 days
(2 Reviews)
1.5

41 freelancers are bidding on average $93 for this job

Nirmal2006

Let's start now.

$60 USD in 6 days
(107 Reviews)
7.0
geekydeveloper

Hello Mate, We have 6 years of experience of core development and we have Experienced team

$242 USD in 10 days
(33 Reviews)
6.8
ravenspoint

I assume the input file will be a 'comma separated value' text file ( CSV ). ( Your example is space separated, but is ambiguous because of the spaces in the column and row headers. ) I will write this as a standalon More

$242 USD in 5 days
(46 Reviews)
6.6
usamacpp

We are a very experienced team who can tackle this task. Please check PMB for more details.

$144 USD in 10 days
(41 Reviews)
6.0
sinharavi

Please read my private message

$189 USD in 7 days
(23 Reviews)
4.9
zamoldar

I am interested in

$60 USD in 1 day
(6 Reviews)
4.8
northwolves

Expert of this field,I'm ready to start.

$80 USD in 1 day
(34 Reviews)
4.7
hbxfnzwpf

I am very proficient in c, c++. I have 15 years c++ developing experience now, and I have worked for 5 years, please let expert help you.

$59 USD in 0 days
(18 Reviews)
4.5
piyushdpatel

Hi This is Piyush Patel I have 8 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Please Check My PM

$111 USD in 3 days
(11 Reviews)
4.1
murtaza1981

Hi, I (Myself a senior ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-fr More

$200 USD in 3 days
(11 Reviews)
4.1
grigiq

Hi, I would gladly work on this project. Please check private message for details.

$49 USD in 2 days
(7 Reviews)
3.8
Scorpio1987

Please see PM for more details.

$50 USD in 3 days
(5 Reviews)
3.8
iScripter

Sir, Allow me to do this Honor, Please see the PMB. waiting for a positive reply. regards iScripter

$45 USD in 2 days
(11 Reviews)
3.5
paris2785

VB and VBA expert for over a decade. Master in Information Systems.

$45 USD in 7 days
(3 Reviews)
3.2
xylamic

I can complete this in 2 days in whichever language you prefer.

$77 USD in 2 days
(6 Reviews)
3.1
jayshreeganeshha

hi i am c#.Net developer and i can provide you the complete solution within a day thanks

$40 USD in 1 day
(5 Reviews)
2.9
expertatwork

Hi Raeben, We will go with Excel macros and we will create .txt files for the ouput. BTW, which OS are you using - MAC or WINDOWS - We develop apps only for all WINDOWS machines. thanks !

$30 USD in 1 day
(3 Reviews)
2.5
hgk

HI, I have over 8yrs of experience working with excel macros. I understand your requirements and would like to take up this project. The solution will be created as an excel macro as no complicated programming is inv More

$60 USD in 15 days
(6 Reviews)
2.5
can1vw

I will make a standalone application using AINSI C that can be compiled with any C compiler. I am writing well documented code that can easyly be modified afterward. Interface with the user will be inside a Command Pro More

$88 USD in 2 days
(3 Reviews)
2.2
premsl

Hi, I Understood your requirement. Its an easy task for me. I can do it in just 2-4 hours. Please see PMB for other details. Best Regards, Prem

$30 USD in 4 days
(1 Review)
2.1