Search found 67 matches

by GregWills
Fri Aug 09, 2019 3:42 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Offset and wildcards
Replies: 10
Views: 966

Re: Offset and wildcards

Sorry for the slow reply, I have been using the program to update the database. It is all working pretty nicely … as I look for glitches. After a day of data input (needed to be done), I ran a version with your script -hh. Beautiful. It gathers all the entries that are close to the name in the datab...
by GregWills
Tue Aug 06, 2019 12:26 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Offset and wildcards
Replies: 10
Views: 966

Re: Offset and wildcards

Thanks Craig and Hermann for the suggestions. Always great to get other perspectives. I had tried the “is in” code in the script in an earlier version, and it sort of works. The problem came about when there was a student in the database lastName “Good”. However on the Attendance sheet (that is bein...
by GregWills
Sun Aug 04, 2019 5:58 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Offset and wildcards
Replies: 10
Views: 966

Re: Offset and wildcards

Thank you for your thoughts. Does this mean that wildcards can’t be used with Offset? This is the script that I am currently using. It does the job - mostly - but does miss variations of some names. I think the script is clunky and thought there would be a more elegant way of looking for as many var...
by GregWills
Sat Aug 03, 2019 6:27 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Offset and wildcards
Replies: 10
Views: 966

Offset and wildcards

Hi All Perhaps a simple question, but can you use wildcards with an Offset? I want to search for variations of a word. For example: offset(charsToFind, stringToSearch) charsToFind - Good-Smith stringToSearch - a database of last names I am searching each line of client data line by line looking for ...
by GregWills
Wed Jul 31, 2019 8:29 am
Forum: Databases
Topic: Returns in a column
Replies: 20
Views: 2242

Re: Returns in a column

Thanks jameshale, that did the trick. Processing 177,631 items was completed in 28 seconds. Nice. I can live with that. :-) I ended up changing the itemdelimiter to “~”, as OpenOffice needed the itemdelimiter to be nominated each time the resulting exported .csv file was opened (not sure why, as it ...
by GregWills
Tue Jul 30, 2019 7:32 am
Forum: Databases
Topic: Returns in a column
Replies: 20
Views: 2242

Re: Returns in a column

Thanks bogs for the timer. It greatly aided my sanity today :-) I had a mixed bag of times from this morning to this afternoon? But definitely with smaller numbers of items, times were reasonable. Large numbers of items (160,000) had ridiculous times. Thanks jameshale for your insight. That makes se...
by GregWills
Mon Jul 29, 2019 7:57 am
Forum: Databases
Topic: Returns in a column
Replies: 20
Views: 2242

Re: Returns in a column

The above script is faster with small amounts of data, but dramatically slows down as the number of items increase. 10,000 items - 1 second (Speeds were timed with a stopwatch so are only a guide.) 20,000 items - 2 seconds 40,000 items - 4 seconds 80,000 items - 14 seconds 160,000 items - 50 seconds...
by GregWills
Mon Jul 29, 2019 6:40 am
Forum: Databases
Topic: Returns in a column
Replies: 20
Views: 2242

Re: Returns in a column

Interesting how writing it down and seeing the information in another format can help!! I have answered my own question! repeat for tStudentNumbers add 1 to tCounter put tCounter * 15 into tNextSet -- item 15 of the next student put item tNextSet of tDataBaseHold into tSecond replace return with "¬"...
by GregWills
Mon Jul 29, 2019 6:17 am
Forum: Databases
Topic: Returns in a column
Replies: 20
Views: 2242

Re: Returns in a column

Hi All I have been exploring AxWald’s approach to removing returns in an item and am having success at removing the returns from imported data, adding data to this item, then replacing the returns on export - to be opened in OpenOffice (then Joomla). I know that item 15 in the import has returns wit...
by GregWills
Sun Jul 21, 2019 3:33 am
Forum: Databases
Topic: Returns in a column
Replies: 20
Views: 2242

Re: Returns in a column

:-( I have been trying to apply Alex Tweedly’s script but am struggling to understand how I use it. I haven’t required a custom function before so have been reading and exploring how they are constructed. Unfortunately I can’t work out how to call this script or what ‘defaults’ the script is referri...
by GregWills
Thu Jul 18, 2019 8:26 am
Forum: Databases
Topic: Returns in a column
Replies: 20
Views: 2242

Re: Returns in a column

Thank you so much AxWald for your very clear explanation. Much appreciated. That was the problem. I am in Australia, so there are many commas running wild here. I have decided to use OpenOffice, as it provides more control over what csv’s will look like when saved. I’ve abandoned Excel, as it was st...
by GregWills
Tue Jul 16, 2019 8:05 am
Forum: Databases
Topic: Returns in a column
Replies: 20
Views: 2242

Re: Returns in a column

Thank you all for your replies. I have been wandering around in this 'swamp of sorrow' :-) for some time now! I will continue to see if I can get out, but I need some more assistance, before I go under :-( AxWald, I liked your approach, but couldn't get your script to work. Am I missing something? I...
by GregWills
Sat Jul 13, 2019 5:19 am
Forum: Databases
Topic: Returns in a column
Replies: 20
Views: 2242

Returns in a column

Hi Everyone A question regarding a .csv file. I have a spreadsheet with a number of single word columns. One column however is a ‘Notes’ column with text and returns. In Excel, the ‘Notes’ data is displayed and contained within the column. When this is imported into LiveCode each return creates a ne...
by GregWills
Thu Jun 06, 2019 11:10 pm
Forum: Databases
Topic: CSV-UTF-8
Replies: 5
Views: 1484

Re: CSV-UTF-8

Brilliant. Thanks for your time to explain the process. That is a whole new world for me, but I will explore it to see where it takes me. Once I get my current export/import approach sorted, I will investigate your suggestions and see if it is something I could achieve.

Many thanks

Cheers
Greg
by GregWills
Thu Jun 06, 2019 1:56 pm
Forum: Databases
Topic: CSV-UTF-8
Replies: 5
Views: 1484

Re: CSV-UTF-8

Thanks for your reply Sphere. I wasn’t aware that I could insert data directly into Joomla from LC. Yes, I am wanting to do updates into the database. Any pointers on how to do this would be greatly appreciated. Thanks also to Thierry for the hint. I’ll check it out tomorrow. Time for bed here in Oz...

Go to advanced search