yucatan Posted October 20, 2009 Share Posted October 20, 2009 hello guys i have a question how should i check if the first char in my string is a numeric? Link to comment Share on other sites More sharing options...
water Posted October 20, 2009 Share Posted October 20, 2009 (edited) If StringIsInt(StringLeft("Your String",1)) Then MsgBox(0,"","Numeric!") Else MsgBox(0,"","Not Numeric!") EndIf Edited October 20, 2009 by water My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
yucatan Posted October 22, 2009 Author Share Posted October 22, 2009 If StringIsInt(StringLeft("Your String",1)) Then MsgBox(0,"","Numeric!") Else MsgBox(0,"","Not Numeric!") EndIf hello guys i have a string and the string is this " 5275648 63% 4.97MB/s 0:00:00" i have a loop running providing me alot of that strings what i want to do is if the string is " 5275648 63% 4.97MB/s 0:00:00" i wanne change it in this"5275648 63% 4.97MB/s 0:00:00" so i wanne remove all the spacebars at the left of the string can somebody help me on this thx Link to comment Share on other sites More sharing options...
jvanegmond Posted October 22, 2009 Share Posted October 22, 2009 hello guys i have a string and the string is this " 5275648 63% 4.97MB/s 0:00:00" i have a loop running providing me alot of that strings what i want to do is if the string is " 5275648 63% 4.97MB/s 0:00:00" i wanne change it in this"5275648 63% 4.97MB/s 0:00:00" so i wanne remove all the spacebars at the left of the string can somebody help me on this thx StringStripWS (Click for docs) github.com/jvanegmond Link to comment Share on other sites More sharing options...
yucatan Posted October 22, 2009 Author Share Posted October 22, 2009 thanks u very much manadar Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now