I have data in the .txt file as: VALUE ADM_LN2G 1 = 'ENGLISH' 2 = 'FRENCH' 3 = 'ARABIC' 4 = 'CHINESE' 5 = 'CREE' 6 = 'GERMAN' 7 = 'GREEK' ; VALUE ADM_LNG 24 = 'INUKTITUT' 90 = 'OTHER' 96 = 'NOT APPLICABLE' 97 = 'DON''T KNOW' 98 = 'REFUSAL' 99 = 'NOT STATED' ; . . . I want to separate out each value in different dataset. Output expected: Dataset 1 : ADM_LN2G VALUE ADM_LN2G 1 = 'ENGLISH' 2 = 'FRENCH' 3 = 'ARABIC' 4 = 'CHINESE' 5 = 'CREE' 6 = 'GERMAN' 7 = 'GREEK' ; Dataset 2: ADM_LNG VALUE ADM_LNG 24 = 'INUKTITUT' 90 = 'OTHER' 96 = 'NOT APPLICABLE' 97 = 'DON''T KNOW' 98 = 'REFUSAL' 99 = 'NOT STATED' ; etc.. For every VALUE there is ";" at the end. Please help. Thanks in advance!!
... View more