num# on strings containing letters?

[datanibbler]

Hi,

sorry, this is a somewhat stupid question and I think I know the answer - only I'm in a hurry and I don't want to realize lateron that there is another exception I haven't thought of, so I'd like this confirmed by one of you please:

I can safely apply the num# function to strings, no? - strings containing only numbers will then be interpreted as a numeric value, but strings containing at least one letter (like >> 04361E91 <<) will just be left as they are.

Right?

Thanks a lot!

Best regards,

DataNibbler

[arvind_patil · Accepted solution]

Hi Friedrich,

Yes, It consider as string only.

Thanks

Arvind Patil

[datanibbler]

Thanks!

Yes, I'm a bit further now, checking at every step and it seems that, although the data comes from excel and even the numbers come as strings, now they are numeric  - only when they contain letters, they remain Strings. That is important because I have to merge that data with data coming from SAP which delivers customer_numbers as numeric values only - currently there are none in there containing letters. With the formats differing, there was the issue that the numeric version was linked only to certain CompanyCodes (Bukrs from SAP) and the text version only was linked to the CompanyCodes coming from the Excel - and some customers are both here and there, so there should be only one version of their number - and since I cannot just change things coming from SAP, not in the short run anyway, I now try this way.

Thanks a lot again!