I'm building an LCD display test harness on a perf board. I'm looking for a solution for connecting an 14 pin FPC/FFC cable to a 2.54mm perf board. Unfortunately, even with a digital caliper, it's very hard to measure the precise pitch of the cable. A quick search lead me to an article titled How to know the Pitch of FPC /FFC Ribbon Cable?, which explains an easier method for finding the pitch.
I measured the width of the cable several times with two slightly different results, 18.8mm and 18.7mm. I divided each by 15 (14 conductors + 1), giving me 1.2466mm (18.7mm width) and 1.25333mm (18.8mm width). Presumably, the pitch is 1.25mm since the article mentions it's a standard FFC/FPC pitch.
However, I'm thoroughly confused when trying to find a suitable connector. Using a pin header as a gauge, the existing connector's PCB footprint is 2.54mm with the second row of holes shifted over by what looks to be half the pitch or 1.27mm, not necessarily 1.25mm I calculated for the cable. I searched for more information and found a DigiKey article. The formula for calculating the pitch doesn't add 1 to the number of conductors which results in around 1.31 which is way off.
Is the pitch of the PCB connector different from the pitch of the cable? Am I dealing with an odd ball connection, or am I measuring incorrectly? How do I determine the pitch of the cable and the connector's footprint? Moreover, is it even possible to adapt a FPC to an IDC connector?
ASIDE: As a software engineer, I'm a bit puzzled by this experience. I always worshipped real engineers for their precision, consistency, and clarity when it comes to specifications and documentation.