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:
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/3549e19b3ab14f7dbcc5500f9aa9ca67%40masse-charpente.fr
<https://groups.google.com/d/msgid/rbase-l/3549e19b3ab14f7dbcc5500f9aa9ca67%40masse-charpente.fr?utm_medium=email&utm_source=footer>.
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/00a0f327-b8bb-e76d-7a4f-bc96a548c235%40wi.rr.com.
