Download the free trial version
Basic4android Video
Features
Tutorials and manuals
Showcase
Screenshots

Go Back   Android Development Forum - Basic4android > Basic4ppc (Windows Mobile) > Questions (Windows Mobile)
Documentation Wiki Register Members List B4P Search Today's Posts Mark Forums Read

Questions (Windows Mobile) Post any question regarding Basic4ppc.

Remove None-Numeric strings from Table

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 08-24-2009, 05:25 PM
linum's Avatar
Senior Member
 
Join Date: Sep 2008
Posts: 108
Default Remove None-Numeric strings from Table

Can somebody please help me. I'm trying to analyze a table and automatically delete all rows that are not numbers and leave only the rows that are numbers.

For example, my table might have the following data:

25
38
16
dgfdgafd
78
ukjdhg
12

How can I automatically delete "dgfdgafd" and "ukjdhg" from this example? I know I can loop through the table but I don't know what else to do.

Thanks for your help...
Reply With Quote
  #2 (permalink)  
Old 08-24-2009, 06:02 PM
agraham's Avatar
Basic4ppc Expert
 
Join Date: Jul 2007
Location: Cheshire, UK
Posts: 6,072
Awards Showcase
Innovator medal Beta Tester Forum Contributer 
Total Awards: 3
Default

Try looping backwards through the table (otherwise you will cut the branch between yourself and the tree ), check the cell contents on each row with IsNumber (Help-> Main Help-> Keywords-> String) and delete the row if it isn't.
__________________
Sorry, but I don't answer questions by PM or email.
Please post your queries in the forum.
Reply With Quote
  #3 (permalink)  
Old 08-24-2009, 07:31 PM
linum's Avatar
Senior Member
 
Join Date: Sep 2008
Posts: 108
Default

I found that I can use isNumber in my loop. I was able to do what I needed using isNumber.

Thanks to all...
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
TableSort, there's a way to remove a Sort in a table? ghale Questions (Windows Mobile) 6 07-30-2009 09:25 AM
Need to look look at Character instead of Strings apstrojny2 Questions (Windows Mobile) 3 05-19-2009 05:21 PM
Numeric Keypad conniemalan Questions (Windows Mobile) 3 11-24-2008 07:29 AM
Trim Spaces from Beginning and end of Strings BPak Questions (Windows Mobile) 21 03-24-2008 06:51 PM
Externalization of strings for localisation Tirs Questions (Windows Mobile) 2 05-29-2007 10:19 PM


All times are GMT. The time now is 10:23 AM.


Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0