Request help for Cell Splitter Node

I have 100 lines items in two different file, i have to do validation if both files columns data are matching correctly based on the Employee ID , but we have one catch is File A multiple columns like Employee ID, Country, Zip code etc however File B has only one column which consist all the above columns data in one cell itself , so now we have to split the cell in B file and compare all columns of A file with B file, please suggest node and its steps to resolve this. The format of B file cells for each employees like below

"XXXXXXXXXXXX (XXX-XXX)

XXXXXXXXXXXX (XXX-XXX)

XXXX XXXX XXXX (XXX-XXX)

XXXXXXXXXX (XXX-XXX)

XX/XXX/XXXX/XXXXXX (XXX-XXXX)"