Blue Eye Logo

Blue Eye Macro

Automation is freedom
It is currently Sat Dec 15, 2018 4:44 pm

All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: need help in checking for letters in numbers
Thanked: 0 time(s)  Unread post Posted: Tue Jul 31, 2018 1:30 pm 
New User
New User



Joined: Fri Jun 22, 2018 2:34 am
Posts: 3
Been thanked: 0 time(s)
Has thanked: 0 time(s)
Contribution Points: 13
Hi All,

i need your help in configuring my macro. so i'm currently doing data migration from excel to a different program so basically i am just copy pasting everything from point to point.

so im basically looking for 11 digit numbers only. what i want to do in macro is if the digit is less/more than 11 it will tell me other than that i want to know as well if it has a combination of letters and numbers.

what im doing now is it just copy paste everything and at the end of the migration it will say that cannot register as invalid number.


Top
 Profile  
Reply with quote  
 Post subject: Re: need help in checking for letters in numbers
Thanked: 0 time(s)  Unread post Posted: Wed Aug 01, 2018 1:56 am 
Partner / License admin
Partner / License admin
User avatar



Joined: Sun Oct 10, 2010 5:16 pm
Posts: 1840
Location: USA
Been thanked: 393 time(s)
Has thanked: 33 time(s)
Contribution Points: 16377
You should use regex for this; the regex instructions are under "file" in the documentation pages: viewforum.php?f=163

Depending on what program you are copying over to...I would probably copy it to a text file first, then use regex to provide the answers you are asking about. You can use a regular expression (regex) to count the number of lines, count how many have 11 digits, how many contain letters/numbers, and/or have it do it individually as you paste each line (have BEM paste each line).

You can do a forum search for regex to see some examples; also, getting a program like "regex buddy" will help you in writing the regular expressions or internet search for "regex 11 digit number" and the other expressions you were asking about.

Give it a try and let us know if you have more questions.

Here's an example:


Attachments:
Capture1.PNG
Capture1.PNG [ 28.38 KiB | Viewed 173 times ]

_________________
----------------------------------------Syrifina---------------------------------------------------
PM me for licenses and/or licensing information: Click Here
[Be sure to include and update your profile with your BE ID]

Forum Rules
Reminder of rules regarding Contribution points
Getting started in 1, 2, 3
Virtual Drivers; Manual Installers
Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC


You cannot post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  


Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group