LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Pooja

Hi,

I'm trying to import in some data from a few text files (emails originally) and I've got instances where the same field name is used to show different information. I would like to return all the information into individual columns but can't work out how to extract the information stored along the duplicate field name.

e.g (using the attached example)
aPId = T900Mins:24M
aPId = APPIPH4
aPId = CPW:Sim

The "aPId" field has 3 different values assigned to it which I would like to return in 3 different columns.

Any ideas?

Thanks

Pooja
Attachments:
Example - duplicate column names.txt

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

Pooja, I am not really sure exactly what you mean here. If I look at the data, I think I understand what you might want, and I attached an example to do that.

Also, the data appears to be an excerpt of XML...we have an XML node as of 4.5, which, if you can provide a complete file, would probably be better...but with this file, you could do something like what I attached

Cheers
Rich
Attachments:
Parsing Example.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Pooja

Hi Rich,

Thanks for this - it worked and got the data out. The data's from emails so I'm assuming that I wouldn't be able to use the XML node - is this correct?

Thanks

Pooja

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

probably...you would have to save the emails, extra the data that is XML, make sure it is formed well...yah, you are probably going down the right path.