Help replace string within another string

A

Ayo

I want to replace <scale>0.5</scale> and <scale>0.7</scale> in the string of
text belong. This string is in a cell. i only need to change the 0.5 and the
0.7. The point is I don't know what the value between <scale> </scale>, will
be. I just want to change them.
But there are two <scale> </scale> in the cell. I need to be able to
differentiate between the first one and the second one. I need to figure out
a way such that when I get the 2 values, i.e, 1.0 and 1.2, that I am going to
replace the old values with, I want to select the cell that contain the
string below and replace in the first <scale>0.5</scale> with
<scale>1.0</scale> and the second <scale>0.7</scale> with <scale>1.2</scale>
I don't know if it is possible to use something like:
Replace("<scale>*.*</scale>", "*.*", replace[, start[, count[, compare]]])










"<Style id=""normal_MS_Actaul"">
<IconStyle>
<color>ff7f00ff</color>
<scale>0.5</scale>
<Icon>

<href>http://maps.google.com/mapfiles/ms/icons/red-dot.png</href>
</Icon>
<hotspot x=""0.5"" y=""0""
xunits=""fraction"" yunits=""fraction""/>
</IconStyle>
<LabelStyle>
<scale>0.5</scale>
</LabelStyle>
</Style>
<Style id=""highlight_MS_Actaul"">
<IconStyle>
<color>ff7f00ff</color>
<scale>0.7</scale>
<Icon>

<href>http://maps.google.com/mapfiles/ms/icons/red-dot.png</href>
</Icon>
<hotspot x=""0.7"" y=""0""
xunits=""fraction"" yunits=""fraction""/>
</IconStyle>
<LabelStyle>
<scale>0.7</scale>
</LabelStyle>
</Style>
<StyleMap id=""Actual_StyleMap"">
<Pair>
<key>normal</key>
<styleUrl>#normal_MS_Actaul</styleUrl>
</Pair>
<Pair>
<key>highlight</key>
<styleUrl>#highlight_MS_Actaul</styleUrl>
</Pair>
</StyleMap>"
 
R

Rick Rothstein

You are going to have to clarify something for us. You say there are two
<scale>...</scale> combinations in the text, but I count four of them....
two with 0.5 between them and two with 0.7 between them. Please explain.
 
R

Ron Rosenfeld

I want to replace <scale>0.5</scale> and <scale>0.7</scale> in the string of
text belong. This string is in a cell. i only need to change the 0.5 and the
0.7. The point is I don't know what the value between <scale> </scale>, will
be. I just want to change them.
But there are two <scale> </scale> in the cell. I need to be able to
differentiate between the first one and the second one. I need to figure out
a way such that when I get the 2 values, i.e, 1.0 and 1.2, that I am going to
replace the old values with, I want to select the cell that contain the
string below and replace in the first <scale>0.5</scale> with
<scale>1.0</scale> and the second <scale>0.7</scale> with <scale>1.2</scale>
I don't know if it is possible to use something like:
Replace("<scale>*.*</scale>", "*.*", replace[, start[, count[, compare]]])










"<Style id=""normal_MS_Actaul"">
<IconStyle>
<color>ff7f00ff</color>
<scale>0.5</scale>
<Icon>

<href>http://maps.google.com/mapfiles/ms/icons/red-dot.png</href>
</Icon>
<hotspot x=""0.5"" y=""0""
xunits=""fraction"" yunits=""fraction""/>
</IconStyle>
<LabelStyle>
<scale>0.5</scale>
</LabelStyle>
</Style>
<Style id=""highlight_MS_Actaul"">
<IconStyle>
<color>ff7f00ff</color>
<scale>0.7</scale>
<Icon>

<href>http://maps.google.com/mapfiles/ms/icons/red-dot.png</href>
</Icon>
<hotspot x=""0.7"" y=""0""
xunits=""fraction"" yunits=""fraction""/>
</IconStyle>
<LabelStyle>
<scale>0.7</scale>
</LabelStyle>
</Style>
<StyleMap id=""Actual_StyleMap"">
<Pair>
<key>normal</key>
<styleUrl>#normal_MS_Actaul</styleUrl>
</Pair>
<Pair>
<key>highlight</key>
<styleUrl>#highlight_MS_Actaul</styleUrl>
</Pair>
</StyleMap>"
Click to expand...

There are several ways to do this using Regular Expressions. The regular
expression in the UDF below does what you describe. But, as written, it's not
very flexible. Also, it does no error checking. But it will work for the
first two "<scale>'s"

========================================
Option Explicit
Function ReplScale(s As String, Repl1 As String, Repl2 As String) As String
Dim re As Object
Dim sRepl As String
Const sPat As String = _
"^([\s\S]*?<scale>)[^<]*(</scale>[\s\S]*?<scale>)[^<]*([\s\S]*$)"

sRepl = "$1" & Repl1 & "$2" & Repl2 & "$3"

Set re = CreateObject("vbscript.regexp")
With re
.Global = True
.ignorecase = True
.Pattern = sPat
End With

ReplScale = re.Replace(s, sRepl)
End Function
======================================================
--ron
 
A

Ayo

The first combination are the 0.5s inside "<Style id=""normal_MS_Actaul"">
and the other arev 0.7s inside the "<Style id=""normal_MS_Projected""> tag.

Rick Rothstein said:
You are going to have to clarify something for us. You say there are two
<scale>...</scale> combinations in the text, but I count four of them....
two with 0.5 between them and two with 0.7 between them. Please explain.

--
Rick (MVP - Excel)


Ayo said:
I want to replace <scale>0.5</scale> and <scale>0.7</scale> in the string
of
text belong. This string is in a cell. i only need to change the 0.5 and
the
0.7. The point is I don't know what the value between <scale> </scale>,
will
be. I just want to change them.
But there are two <scale> </scale> in the cell. I need to be able to
differentiate between the first one and the second one. I need to figure
out
a way such that when I get the 2 values, i.e, 1.0 and 1.2, that I am going
to
replace the old values with, I want to select the cell that contain the
string below and replace in the first <scale>0.5</scale> with
<scale>1.0</scale> and the second <scale>0.7</scale> with
<scale>1.2</scale>
I don't know if it is possible to use something like:
Replace("<scale>*.*</scale>", "*.*", replace[, start[, count[, compare]]])










"<Style id=""normal_MS_Actaul"">
<IconStyle>
<color>ff7f00ff</color>
<scale>0.5</scale>
<Icon>

<href>http://maps.google.com/mapfiles/ms/icons/red-dot.png</href>
</Icon>
<hotspot x=""0.5"" y=""0""
xunits=""fraction"" yunits=""fraction""/>
</IconStyle>
<LabelStyle>
<scale>0.5</scale>
</LabelStyle>
</Style>
<Style id=""highlight_MS_Actaul"">
<IconStyle>
<color>ff7f00ff</color>
<scale>0.7</scale>
<Icon>

<href>http://maps.google.com/mapfiles/ms/icons/red-dot.png</href>
</Icon>
<hotspot x=""0.7"" y=""0""
xunits=""fraction"" yunits=""fraction""/>
</IconStyle>
<LabelStyle>
<scale>0.7</scale>
</LabelStyle>
</Style>
<StyleMap id=""Actual_StyleMap"">
<Pair>
<key>normal</key>
<styleUrl>#normal_MS_Actaul</styleUrl>
</Pair>
<Pair>
<key>highlight</key>
<styleUrl>#highlight_MS_Actaul</styleUrl>
</Pair>
</StyleMap>"
Click to expand...

.
Click to expand...
 
R

Rick Rothstein

But what did you want replaced? You gave us two "replacement" numbers and
there appear to be four <scale> values to replace. How is that supposed to
work? Did you only want the first two of the four <scale> values replaced,
or are we supposed to replace the first <scale> value and all other <scale>
values with that number in it with the first "replacement" number and
similarly for the second <scale> value?

--
Rick (MVP - Excel)


Ayo said:
The first combination are the 0.5s inside "<Style id=""normal_MS_Actaul"">
and the other arev 0.7s inside the "<Style id=""normal_MS_Projected"">
tag.

Rick Rothstein said:
You are going to have to clarify something for us. You say there are two
<scale>...</scale> combinations in the text, but I count four of them....
two with 0.5 between them and two with 0.7 between them. Please explain.

--
Rick (MVP - Excel)


Ayo said:
I want to replace <scale>0.5</scale> and <scale>0.7</scale> in the
string
of
text belong. This string is in a cell. i only need to change the 0.5
and
the
0.7. The point is I don't know what the value between <scale> </scale>,
will
be. I just want to change them.
But there are two <scale> </scale> in the cell. I need to be able to
differentiate between the first one and the second one. I need to
figure
out
a way such that when I get the 2 values, i.e, 1.0 and 1.2, that I am
going
to
replace the old values with, I want to select the cell that contain the
string below and replace in the first <scale>0.5</scale> with
<scale>1.0</scale> and the second <scale>0.7</scale> with
<scale>1.2</scale>
I don't know if it is possible to use something like:
Replace("<scale>*.*</scale>", "*.*", replace[, start[, count[,
compare]]])










"<Style id=""normal_MS_Actaul"">
<IconStyle>
<color>ff7f00ff</color>
<scale>0.5</scale>
<Icon>

<href>http://maps.google.com/mapfiles/ms/icons/red-dot.png</href>
</Icon>
<hotspot x=""0.5"" y=""0""
xunits=""fraction"" yunits=""fraction""/>
</IconStyle>
<LabelStyle>
<scale>0.5</scale>
</LabelStyle>
</Style>
<Style id=""highlight_MS_Actaul"">
<IconStyle>
<color>ff7f00ff</color>
<scale>0.7</scale>
<Icon>

<href>http://maps.google.com/mapfiles/ms/icons/red-dot.png</href>
</Icon>
<hotspot x=""0.7"" y=""0""
xunits=""fraction"" yunits=""fraction""/>
</IconStyle>
<LabelStyle>
<scale>0.7</scale>
</LabelStyle>
</Style>
<StyleMap id=""Actual_StyleMap"">
<Pair>
<key>normal</key>
<styleUrl>#normal_MS_Actaul</styleUrl>
</Pair>
<Pair>
<key>highlight</key>

<styleUrl>#highlight_MS_Actaul</styleUrl>
</Pair>
</StyleMap>"
Click to expand...

.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With with replacing part of a string with another string 2
FWT Newsletter - Weekly - October 11, 2004 0

Top