Complex Concatenation & Text Parsin

currybai

Board Regular
Joined
Jul 14, 2008
Messages
202
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>
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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

Board Regular
Joined
Jul 14, 2008
Messages
202
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

Well-known Member
Joined
Apr 8, 2009
Messages
17,649

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

Board Regular
Joined
Jul 14, 2008
Messages
202
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

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,317
Messages
5,600,915
Members
414,416
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top