Q&A BY TAG 'substring'

You must sign in to ask a question. If you do not have an account, you can register here

Substring Error
answered 29-01-2020 06:14:57 -0500

version is a column in a table called bv_table values for version looks like Dec[10+2], Jan[1+11]. I am trying to extract the number 10, 1 from the string, any number before +, I am running the below query in the vql shell select SUBSTRING(version, ...

Answers: 1

instr function substring

Extracting string between two identical charecters
answered 28-10-2019 06:55:37 -0400

Hi Team, I have a field which have sample data like /abc/data/source/AYZ/SrcFile/XYZ_ABC_1023456789^900061767ABC00100002^ABC_2019-10-15_00.00.51.62 I want to extract two id's 1023456789 and 900061767ABC00100002 ( which is between two chars '^' ) fro...

Answers: 1

substring

How to use substr / substring function to fetch last n characters of a string
answered 09-04-2018 23:43:31 -0400

In most databases we are able to fetch last n charaters using substr function in the following manner.... select substr('abcdefghij',-3) from dual; This returns the string 'hij' i.e the last three characters. How would I be able to do the same using De...

Answers: 1

substring