(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › What I'm working on
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 [2]  Send Topic Send Topic Print Print
Very Hot Topic (More than 25 Replies) What I'm working on (Read 3064 times)
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: What I'm working on
Reply #15 - Nov 26th, 2005 at 9:01pm
Print Post Print Post  
Quote:
So, if your template is (###) ###-#### Ext: ###, which would normally return (for example): "(123) 456-7890 Ext: 981", you would like an option that would cause it to return: "1234567890981"?
Yes, that is correct.

Combining that with your recent "optional" section after ">" would be perfect.

Developers/programmers will usually prefer the option to get raw data and do what they want with it.  But many end users  just want to select the formatted info and not need to learn how to use Left/Right/Mid, etc.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: What I'm working on
Reply #16 - Nov 26th, 2005 at 10:59pm
Print Post Print Post  
AWESOME!!! 8)

I knew you could do it. This will make for a much cleaner look if there no extension.
  

Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
WWW WWW  
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: What I'm working on
Reply #17 - Nov 27th, 2005 at 2:13am
Print Post Print Post  
Quote:
Yes, that is correct.

Combining that with your recent "optional" section after ">" would be perfect.

Developers/programmers will usually prefer the option to get raw data and do what they want with it.  But many end users  just want to select the formatted info and not need to learn how to use Left/Right/Mid, etc.



Its certainly doable as a SBasic function. Having it as an option in SDesigner would be substantially more difficult unless I make it part of the template mini-language.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: What I'm working on
Reply #18 - Nov 27th, 2005 at 5:52pm
Print Post Print Post  
Well, today - I'm back at the office. I'm working on two SBasic functions, one that can format a string based on a supplied template, and one that removes the template from a string, also based on a supplied template.

So:
Code
Select All
str = @TemplateString("(###) ###-####", "1234567890")

produces: (123) 456-7890

and:
Code
Select All
str = @DetemplateString("(###) ###-####", "(123) 456-7890")

produces: 1234567890
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: What I'm working on
Reply #19 - Nov 27th, 2005 at 6:00pm
Print Post Print Post  
OK Mark -

You're just doing too much so how about a real challenge?

Convert words (like some people like to use for memory retention purposes) such as 813-LAKEMOTEL  (813-LAK-EMOT) to numbers.   lol

JUST KIDDING!!!!

Don't you need a beta tester for version 2.0?   NOT KIDDING!!!!  lol
  
- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
WWW WWW  
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: What I'm working on
Reply #20 - Nov 27th, 2005 at 6:07pm
Print Post Print Post  
Those look great, Mark!

I would think that should cover everyone's point of view. It wouldn't matter whether the data is in template format or not, these make it easy to change the data to the opposite format if needed.
  

Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
WWW WWW  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: What I'm working on
Reply #21 - Nov 27th, 2005 at 10:21pm
Print Post Print Post  
Mark, once again you are spoiling us! Grin

1.  Only drawback that I see is that the user must know the existing template to use @DetemplateString, is that correct?  What happens if a template character(s) or position(s) is entered that is not correct?  Maybe it should just take a value of characters to be excluded from the returned value, like @DetemplateString("( -)",LEname) on a phone number element or @DetemplateString("-",LEname) on a US 9 digit zipcode element?,

Providing functions like this is the option vs. adding a new box to the Editor like Visibile, Initial Value?  If a new box was available, then @DetemplateString could just be passed the LE name and not require the user to know the value of the existing template.

2.  I am assumming that "12134567890" can be replaced by an LE name.

3.  And future version will allow us to pick from saved Template Specs like Retrieve Specs ?

Thanks again for your responses to our never ending requests.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: What I'm working on
Reply #22 - Nov 27th, 2005 at 10:49pm
Print Post Print Post  
The template (as well as all other info about any LE) is available to be get or set using the Attribute and @Attribute functions. So, yes - usually one would:
Code
Select All
var template as string
var str as string

template = @Attribute(MyLE, ATTR_ID_ENTRY_TEMPLATE)
if(not @Error)
{
  str = @DeTemplateString(template, MyLE)
}


If, for example, you wanted to eliminate the dash, but not the parenthesis, you would use: "*###* ###-####" as the template, instead of: "(###) ###-####". Any position containing a "*" will accept whatever character is at that position in the source string. That way you do not inadvertantly eliminate characters that were allowed by the original template and entered (correctly) by the user.

Templates are a design time spec, like custom help, tooltips, formatting, etc... Not a runtime spec, like import, export, mass update, etc... So, no - the end user cannot edit, load, or save templates. Only the designer can do that.

But, the programmer, using the Attribute function, can dynamically alter/edit/disable/enable templates as well as all of the other LE attributes.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: What I'm working on
Reply #23 - Nov 28th, 2005 at 1:35am
Print Post Print Post  
I think I have got it.......Hope that you provide a number of examples in the documentation.  I think that this one will take some trial and error work to fully get a handle on it.

Thanks again Mark.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: What I'm working on
Reply #24 - Jan 9th, 2006 at 3:31pm
Print Post Print Post  
The Cow (Mark),

You must be busy (as always) but I miss seeing this post updated. I know the post sort of morphed into other posts but those seemed to have faded also.

Hope all is well and was just wondering “What are you working on”
  
Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: What I'm working on
Reply #25 - Jan 9th, 2006 at 3:58pm
Print Post Print Post  
Quote:
The Cow (Mark),

You must be busy (as always) but I miss seeing this post updated. I know the post sort of morphed into other posts but those seemed to have faded also.

Hope all is well and was just wondering “What are you working on”



Yup, just been too busy to post. Currently I am working on search optimization for relational databases.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: What I'm working on
Reply #26 - Jan 9th, 2006 at 6:56pm
Print Post Print Post  
Just wanted to mention that I've been enjoying this post, as well. As our applications continue to develop, it's great to know where Sesame is headed so we can plan our programming (and prioritize) accordingly.

Not to mention, its fascinating. Please keep up all the hard work Smiley

Steve
  
Back to top
WWW WWW  
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: What I'm working on
Reply #27 - Jan 9th, 2006 at 7:22pm
Print Post Print Post  
I was enjoying the feedback as well.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1 [2] 
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge