maillist@pvxplus.com

Message: previous - next
Month: January 2002

RE: [Pvx] Show part of string in Query

From: Ken Sproul <ksproul@...>
Date: Thu, 24 Jan 2002 21:04:33 -0500
Another great way to use MID to get the last four characters is
MID(YOURFIELD$,-4).

Ken Sproul
Softcare Computer Consulting Co. - Programmer/Analyst
ksproul@...


-----Original Message-----
From: Francisco Gutierrez [mailto:aspica@...]
Sent: Thursday, January 24, 2002 9:07 PM
To: providex@...
Subject: Re: [Pvx] Show part of string in Query


Jane, thanks a lot...

Francisco
Valencia - Venezuela
----- Original Message -----
From: "Jane Raymond @ home" <jane.raymond@...>
To: <providex@...>
Sent: Thursday, January 24, 2002 10:00 PM
Subject: Re: [Pvx] Show part of string in Query


> Francisco,
>
> When you define the columns in your query, press the 'Add Formula' button
> and enter an expression such as MID(YOURFIELD$,4) in the Formula
multiline.
> This should display from the fourth character to the end (i.e. the last
> four).  Using the MID() function is safer that using the substring
> (YOURFIELD$(4) for example) as you won't get an error if the string is
less
> than four characters long.
>
> Jane Raymond <jane.raymond@...>
> Best Software Canada Ltd. (Providex)
> Tel. 905-470-1024 x224
>
> ----- Original Message -----
> From: "Francisco Gutierrez" <aspica@...>
> To: <providex@...>
> Sent: Thursday, January 24, 2002 7:43 PM
> Subject: [Pvx] Show part of string in Query
>
>
> Hi list,
>
> How can i show part of string in a query, this field have sevent (7) pos
and
> i need to show only the four (4) last pos.
>
> Any help is welcome
>
> Thanks
>
> Francisco Gutierrez
> Valencia - Venezuela
>
>
>
> To unsubscribe, e-mail: providex-unsubscribe@...
> For additional commands, e-mail: providex-help@...
>


To unsubscribe, e-mail: providex-unsubscribe@...
For additional commands, e-mail: providex-help@...