Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Lookup for Bank Numbers on Adobe LiveCycle

Avatar

Avatar
Boost 1
Level 1
Ivica1987
Level 1

Like

1 like

Total Posts

27 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
Ivica1987
Level 1

Like

1 like

Total Posts

27 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
Ivica1987
Level 1

29-07-2014

Hello everyone

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.

I appreciate every possible help.

View Entire Topic

Avatar

Avatar
Boost 1
Level 1
Ivica1987
Level 1

Like

1 like

Total Posts

27 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
Ivica1987
Level 1

Like

1 like

Total Posts

27 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
Ivica1987
Level 1

11-08-2014

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.