Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

PassionjE
2010-04-27 17:02:50

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

shong
2010-04-27 16:29:07

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

PassionjE
2010-04-27 16:01:09

Hello

Good to know it, thanks a lot smile 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 ...

shong
2010-04-27 15:48:38

Hello
It is impossible to update the input file, need to output the result to a new file using tFileOutputExcel component.

Best regards
Shong

PassionjE
2010-04-27 15:03:05

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

shong
2010-04-27 14:57:53

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

PassionjE
2010-04-27 13:32:42

Hello

Btw i simply used the tReplace component, and its works very well big_smile

Still thx for helping smile
NOw i am wondering how to Load the output file in another excel file, or update the input one, any idea ?

PassionjE
2010-04-27 13:03:56

Hello

The format is the good one, String .... But there is still the same error message ....

shong
2010-04-27 12:22:55

Hello
Which error do you get now? This function return string type, you shoud define its type as string, not boolean.

Best regards
Shong

PassionjE
2010-04-27 12:20:38

Thx, i tried but unfortunatly, it return me the same error....

shong
2010-04-27 12:05:56

Hello
try

Code:

row1.phone.replaceAll(" ","")

Best regards
Shong

PassionjE
2010-04-27 09:17:26

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!

shong
2010-04-27 06:03:39

Hello guy
Please post your question in English.wink

Best regards
Shong

FredoJFO
2010-04-27 05:58:02

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.

PassionjE
2010-04-26 16:48:48

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,"","")

Board footer

Powered by FluxBB