userxyz777
New Member
- Joined
- Apr 12, 2018
- Messages
- 15
Hello everyone,
I have a find place problem I do not have the skills to solve
I want to replace all the commas + space ", " with a pipe |
I have some column data in a sheet called Have that looks like the following, where "one" is the column header
In a sheet called FindReplace, I have replacement values for column one in Have sheet
After find/Replace is ran I need column "one" to be
But I can not figure out how to manage the edge cases where replace value can be a substring of a different replace value like "aa2, aa3|aa1"
Thanks for help on this
I have a find place problem I do not have the skills to solve
I want to replace all the commas + space ", " with a pipe |
I have some column data in a sheet called Have that looks like the following, where "one" is the column header
Code:
[TABLE="width: 186"]
<tbody>[TR]
[TD]one[/TD]
[/TR]
[TR]
[TD]aa2[/TD]
[/TR]
[TR]
[TD]aa3, aa1, aa5[/TD]
[/TR]
[TR]
[TD]aa1, aa2[/TD]
[/TR]
[TR]
[TD]aa3, aa1, aa5[/TD]
[/TR]
[TR]
[TD]aa4[/TD]
[/TR]
[TR]
[TD]aa1, aa2[/TD]
[/TR]
[TR]
[TD]aa2, aa3, aa1[/TD]
[/TR]
[TR]
[TD]aa2, aa3, aa2[/TD]
[/TR]
[TR]
[TD]aa1[/TD]
[/TR]
</tbody>[/TABLE]
In a sheet called FindReplace, I have replacement values for column one in Have sheet
Code:
[TABLE="width: 141"]
<tbody>[TR]
[TD]one[/TD]
[/TR]
[TR]
[TD]aa2, aa3[/TD]
[/TR]
[TR]
[TD]aa1[/TD]
[/TR]
[TR]
[TD]aa2[/TD]
[/TR]
[TR]
[TD]aa3[/TD]
[/TR]
[TR]
[TD]aa4[/TD]
[/TR]
[TR]
[TD]aa5[/TD]
[/TR]
</tbody>[/TABLE]
After find/Replace is ran I need column "one" to be
Code:
[TABLE="width: 167"]
<tbody>[TR]
[TD="class: xl66, width: 167"]one[/TD]
[/TR]
[TR]
[TD="class: xl66"]aa2[/TD]
[/TR]
[TR]
[TD="class: xl66"]aa3|aa1|aa5[/TD]
[/TR]
[TR]
[TD="class: xl66"]aa1|aa2[/TD]
[/TR]
[TR]
[TD="class: xl66"]aa3|aa1|aa5[/TD]
[/TR]
[TR]
[TD="class: xl66"]aa4[/TD]
[/TR]
[TR]
[TD="class: xl66"]aa1|aa2[/TD]
[/TR]
[TR]
[TD="class: xl66"]aa2, aa3|aa1[/TD]
[/TR]
[TR]
[TD="class: xl66"]aa2, aa3|aa2[/TD]
[/TR]
[TR]
[TD="class: xl66"]aa1[/TD]
[/TR]
</tbody>[/TABLE]
But I can not figure out how to manage the edge cases where replace value can be a substring of a different replace value like "aa2, aa3|aa1"
Thanks for help on this