BigQuery SQL: Add line break in concatenate string
Gross
I'm trying to concatenate a string:
concat(product," (",cast(created_date as string)," - ",cast(end_date as string),") ")
in Output I get :
Row String
1 Product_B (12-02-2020 - 21-04-2020)
2 Product_A (10-01-2020 - 11-02-2020)
3 Product_C (14-05-2020 - 19-07-2020)
So I want to add a line break in concatenate string And as a result, receive:
Row String
1 Product_B
(12-02-2020 - 21-04-2020)
2 Product_A
(10-02-2020 - 11-02-2020)
3 Product_C
(14-05-2020 - 19-07-2020)
What needs to be added to get break a string line?
Mikhail Berlyant
Consider below option
select *,
format('%s\n(%s - %s)', product, created_date, end_date) rip
from `project.dataset.table`
if applied to sample data in your question -
with `project.dataset.table` as (
select 'Product_B' product, '2020-02-12' created_date, '2020-04-21' end_date union all
select 'Product_A', '2020-01-10', '2020-02-11' union all
select 'Product_C', '2020-05-14', '2020-07-19'
)
output is
In case if your dates column are of DATE data type - use below instead
select *,
format('%s\n(%t - %t)', product, created_date, end_date) rip
from `project.dataset.table`
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
TOP Ranking
- 1
Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background
- 2
pump.io port in URL
- 3
Failed to listen on localhost:8000 (reason: Cannot assign requested address)
- 4
How to import an asset in swift using Bundle.main.path() in a react-native native module
- 5
How to use HttpClient with ANY ssl cert, no matter how "bad" it is
- 6
Modbus Python Schneider PM5300
- 7
What is the exact difference between “ use_all_dns_ips” and "resolve_canonical_bootstrap_servers_only” in client.dns.lookup options?
- 8
Spring Boot JPA PostgreSQL Web App - Internal Authentication Error
- 9
BigQuery - concatenate ignoring NULL
- 10
split column by delimiter and deleting expanded column
- 11
Unable to use switch toggle for dark mode in material-ui
- 12
Soundcloud API Authentication | NodeWebkit, redirect uri and local file system
- 13
Apache rewrite or susbstitute rule for bugzilla HTTP 301 redirect
- 14
Is there an option for a Simulink Scope to display the layout in single column?
- 15
UWP access denied
- 16
Center buttons and brand in Bootstrap
- 17
express js can't redirect user
- 18
Make a B+ Tree concurrent thread safe
- 19
Printing Int array and String array in one
- 20
Google Chrome Translate Page Does Not Work
- 21
Elasticsearch - How to match number range in string
Comments