Android Question Need help with SMS

[apty]

I am new to basic4android, just bought it today . I need help formating SMS. The sms comes from a specific source e.g. DAILY ALERTS and is in the following format.
QNBX CONFIRMED. You have received USD 45 from abx nyd 458236 on 9/4/14 at 10:10 AMNEW Balance is USD 340.

I want the message to appear as below
ITEMNO AMOUNT USER NUMBER DATETIME BALANCE
QNBX USD 45 abx nyd 458236 9/4/14 10:10AM USD 340

Is this possible with B4a? I want to pick the message immediately it is received and store it in sqlite database. Then display it as above. Kindly help on how i can achieve this. Thanks

 

[Erel]

Intercept the SMS: Intent Filters - Intercepting SMS messages in the background

There is an online regex tool that helps with testing patterns: http://basic4ppc.com:51042/regex_ws/index.html
Try this pattern:

(\w+) .* received (\S+) (\d+) from (\S+) (\S+) (\S+) on (\S+) at (\S+) (\w\w)NEW Balance is (\S+) (\S+)

 

[apty]

Thanks Erel. I have tried using the pattern you have indicated on the tool but it just returns me to initial screen (i.e no changes on output) when i click parse.

 

[Mark Read]

Works for me but not in firefox. Chrome is okay. No socket in Firefox!

 

[Erel]

@apty which browser are you using?

@mark35at you are probably using an old version of Firefox. Version 11+ should work: http://caniuse.com/websockets

 

[apty]

Thanks alot. How do I use the regex command in my application?

 

[Erel]

See the tutorial: Regular expressions tutorial

 

[apty]

Hi Erel,
How did you get the above regex pattern. I am unable to generate patterns using a different string..please tell me what the w,s or d stands for in the pattern

 

[Erel]

You should learn regular expressions: http://www.regular-expressions.info/

 

[apty]

i got the pattern correct (using the online tool) but when i copy the same to basic4android, it doesn't give me any results..just a blank listview

smsbody=Sms1.Body
        smsaddress=Sms1.Address
        If smsbody.Contains("received") Then
        Dim matcher1 As Matcher
matcher1 = Regex.Matcher("(\w+).*received usd(\S+) from(\S+) (\S+) (\S+)on (\S+) at (\S+) (\S+)New balance is usd(\S+).xxx", smsbody)
If matcher1.Find = True Then
  ' Log(matcher1.Match)
  Dim receiptno, firstname,lastname,phoneno,date,time,time2,strdate As String
  Dim amount,Balance As Int
        receiptno = matcher1.Group(1) 'fetch the first captured group.
        amount = matcher1.Group(2)
        ListView1.AddSingleLine (receiptno)
        ListView1.AddSingleLine(smsaddress)

This gives me blank listview, but it works if i dont use the regex function. What am i doing wrong?

 

[DonManfred]

what is the content of smsbody? log(smsbody)

 

[apty]

the content is

bxd Confirmation. You have received usd50.00 fromHulk Juin xyzcc on 9/4/14 at 10:53 AMNew balance is usd50.00.xxx

 

[apty]

is it possible to run regex on a database ? i.e in a select query?

 

[apty]

Please help..how can I run regex on db?

 

[mitobobo]

Dim m As Matcher = Regex.Matcher("(\w+) .* received (\S+) (\d+) from (\S+) (\S+) (\S+) on (\S+) at (\S+) (\w\w)NEW Balance is (\S+) (\S+)", smsbody)
If matcher1.Find = True Then
receiptno = Matcher.Group(1)
amount = Matcher.Group(2)
End If

QNBX CONFIRMED. You have received USD 45 from abx nyd 458236 on 9/4/14 at 10:10 AMNEW Balance is USD 340.

What does "xxx" stand for? Currency(EUR, USD, ...)?

 

[Erel]

Please help..how can I run regex on db?

You cannot. SQL doesn't support regular expressions. You will need to go over all the records and check each one.