I am currently separating the line below (read from PDF) by space and use the count function to extract them into different variable (i.e., name, ID, nationality, address,ACRA, Date). However, the name and adress always have different number of index which is causing a lot of trouble.
How can I extract each variable individually?
CHANDRA M PARESH S1234567G SINGAPORE CITIZEN 11 HOLLY CRESCENT ACRA 16/01/1999
LILATI W/O J MANHAN PARESH S1234567B SINGAPORE CITIZEN 11 LUCKY PANDA STREET 2 ACRA 01/01/1910