Hi guys,
My SQL query writing isn't that great so I'm practicing new methods that are relevent to my work. I have imported a table that has non standard information such as:
Hi hi I'm a stupid face and my fav table is <ORLY> but I like chocolate.
or
Hello this is a <Table_name> and i'm just dandy
in other words, there's no real relation between the strings, except that information i want to pull out is between < >. Can someone suggest a method to pull out that information only? I am thinking CASE or SUBSTRING? The problem I have with substring is that the # of characters before < > is different per row.
Thanks!
My SQL query writing isn't that great so I'm practicing new methods that are relevent to my work. I have imported a table that has non standard information such as:
Hi hi I'm a stupid face and my fav table is <ORLY> but I like chocolate.
or
Hello this is a <Table_name> and i'm just dandy
in other words, there's no real relation between the strings, except that information i want to pull out is between < >. Can someone suggest a method to pull out that information only? I am thinking CASE or SUBSTRING? The problem I have with substring is that the # of characters before < > is different per row.
Thanks!
Facebook
Twitter