There doesn't seem to be a built in function for extracting characters from a string based on their position in a string (1st, 2nd, 3rd).

actually there is such a built in function, look for substring(<s.index>, <e.index>) at

http://help.creator.zoho.com/Built-in-Functions.html#String_functions

If you have problems using this function, maybe a helpful thing would be to search for substring in this Zoho Creator forum - these problems were debated here months ago.

Regards,
George

 Hi,

It is possible to create a clean unpunctuated number from formatted phone number using the Built-in-Functions(getAllAlphaNumeric() and removeAllAlpha()).

I have created a sample application and it is available here .

Following is the code snippet used

 string getCleanNum(string num)
{
    input.num = input.num.getAlphaNumeric();
    input.num = input.num.removeAllAlpha();
    return input.num;
}

Thanks,
Nandhini P

Hi Nandhini,

stressrecess:

I am assuming that after you have something like "abcdefghi" in a (string) variable ... you want to know how to transform it into something else like "abc-de-fghi".

If so, start here ... http://help.creator.zoho.com/Built-in-Functions.html ... under the section titled String Functions, look at ...

a) <string1>.substring(<s.index>, <e.index>) ... read the Description for this built-in function very carefully ... as ZOHO Creator has a unique method for specifying the starting and ending position values ... you might even consider whipping up a Stateless Form with 4 fields ... source, start position, end position and result ... and observe ZOHO Creator's behaviour for the various combinations ... that was how I learned about its quirky behaviour.

b) <string>.length() ... because ZOHO creator is unforgiving when you specify values beyond the length of a string.


Gaev