Mike, How is the number and street name made up?
19, Broad Street -- ie: a comma 19 Broad Street -- ie: just a space Some other format? Is it consistent? You can use SSUB to split on either a comma or a space... Or SLOC to find the position of either then SGET to extract what you need... One other thought: does it matter to you if the same street name happens to be in more than one city? Or if there are street names like "Broad Street" and "Old Broad Street"? Regards, Alastair. ----- Original Message ----- From: mike epstein sony viao office To: RBASE-L Mailing List Sent: Saturday, May 16, 2009 5:14 PM Subject: [RBASE-L] - Re: removing blank spaces from text field Alastair I did remember the ltrim function just prior to getting your response . The problem I was trying to solve is that the variable nvadd4 is a street name that I am using to get the value of the 'city' name in the same table, so I 'select city into vcity from customer where address contains .nvadd4' nvadd4 is the street name without the numerice part of the address It will not return the variable 'vcity' because of the space between the actual street name and the suffix 'rd'. Would you have any comments , I have tried like, .vnvaddd4*, nvadd4% Mike From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr Sent: Saturday, May 16, 2009 10:29 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: removing blank spaces from text field LTRIM removes leading blanks. Regards, Alastair. ----- Original Message ----- From: mike epstein sony viao office To: RBASE-L Mailing List Sent: Saturday, May 16, 2009 4:09 PM Subject: [RBASE-L] - removing blank spaces from text field Good morning I have done this before but can't remember how. This function set var nvadd4 text =(SSTRIP(.vadd4,'' '1234567890')) returns a value that has a blank or null space as its first character .How would one remove it . ---------------------------------------------------------------------------- No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.325 / Virus Database: 270.12.32/2117 - Release Date: 05/15/09 17:55:00 ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.325 / Virus Database: 270.12.32/2117 - Release Date: 05/15/09 17:55:00
