help on a requirement.

Hi all,

We have a situation where a flat file looks somewhat like the following:

name,age

city,country

id,number

dept,wing

now in the flat file the input may vary as shown below....

name,age

city,country

id,number

dept,wing

name1,age1

city1,country1

id1,number1

dept1,wing1

or

name,age

city,country

id,number

dept,wing

name1,age1

city1,country1

name2,age2

city2,country2

or

id,number

dept,wing

id1,number1

dept1,wing1

name,age

city,country

or

name,age

city,country

name1,age1

city1,country1

or

id,number

dept,wing

id1,number1

dept1,wing1

hence in short 😉 the (name,age) will always be folllowed by (city,country) and (id,number) by (dept,wing) but the combinations occur in random ie name,age & city,country may come before the id,number & dept,wing or vice versa.

how do we go about in such a scenario.

regards,

ShabZ