All Questions
Tagged with substring regular-expression
5 questions
2
votes
2
answers
503
views
Return part of a string with variable length
I have data in a table column like below:
host=0.0.0.0 port=5432 dbname=database_name user=pglogicaluser
host=0.0.0.0 port=5432 dbname=database_name2 user=pglogicaluser
I want to write a query to get ...
- 532
2
votes
1
answer
2k
views
Replacing a specific string in oracle
I've a database value 'INS. Company Cancelled' where multiple values are separated by '.'
I'm trying to replace 'INS' with 'INSEXP' my expected result is 'INSEXP. Company Cancelled'
I've tried below ...
- 193
1
vote
1
answer
58
views
How to extract certificate attributes from a single column and split into many?
In my table I've a field (let say cert_attr) which stores Certificate X.509 Attributes.
Here is the example of 3 rows (each line corresponds to a field):
"CN=User1, OU=Eng, O=Company Ltd, L=D4, S=...
- 475
0
votes
1
answer
2k
views
Timestamp and substring with regular expression
I am using postgresql and I have the following table
Table "public.test"
Column | Type | Modifiers
--------+--------------------------+-----------
name | text ...
- 13
2
votes
1
answer
10k
views
How to Extract SubString between two positions
I have a text column (emailbody) in a table (notification) which keeps a record of the HTML that went out for a particular email. Somewhere inside that HTML file, there is a line of text that contains ...
- 391