I have 70,000 records with various information fields. The requirement is from the Vendor field, if there is an alphanumeric value then set Field A to 1 else to 0
Example
Name Field A
AB1000 Abhijeet Company AB - 1
CD2000 Abhijeet Company AB - 1
EF3000 Abhijeet Company AB - 1
AB1234 Abhijeet Business AB - 1
AB01 Abhijeet Games - 1
IT2658 Abhijeet Company AB - 1
123456 Abhijeet Company AB - 0
45 Abhijeet Company - 0
Hope i am making sense here. Appreciate any advise here.
Solved! Go to Solution.
Happy to help : ) @Abhii2658
Cheers and have a nice day!