How can I merge two lines if the line finishes with a certain text or character (e.g., $)?  For example how can I go from   LU039F1R 5298.329, 239.725, 769.615, $     -0.17307, -0.01813, 0.98474 LU039G1L 5309.644, -240.726, 762.655, $     0.99595, -0.07970, -0.04152   to   LU039F1R 5298.329, 239.725, 769.615, -0.17307, -0.01813, 0.98474 LU039G1L 5309.644, -240.726, 762.655,0.99595, -0.07970, -0.04152
How to find multiple blank lines in Notepad++ and join the the separated text lines with a macro?  Below is screenshot of the file, where I want a macro to find out this blank line and correct the SEE and FIGURE should come to one line.
How to identify cells in Column A that contain any of the values in Column B First off, I'm not that advanced of an Excel user. I'm certain Excel can do what I'm about to ask, but I've yet to find a way in any of my attempts or searches.  My question is very similar to  except that A) the answers there didn't work for me, and B) even if it did, it's not quite the correct output I need.   Basically, I have 2 columns. Column A contains URLs (16388 rows). Column B contains URL slugs (202 rows).   I want to search to see if any of the values in column B are contained within any of the values of Column A. If they are, I want to return the value TRUE in column C.   From what I've read, VLOOKUP ought to work for this, but for the life of me I can't get it to work. I also tried in the answers in the link above that use COUNTIF and MATCH, but in both of those cases, all I got were FALSE returns, when I know that there are values in Column B that are contained in a URL in Column A.   Does that make sense?  EDIT: Both answers are providing results (thank you!), but I suspect I may not have asked the question correctly. In both of the answers, I'm getting TRUE results, but it looks like the TRUE is correlating to the slug in Column B rather than the URL in Column A. Let me put it this way:  I'll move the slugs from Column B to C so that B can be used for the TRUE responses. What I want the fomula to do is:   Look at URL in A1 Are any of the values in Column C contained within the URL in A1? If yes, then return TRUE in B1. If FALSE, leave it blank.    So I will be able to see which of the URLs contain the slugs I am searching for. I apologize for not being clearer in my original ask (though I feel like it's only a slight tweak from the answers I've already been given.) Every proper ideal is contained in a maximal ideal, in a commutative ring with identity. The statement is:     In a commutative ring with 1, every proper ideal is contained in a maximal ideal.   and we prove it using Zorn's lemma, that is, $I$ is an ideal, $P=\{I\subset  A\mid A\text{ is an ideal}\} $, then by set inclusion, every totally ordered subset has a bound, then $P$ has a maximal element $M$.  My question is why $M$ must contain $I$? Using $g = \frac{Gm}{r^2}$, the force on a point mass located at 1 AU from the Sun ($m = 2 \cdot 10^{30} \text{ kg}$) is about ~0.006 N/kg.  Does that mean that, e.g., a 70 kg person is ~42g lighter during the day, and ~42g heavier at night? That seems like it could make a big difference for things like measuring gold bars or other weight-sensitive items. (Gold arbitrage: buy your gold during the day and sell it during the night! Risk-free profit!)  This makes me suspect that I'm overlooking something obvious, because a ~0.05% weight difference seems like something everyone would have noticed long ago. So what am I missing?    Edit: A few answers below indicate that there shouldn't be any weight difference, because the Earth orbits the Sun in free-fall. But if that's the reason, does that mean that a 1:1 tidally-locked Earth-Sun system wouldn't experience differential gravity from the Sun on opposite sides? That doesn't seem right. Who owns R2-D2 & C-3PO in the Prequel trilogy? Is there any concrete evidence that Anakin officially owned R2-D2 or C-3PO?  I found this episode of Star Wars: Clone Wars that shows it, but it's fairly vague... Why uniform closure $\mathscr{B}$ of an algebra $\mathscr{A}$ of bounded complex functions is uniformly closed? Let $\mathscr{A}$ be an algebra of bounded complex functions. (Or if necessary, continuous and domain of functions is compact)  Definition:  $\mathscr{B}$ is uniformly closed iff $f\in\mathscr{B}$ whenever $f_n\in \mathscr{B} (n=1,2,\cdot)$ and $f_n\rightarrow f$ uniformly.  $\mathscr{B}$ is the uniform closure of $\mathscr{A}$ iff $\mathscr{B}$ is the set of all functions which are limits of uniformly convergent sequences of members of $\mathscr{A}$.  ============  Let $\mathscr{B}$ be a uniform closure of $\mathscr{A}$.  How do i prove that $\mathscr{B}$ is uniformly closed in ZF?  Does Stone-Weierstrass theorem require choice since it is critical to prove Stone-Weierstrass Theorem? Do characters provoke opportunity attack when they leave another character's reach who is not facing them? "You can make an opportunity attack when a hostile creature that YOU CAN SEE moves out of your reach."   In 5E do you have to specify which way your character is facing at all times?  If an enemy who is behind him leaves melee range but his back is to him does that enemy provoke an opportunity attack?    Are enemies within five feet and 360 degrees of a character considered to be within reach?  For example... Kruska and Atone are attacking Dip.  Dip is facing or only attacking Kruska.    Then Atone moves out of Dip's reach (melee range 5 feet) to engage a silly looking wizard.    Does Atone's move provoke an opportunity attack from Dip even though he's not facing him?  Is he assumed to be able to see him? Using Iterator with ModelBuilder for clipping and splitting in ArcMap? Earth Engine convert list with coordinates and values into a feature collection for export I need to create a feature collection from a list containing coordinates and band values.  These are extracted from a landsat image as shown in this linked script.    I'm unable to find a solution in creating a feature collection.  Here is the tail end code.  var valuesList = joinedImage.reduceRegion({   reducer: ee.Reducer.toList(4),   geometry: myGeometry }).values().get(0);  var feature = ee.Feature(null, valuesList);   // Wrap the Feature in a FeatureCollection for export. var myFeatures = ee.FeatureCollection([feature]);   // Export the image, specifying scale and region. Export.table.toDrive(myFeatures, "data", "myData", "B4-B5",  "CSV");   This doesn't work, because it is clearly the wrong way to create the feature collection.  I've tried to create it similar to Rodrigo E. Principe's solution of mapping a Feature Collection but I can't seem to create the initial feature collection to start with. If $f(x + y) = f(x) + f(y)$ showing that $f(cx) = cf(x)$ holds for rational $c$ For $f:\mathbb{R}^n \to \mathbb{R}^m$, if $f(x + y) = f(x) + f(y)$ for then for rational $c$, how would you show that $f(cx) = cf(x)$ holds?  I tried that for $c = \frac{a}{b}$, $a,b \in \mathbb{Z}$ clearly  $$ f\left(\frac{a}{b}x\right) = f\left(\frac{x}{b}+\dots+\frac{x}{b}\right) = af\left(\frac{x}{b}\right) $$ but I can't seem to finish it, any help? I've seen videos of some folks having several armor sets (4 is the most I've seen so far) standing about on their settlement. I'm wondering if having too many would cause some sets to disappear. They're not like guns/items that you can safely store in settlement crates, the suits kind of just... stand around. (I know there's the extra step of taking out the fusion cores, so that NPC's don't use them.)  Is there a limit to the number of Power Armor sets you can keep? Algorithms for automatic model selection Is it possible to store user's crontab in user's git repository on OpenBSD? On OpenBSD and with OpenBSD's  and , is it possible to store the  of a user in a  repository of the same user?  What would be the proper way to accomplish something like this?  (To steer the answer into the correct direction, I would not be opposed to changing some permissions in the system, although I'd rather not have to recompile the binaries, nor violate any good security paradigms.) Parametric Interpolation of 2D data What should my Objective-C singleton look like? Show bigger amplitude of physical pendulum means bigger period Suppose you have a physical . It is true that as amplitude increases, the period increases. Can we demonstrate this fact without explicitly finding the period (which is pretty involved and pretty messy) in:    an intuitive fashion,  rigorously? Mirror modifier is not working, no mirrored object? I'm learning how to use the mirror modifier and I am having some trouble.  When I apply the modifier to my object I don't see a mirrored version of it.  What am I doing wrong? Should reputation from SO carry over to Meta? How to assign values to a MATLAB matrix on the diagonal? Difference between staticmethod and classmethod Requesting raw data from previously published research