LiveCode Forums

Add Tab to that list of characters. Once I did the step in the previous post there were still problems. The exported CSV file had to be opened in a word processor and using Find-Replace (Replace All), have the Tabs removed.
Result was less problems yet.

This way there is no code to write except for the Description field cleaner and that's in javascript. The back end fix is quick, clean, and solves the issue for the main program also. It had a different but related problem with this field due to same the CRs and LFs. This way both are solved, wherea...

Look at solution taken though. First the existing table was cleaned. That, as far as we can tell so far, did away totally, with the CRs and LFs. Then the description is modified to clean any new entries. Lots easier than finagling with code. I thought it might be easier to do with code until the gro...

After all the searching and especially the great work and perseverance by Klaus and the LiveCode folks, the easiest solution turned for me out to be just to export the data, having the database admin tool, in this case phpmyadmin, take out these characters. That turned out to take just 3 steps: The ...

Thanks. I'm using the category ID number to match the event ID with the category ID. There is a different image associated with each category ID number. They are not in the same table. Looking at the DataGrid Tutorials and other stuff. Brigham Young University seems to have a lot of info also. :D

That works fine.
Thank you.

You got it! :D Here's what I'm thinking about. Export the database. Clean the Description field. Re-import. That'll fix what's there. All new entries have to go through the admin process anyway for approval. Now,thanks to you folks, that I know way more about what's happening, I can manually clean t...

That's what I've been asking all along. pDataArray["label 11"] already contains "corrupted" data (only the first LINE of the actual db field "Description") - I was already aware of how this works and this is why I asked the question about that specific field and not about the whole query in the orig...

At this point to convert that date to the long date is needed. Your solution on putting "of me" did the trick, now I just need the date "humanized" to the long date. It's in yyyy-dd-mm.

Looks like you did not really understand your problem so far, please read up my long answer again. I DO UNDERSTAND!! You all keep telling me how to change the query and I'm asking how to change the data in one of the fields returned from the query. The original question specifically asked about the...

REPLACE(event_desc, char(13) + char(10), '---') This is posted as a way to remove these characters in several different SQL forums and is said to consistently work. There were a lot of forums using this who say it works. Tried to get this to work in LiveCode. The "apply" button says there are no er...

Seems like this should work: put pDataArray["label 11"] into dText replace CRLF with "---" in dText set the text of field "Description" of me to dText It doesn't. Here's possibly, why. LiveCode can't see the line feed and carriage return characters in the field - Only in the record itself. If these ...

Yes, I understand how fields are delimited. The data coming from the database is fine except for the Description field. This is the only field that needs changing.

I think so. IF I'm understanding you correctly, looks like we're taking the returns out of the whole query results, then splitting that up. It's the Description field only I'm asking about. Taking them out of tData wrecks everything. The problem only happens when the Description field is loaded. rep...