python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - extract

Moving records from one database instance to another

I have a PostgreSQL database instance located in EU region. I plan on introducing another PostgreSQL database instance located in a new geographical region. As part this work, I am to migrate data for...
test-img

oldhomemovie

postgresql

extract

database-backups

Votes: 0

Answers: 1

Latest Answer

Indeed You need a whole proccess yo do this, i think that You should create a new schema to do the data Select i think functions could do the magic, then replicate that data. They replication tool it'...
test-img

Luis Carlos Lara Cruz

Extract year, month and day numbers (1 to 2 digits) from a string (LibreOffice Base)

I am using LibreOffice Base (version 7.3) to create a database. I need to extract year, month and day numbers from such strings that consist Chinese charactors as shown following. I think one Chinese ...
test-img

Paul the sea wolf

string

extract

hsqldb

libreoffice

radix

Votes: 0

Answers: 1

Latest Answer

Unfortunately, you didn't specify which built-in database you are using, Firebird or HSQLDB. You didn't provide your table name and Chinese date field name. Therefore, I will show how this problem is...
test-img

JohnSUN

Pandas counting string pattern and appending to column multi index

I have this dataframe and am looking to count the number of times a pattern occurs and then append to a new colum. In this case the pattern I'm interested in is "MV=??" i.e. MV=5455 etc. d =...
test-img

Chip

python

pandas

extract

Votes: 0

Answers: 1

Latest Answer

Try with apply and str.count: output = f.apply(lambda x: x.str[0].str.count("MV=")).dropna(how="all", axis=1) output = output.rename(columns={c[1]: "ALT" for c in output....
test-img

not_speshal

Extract values from javascript object

I am just learning to code so I can become a developer. My interest in JavaScript and I'm needing help to extract values from a JavaScript object and assign values as variables. Please see below: var ...
test-img

Yekota

javascript

arrays

object

variables

extract

Votes: 0

Answers: 1

Latest Answer

What you need is an array. In this case you have something that should be an array of member names. To get the count you can just get the length of the array with .length. To assign the contents of th...
test-img

SteveGreenley

Posts

Questions

Blogs

Jobs