On a PDF form for Personal Data I want from the field Bank Account Nr. to automatically pull out the Number of the Bank. The problem is that there are nearly 8000 Bank Numbers for Switzerland. The idea is from the Bank Account Number to pull out the Search Number and from that Search Number to pull out the corresponding Bank Number. Here is a fictional example:
Bank Account Number: CH5809000000803940838.
Search Number: 09000 . It pulls out the first 5 characters from the fifth character (when multiplied with 1 I get the search number 9000).
Bank Number: 90000000 (the corresponding Bank Number for 9000)
The problem is that for some Search Number the corresponding Bank Number is completely different (example: Search Number equals 6368 but the actual Bank Number is 895425)
My PDF Form has already a Data Connection with a xsd file to generate other Personal Data fields. I know that is possible to generate the condition with a very large if statement (with thousands of if statementsfor every Bank Number) but is there maybe a simpler solution. Maybe a smaller java script formula or something similar.
My company needs this PDF Form because we want to export the data in XML.
Thank you for your reply but I already found a method using a very large if expression that I made in Excel. The main Problem was that Switzerland has around 8000 Bank Numbers and we needed to find the Bank Numbers from the Bank Account Nr. of a person. I found a method to create a large if expression using the list of Bank Numbers made in Excel.
Could the problem lie in the data you have? Does that entry where you're seeing ZZ9906368... actually need to have ZZ990895425... or something like that?
How long are the bank numbers supposed to be? You've got an example with a nine digit number and an example with a six digit number. In the US, for example, all routing numbers are guaranteed to be nine digits. So, if you give a similar set of strings like your post suggests you have, I know that I can slice a string at the same place each time to get the routing number. E.g., nfRoutingNumber.slice(5,13) would give me the routing number without having to do any extra searches. Are you able to do that? Or are the numbers you're searching for going to get you do a different number that might be a different length?