User Tag List

Results 1 to 2 of 2

Thread: Changing the Datagrid Delimiter (Comma)

  1. #1
    No Products Registered

    Join Date
    May 2013
    Posts
    67
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Changing the Datagrid Delimiter (Comma)

    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

  2. #2
    Clicker Fusion 2.5 DeveloperSWF Export Module

    Join Date
    Sep 2006
    Posts
    511
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

Similar Threads

  1. Currency Comma Separator
    By Nyc in forum Multimedia Fusion 2 - Technical Support
    Replies: 3
    Last Post: 8th November 2013, 04:41 PM
  2. Beta RC3- [BUG] Newline$ as Delimiter
    By Kisguri in forum Android Export Module Version 2.0
    Replies: 1
    Last Post: 3rd January 2013, 09:54 PM
  3. String Parser Delimiter issue
    By AndyH in forum SWF/Flash Export Module Version 2.0
    Replies: 1
    Last Post: 11th October 2010, 11:16 AM
  4. String Object comma and dot displacement.
    By Nifflas in forum Multimedia Fusion 2 - Technical Support
    Replies: 0
    Last Post: 23rd September 2009, 09:40 PM
  5. Good string parser delimiter ?
    By Rushino in forum Multimedia Fusion 2 - Technical Support
    Replies: 14
    Last Post: 27th November 2006, 07:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •