Hello!
There's a thing i need to do. I have many text files of the same format in a folder. Each file's content form is same as following:
Code:
formfieldq1=formfieldq1_office2007
formfieldq2=formfieldq2_201205
formfieldq3=formfieldq3_yes
formfieldq4=formfieldq5=formfieldq5_bup1
formfieldq5_usefulness=formfieldq5_veryuseful
Ok=Ok
but if i import the file this way it is no use. Firstly, SOMEHOW, i need to convert this format into the following
Code:
office2007 201205 yes bup1 veryuseful
reason is that when each word i need is in another line, when i import they belong to same column. Instead they should belong to different columns.
Secondly, I wish to remove the unneccesary strings from the text.
Using what can I do this? Thank you