Forum Discussion
Gopal_Gope
Aug 23, 2023Copper Contributor
All Versions Formulas and Functions
Hi, Request your support in identifying a formula which i used to extract Pin code formula used by me is only capturing the pincode, however, it fails to capture pincode with spaces and mobile num...
HansVogelaar
Aug 24, 2023MVP
Examples 1), 2) and 3) contain the word PIN. This might help us to find the pin code.
But example 4) does not contain the word PIN. What is the pin code in this example?
- Gopal_GopeAug 24, 2023Copper Contributor
HansVogelaar
Hi,
The first one is right he what the formula should return here is PIN is 676305
The second one is right he what the formula should return here is PIN is 671541 if you prefer
The four is right he what the formula should return here is blank
blank should come because there is no 6 digit number in this column
I hope you have understand- HansVogelaarAug 24, 2023MVP
Your formula doesn't work at all, since it contains "curly" quotes instead of straight quotes.
But what should the PIN in example 4 be?
- Gopal_GopeAug 24, 2023Copper ContributorHi,
we are not talking about in pin them we have to discuss about India Post office pin code number request your support in identifying a formula which will 6 digit capture pin code with spaces and mobile number pin code not with spaces irrespective wherever they are in the address column
What are you asking us, we are unable to understand your question???
Thanks