Doug: once you know the trick of replacing spaces with commas and doing an "item count", isn't it crazy how many uses that has? I just had to use this technique again this week.
Karen -----Original Message----- From: Doug Hamilton <[email protected]> To: [email protected] Sent: Fri, Jan 28, 2022 4:54 am Subject: Re: [RBASE-L] - Extraction de données / Data Extraction Bonjour Jean-Marc. CLS SET VAR vadrchant TEXT = + 'Mobil Home Rideau 12 Parc de la Landette 85190 VENANSAULT' SET VAR vadrchant2 = (SRPL(.vadrchant,' ',',',0)) SET VAR vCount = (ITEMCNT(.vadrchant2)) SHOW VAR vadr% SHOW VAR vCount SET VAR vadrpostcode = (SSUB(.vadrchant2,(.vCount - 1))) SET VAR vadrcity = (SSUB(.vadrchant2,.vCount)) SHOW VAR vadr% RETURN Doug On 1/28/2022 2:37 AM, Jean-Marc Massé wrote: _filtered {} _filtered {}#yiv9426004986 p.yiv9426004986MsoNormal, #yiv9426004986 li.yiv9426004986MsoNormal, #yiv9426004986 div.yiv9426004986MsoNormal {margin:0cm;font-size:11.0pt;font-family:sans-serif;}#yiv9426004986 span.yiv9426004986EmailStyle20 {font-family:sans-serif;color:windowtext;}#yiv9426004986 .yiv9426004986MsoChpDefault {font-family:sans-serif;}#yiv9426004986 div.yiv9426004986WordSection1 {} Bonjour à tous, Dans une table de coordonnées de clients j’ai un champ NOTE « ADRCHANT » dans lequel figure l’adresse complète du client comme la variable jointe SET VAR VADRCHANT TEXT = "Mobil Home Rideau 12 Parc de la Landette 85190 VENANSAULT" Pourriez vous me dire comment on peut extraire d’un coté le code postal « 85190 » dans une variable distincte Et d’autre part la ville « VENANSAULT » dans une autre variable ? Merci d’avance pour votre aide ! Traduction Google : Hello everyone, In a table of customer details I have a field NOTE "ADRCHANT" in which appears the complete address of the customer as the attached variable SET VAR VADRCHANT TEXT = "Mobile Home Rideau 12 Parc de la Landette 85190 VENANSAULT" Could you tell me how we can extract on one side the postal code "85190" in a separate variable And on the other hand the city "VENANSAULT" in another variable? Thank you in advance for your help ! Best regards, Jean-Marc Massé (mobile : 06.08.82.80.86) Sté MCS 85510 ROCHETREJOUX (France) -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/3549e19b3ab14f7dbcc5500f9aa9ca67%40masse-charpente.fr. | | This email has been checked for viruses by Avast antivirus software. www.avast.com | -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/00a0f327-b8bb-e76d-7a4f-bc96a548c235%40wi.rr.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/682475445.2590698.1643395651814%40mail.yahoo.com.
