Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

num# on strings containing letters?

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

1 Solution

Accepted Solutions
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Friedrich,

Yes, It consider as string only.

Thanks

Arvind Patil

View solution in original post

2 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Friedrich,

Yes, It consider as string only.

Thanks

Arvind Patil

datanibbler
Champion
Champion
Author

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!