Methods StrReplace, Left, Right in query

Common questions about 1C:Query language, Query builder tool and Data composition schema

#1
People who like this:0Yes/0No
Interested
Rating: 27
Joined: Apr 5, 2012
Company: 1TÇ Şirketi - Merv Bilgi İşlem Otomasyonu Yazılım Ltd. Şti.

Hi is there way to use StrReplace, Left, Right methods in Query?

I have records (type string) as:
+90 (534) 079 34 01
(534) 079-34-01
(534) 079-3401
5340793401
0534 079 34 01
+905340793401

So after executing query it's yet to get "5340793401".

I should use it in query caurse the number of records are very much (It will took more seconds if I will iterate the query results and convert those records by using usual mothods in script). So I need to use those methods in query.

 
#2
People who like this:1Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

String operators are very limited in 1C:Query language.
It is recommended to add an additional field that should be recalculated when you save an object if the phone field was changed.

 
#3
People who like this:0Yes/0No
Interested
Rating: 27
Joined: Apr 5, 2012
Company: 1TÇ Şirketi - Merv Bilgi İşlem Otomasyonu Yazılım Ltd. Şti.

I see. thanks

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.