davidearl / jcomma Goto Github PK
View Code? Open in Web Editor NEWjcomma: flexible conversion and sanitization of CSV files
Home Page: https://jcomma.davidearl.uk
License: MIT License
jcomma: flexible conversion and sanitization of CSV files
Home Page: https://jcomma.davidearl.uk
License: MIT License
PHP Deprecation/Notice 8192: Creation of dynamic property DavidEarl\JComma\JComma::$fd is deprecated in /home/cameo/app-test/viacomposer/vendor/davidearl/jcomma/lib/JComma.php:13
PHP Deprecation/Notice 8192: Creation of dynamic property DavidEarl\JComma\JComma::$recipe is deprecated in /home/cameo/app-test/viacomposer/vendor/davidearl/jcomma/lib/JComma.php:15
PHP Deprecation/Notice 8192: Creation of dynamic property DavidEarl\JComma\JComma::$currentrow is deprecated in /home/cameo/app-test/viacomposer/vendor/davidearl/jcomma/lib/JComma.php:16
PHP Deprecation/Notice 8192: Creation of dynamic property DavidEarl\JComma\JComma::$errors is deprecated in /home/cameo/app-test/viacomposer/vendor/davidearl/jcomma/lib/JComma.php:17
PHP Deprecation/Notice 8192: Creation of dynamic property DavidEarl\JComma\JComma::$headings is deprecated in /home/cameo/app-test/viacomposer/vendor/davidearl/jcomma/lib/JComma.php:494
PHP Deprecation/Notice 8192: Creation of dynamic property DavidEarl\JComma\JComma::$outputtypes is deprecated in /home/cameo/app-test/viacomposer/vendor/davidearl/jcomma/lib/JComma.php:721
(a) add the ability to determine header rows based on content (either or both of the last header line and the first content line)
(b) some flexibility as to which header line(s) constitute the actual column headers
To avoid a lot of scrolling, keep the DO IT box at the top of the window at all times
The rest of the spec updates but not the json in the copy textarea
To help those who might wish to contribute, it would be helpful to have some kind of testing mechanism - either unit tests or even a set of regression tests.
They would provide useful examples as a kind of documentation as well.
e.g. replace regexp with value blank
The column label 'AA' (and I think BA, CA etc), and any headings that refer to those columns (27, 53, ...) says 'invalid column letter...'
It looks like it's because I have a strpos(...) == FALSE rather than strpos(...) === FALSE for the second letter if there is one.
fgetcsv seems to behave differently from before if byte order mark is present (it never behaved sensibly, but it seems to have changed).
And in any case, it didn't skip[ the BOM if no header rows were indicated.
For example, if the same column in the previous row is equal to the current row, omit record.
Motivated by CAF statements and similar which have inter-alia the following structure:
Gross amount, Fee, Net amount, Transfer ID, Transfer amount
GeoffG said by email:
When entering a regular expression in Jcomma, such as "replace using regular
expression", the box is rather small and given the nature of regexps one is
faced with a window into what may look like gibberish to the un-initiated!
Trying to review a regexp which doesn't quite do what you want can be a bit
tricky.
Would it be possible to make the regexp box(es) bigger? I could imagine having a
whole line for it, although it would be a bit trickier to make the layout look
nice.
They are in circles, which is fine, but the characters are small and not central
It might be useful to offer a SQL INSERT statement output format.
IE 11.589.10586.0 - Windows 10.
... In local Storage by name, so they can be selected from a pull down
Untick "include header row" and reselect saved recipe, and box is ticked again
As it says...
Would be useful to be able to sort the final output based on some part of the output
User request: allow recipe JSON to be pretty printed
When the value for a condition comes from a column, it should have a qualifying row number for when multiple rows are being consumed. Possibly only display if overall rowCount is > 1 (ditto selecting from column).
When a field is composed from more than one column or field, the append comma and append space options are being applied to the entire string so far, so the effect is cumulative, rather than being applied to each input individually.
When a field is composed of more than one column or field, it would be useful to be able to prefix a minus sign to the input (when not blank), in the same way as commas and spaces can be appended currently. This would provide an easier way to deal with separate Credit and Debit columns in the input, when one or the other is always blank. A trim option would deal with the case when the "blank" column actually has some spaces. This doesn't deal with the case where the ideally blank input is actually set to zero; that will have to be dealt with as two output fields of the same name, where one or other is omitted on output.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.