Hi,
I am struggling with a formula to extract certain parts of a number of long (and messy) text strings.
I need only the bold part of the string below. The strings will be formatted similarly to the one below, however, they may include more or fewer locations and the locations may be called anything imaginable.
The strings are located in column B, and a corresponding company name will be located in column A. Optimally, the output should be something similar to the enclosed picture.
id=1¤office=Location 1¤adress=Test street¤adress2=¤zip=22200¤city=Test 1¤phone=¤country=AA¤latitude=60.1578919¤longitude=19.199143,id=2¤office=Away from home¤adress=Test street, 1.¤adress2=¤zip=88000¤city=Test¤phone=¤country=UK¤latitude=571.0478464¤longitude=92.9220972,id=3¤office=On site¤adress=Street 2¤adress2=¤zip=99000¤city=Testfielder V¤phone=¤country=US¤latitude=51.6724615¤longitude=72.5552772
Thanks!
Bookmarks