You are not logged in.
Announcement
Unanswered posts
|
Hello
Here is on X the first 2 number of postal code, on Y the 4 first number of phone number, this table show the matching pattern with yellow point.
http://www.el-annuaire.com/numero-tel-en-01.php
Thx
regards.
PassionjE
Hello
About the matching between phone number and postal code, it is possible to write some rules or relationships between number and postal code on a file?
Best regards
Shong
Hello
Good to know it, thanks a lot
Ok now i am still looking for a solution to test the matching between phone number and postal code, sounds like i have to create my own routine ... But i dont know anything about java ...
Hello
It is impossible to update the input file, need to output the result to a new file using tFileOutputExcel component.
Best regards
Shong
Hello
To be honnest i deleted this job when i found the tReplace component and did a new one wich works pretty good.
For the excel problem, i want to update the inputfile with the output one,i mean, i modified the phone number, so i want remove the old one and put those on the input excel.. Hope i am clear ~
Regards
Steph
Hello
The format is the good one, String .... But there is still the same error message ....
What's the error message? Can you upload some screenshots of your job? I think it is a easy fixed problem.
NOw i am wondering how to Load the output file in another excel file, or update the input one, any idea ?
Do you want to output the same result to different files at one time? If so, you can use tReplicate to replicate a row many times as need.
Best regards
Shong
Hello
Btw i simply used the tReplace component, and its works very well ![]()
Still thx for helping
NOw i am wondering how to Load the output file in another excel file, or update the input one, any idea ?
Hello
The format is the good one, String .... But there is still the same error message ....
Hello
Which error do you get now? This function return string type, you shoud define its type as string, not boolean.
Best regards
Shong
Thx, i tried but unfortunatly, it return me the same error....
Hello
try
row1.phone.replaceAll(" ","")Best regards
Shong
I would like to delete all the spaces in a phone number field xx xx xx xx xx => xxxxxxxxxx
I 'm trying to use the stringhandling.Change() function, as the FTRIM or TRIM function, but all return the same error after compilating:
"Cannot convert from string to boolean"
"This function isnt working with arguments such as (string, string,string)...
I already forced the output variable as boolean, but it does not change anything ...
Thx for helping, have good day!
Hello guy
Please post your question in English.![]()
Best regards
Shong
Bonjour,
Déjà dans un premier temps, dans la fonction StringHandling.CHANGE(row1.Telephone_contact,"",""), je ne vois pas où tu remplaces les blancs par du vide ? Ce ne serait pas plutôt StringHandling.CHANGE(row1.Telephone_contact," ","") pour être plus correct ?
En outre il existe aussi la méthode StringHandling.TRIM() qui semble enlever automatiquement les espaces. Après je ne sais pas si elle n'enlève que ce en début ou fin de chaîne, mais à essayer.
Concernant le booléen ça doit être le format attendu en sortie qui est mal configuré. Actuellement il doit attendre un booléen.
Bonjour, je voudrais supprimé les espaces dans des numeros de téléphones et les remplacés par rien du tout, cependant lorsque je compile, j'ai cette erreur:
"Impossible de convertir de String à Boolean", je ne comprends pas comment faire car les numéro de téléphone sont bien des string .... aurait - il une autre fonciton utilisable ?
voici mon code:
StringHandling.CHANGE(row1.Telephone_contact,"","")