Code:
ALTER PROCEDURE ParseString @instr as varchar(max) AS declare @pos as int declare @current_str as varchar(max)
inspireuk
Last Activity: Nov 20 '07, 01:01 PM
Joined: Jul 6 '07
Location:
-
so i've been playing with what you gave me. i've changed it to a stored procedure as i'm no longer doing recursion. if you get a chance can you look at the code below - it does seem to be working but i'm not sure whether it is written the best way. Thanks again for all your time.
... -
This is ammmaazzing! I can't thank you enough :)
However :) just a couple more things if you have the time. Would it be possible only to match full words and with regards to the nested replacements i think i may just programmically recall the sp for small parts if needed so no recursion needed (sorry).
the precedence i think should be for the longer phrase.
let me know if there is anything else.
...Leave a comment:
-
Just an idea - Excel allows html tables as a valid input. it maybe easier to format your data into that.
JoshLeave a comment:
-
Javascript Time Delay
...Code:<html> <head> <script type="text/javascript"> <!-- function delayer(){ window.location = "../javascriptredirect.php" } //--> </script> </head> <body onLoad="setTimeout('delayer()', 5000)"> <h2 >Prepare to be redirected!</h2> <p>This pageLeave a comment:
-
SP to parse string adding synonimes from table
The easiest way for me to explain what I'm trying to do is show an example.
I have the following tables:
WORDS
WordID Word
1 1,000,000
2 a million
3 one million
WORDLINKS
WordID WordLinkID
1 2
1 3
2 1
2 3
3 1
3 2
I would then pass the following sentance into the SP
a million times... -
how would i parse the string into all the possible combinations? the phrases can be up to 4 words long
JLeave a comment:
-
search within string
i have a table of phrases/words
eg
somebody
someone
find you
is it possible to pass in a string to a SP
eg
somebody wants to find you
and for it to find all the phrases/words contained that are in the original table.
eg
somebody
find you
thanks in advance for any help.
Josh -
that works great! thanks.Leave a comment:
-
sorry shouldn't have used the phase 'csv file'. Let me try to explain again what i'm trying to do.
the sp would have a string input of '1,2,3'
from this i need to generate a list of all the possible combinations
1,2
1,3
2,1
2,3
3,1
3,2
which then need to be inserted into a two column table.
the string input could be any length eg '1,2,3,4,5' and...Leave a comment:
-
because the list is dynamically generated.
JoshLeave a comment:
-
SP - Convert CSV to a Link table
I have a CSV file containing linked IDs eg 1,2,3
I have a table with two columns ID and LinkedID
I would like to pass the CSV string in and have the table updated so that each relationship is added as a new record
ID,LinkedID
1,2
1,3
2,1
2,3
3,1
3,2
Any ideas?
Thanks
Josh -
Web Dev Environment
Hi,
I have been looking into updating my dev environment. I currently have
my machine running windows 2003 server hacked back into a workstation
so that i can develop multiple websites. the main reason for needing
multiple websites is that i use isapi rewrite and so need seperate
configurations.
However I now have a new PC which support hardware virtualisation and
a MSDN...
No activity results to display
Leave a comment: