مطالب مرتبط با «extract values from excel cell» در Recent Questions | نویسنده: استخدام کار
Extract values from pattern string, into 3 columns?
I have a single column that contains a string in the following patte: blablabla?bla&bla&tv_a=value1&tv_b=value2&tv_3=value3 I want extract the data from the tv_[i] strings into 3 separate columns: value1 value2 value3 Example: For the following two records: long-url-here?a=0&b=4&tv_a=hello&tv_b=there&tv_3=now other-url?z=4&v=2&tv_a=this&tv_b=is%20an2&tv_3=example Columns should be: column 1 | column 2 | column 3 ------------------------------- hello | there | now this | is an | example Let's block ads!...
ادامه مطلب
