Complex Concatenation & Text Parsin

[currybai]

Hi,

I usually have a formula to extract text but it's given that all the text have the same amount of rows. I have a file that's 3K rows and they're uneven rows. For example I have the following, each line is 1 row.

ID: 123456

Company: Example

Campaign: Sample 1234

Campaign ID: 123568

Site: Yahoo.com

Placement Name: Sample_placement

Line Item Name: Boots123

Placement Format Type: Rectangle

Size: 300x600

Booked Units: Unlimited

Placement Dates:

1/1/2017 12:00:00 AM - 1/31/2017 11:59:00 PM

******** src="https://123123.com/asdlkhasdkjhasdkjhaslkjh>*********>

<noscript>

<a href="https://123123.com/asdlkhasdkjhasdkjhaslkjh></a>

</noscript>

====================================================

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

Some ranges will have an extra or 2 rows in between

1/1/2017 12:00:00 AM - 1/31/2017 11:59:00 PM

********> car asdsdasda

******** src="https://123123.com/asdlkhasdkjhasdkjhaslkjh>*********> I need to extract the Placement Name after the : and the range of cells after the date and time and before the ====== in 2 columns. All the ranges follow this logic. So essentially it will look like: Sample_placement Sample_placement ******** src="https://123123.com/asdlkhasdkjhasdkjhaslkjh>*********><noscript><a href="https://123123.com/asdlkhasdkjhasdkjhaslkjh></a></noscript> Any help is appreciated! <tbody> </tbody>

<tbody>
</tbody>

 

[hiker95]

currybai,

We can not tell where your raw data is located, sheet name, cells, cell formatting, rows, columns, and, we can not tell where the results should be, sheet name, cells, cell formatting, rows, columns.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[currybai]

currybai,

We can not tell where your raw data is located, sheet name, cells, cell formatting, rows, columns, and, we can not tell where the results should be, sheet name, cells, cell formatting, rows, columns.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

Attached here. Thanks!

https://wetransfer.com/downloads/d5...902f41bf3b60ed5fa4e30f0320170116160036/291c8c

 

[hiker95]

Attached here. Thanks!

https://wetransfer.com/downloads/d5d...6160036/291c8c

currybai,

I have no experience with the above link.


Please post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com


If you are not able to use the above link, then:

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[currybai]

currybai,

I have no experience with the above link.


Please post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com


If you are not able to use the above link, then:

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

Sorry

https://www.dropbox.com/s/0c0u9pqi1tgrz5f/dgsfdgsf.xlsx?dl=0

 

[hiker95]

currybai,

Thanks for the new workbook.

I will need another workbook, with Sheet1 containing more then one group of raw data information.

And, on another worksheet, the results, manually formatted by you, for the results you are looking for.