No cannot, But yhe column looks like this coloumnA 1234567890 1qwe234rq aaa bold 9087654321 abc1234 gold 8901234567 acs1234 ab leee good 1224512345 abcvs123
I got the second word for first theree,but for it will throw an error left(RIGHT([coloumnA],LEN([coloumnA])-11), (INSTR(RIGHT([coloumnA],LEN([coloumnA])-11),’ '))-1 )
Hi Team Need you help. I extracted set of string from from a webpage. Now, I am trying to extract a value that is coming multiple time in string. I am able to extract first value using substring and need to extract more. Can someone please help me how I can extract?
Hi Team Need you help. I extracted set of string from from a webpage. Now, I am trying to extract a value that is coming multiple time in string. I am able to extract first value using substring and need to extract more. Can someone please help me how I can extract?
If the pattern of your desired value is same.,, You can use regex.