Helo,
I have a table with two fields named map1 and map2 and I want to make concatenation according to the following model:
map1 map2 map12
100001 1 100001001
100001 22 100001022
100001 87 100001087
100002 999 10000299
I want to concatenate like this...
Hello
How do I replace a number with a string that has the last number identical to the number
Example:
Excel1
NR
1
1
1
2
2
2
3
3
3
Excel2
INT
int_RR_001
int_RR_002
int_RR_003
int_RR_004
int_RR_005
Thanks
Hi!
How do I replace all values in a column with length equal to 10?
Ex:
2535848577
5487
535
66666
5366666655
758675
replacement only values with length equal to 10
Merci!
I have a table called
code abr
---------------
789 AB
789 null
789 null
801 CT
801 null
801 null
812 BH
812 null
812 null
816 SV
817 TM
And I want to select it so that I can fill in the blanks with the previous non-null value:
code abr...
Hello!
how do I replace null values in a column with the last non-null value?
Ex:
Column Column
AB AB
null AB
CT CT
null CT
null CT
BH BH
null BH
null BH
SV SV
TM TM
Thank you!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.