Changing the Datagrid Delimiter (Comma)

Welcome to our brand new Clickteam Community Hub! We hope you will enjoy using the new features, which we will be further expanding in the coming months.

A few features including Passport are unavailable initially whilst we monitor stability of the new platform, we hope to bring these online very soon. Small issues will crop up following the import from our old system, including some message formatting, translation accuracy and other things.

Thank you for your patience whilst we've worked on this and we look forward to more exciting community developments soon!

Clickteam.

    I've been using the Datagrid object in my application and it's been working fine as a really efficient way of importing data, I'd like to keep using it as I'm familiar with it now and lots of my events and expressions rely on the object.

    One nag I've had, which isn't really game-breaking but a massive inconvenience, is that when I copy data into a cell from an Excel spreadsheet all the commas are treated as delimiters and separate large blocks of text into multiple cells. This is a problem as many of my cells contain paragraphs of text with multiple commas, and I'd like the paragraphs to remain in one cell.

    So is it possible to change the delimiter from a comma to some other other character? Or to remove the delimiter entirely? It would make my development much more efficient!

    Thanks in advance :)

    Hi Soily,

    I tested it and see what you're saying.
    The problem I ran into is that any possible solution is probably more work than you may want to do.
    Easiest method would be to replace all commas in your text with another symbol, then swap it out after data is pasted.
    Not perfect, but at least it won't screw up your columns :)

    Other options would basically include loading the data from an array that does not require comma delimiters and feeding that data to the grid data object.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login