postgresql - Postgres: Trim white space from array values -

-

my records in table follows:

id    column1  1   'record1'  2   ' record2'  3   ' record3a, record3b'  4   'record4a , record4b, record4c '  column1 type: text

pre-defined array= {record1,record2,record3a}

while i'm checking values pre-defined array using && operator, of values missed because of delimiter space between unnecessary.

hence need first remove these space there in beginning or end (only) , string_to_array() result compared pre-defined array

use trim() remove leading trailing whitespace:

select string_to_array(trim(both ' ' regexp_replace(column1, '\s*,\s*', ',')), ',') yourtable

Comments

Post a Comment

Popular posts from this blog

Formatting string according to pattern without regex in php -

-
how can format arbitrary string according flexible pattern? solution came using regular expressions, need 2 "patterns" (one search , 1 output). example: $str = '123abc5678"; desired output: 12.3ab-c5-67.8 i use pattern in variable (one user can define without knowledge of regular expressions) this: $pattern = '%%.%%%-%%-%%.%'; so user have use 2 different characters (% , .) a solution regex this: $str = '123abc5678'; $pattern_src = '@(.{2})(.{3})(.{2})(.{2})(.{1})@'; $pattern_rpl = "$1.$2-$3-$4.$5"; $res = preg_replace($pattern_src, $pattern_rpl, $str); //$res eq 12.3ab-c5-67.8 way complicated since user need define $pattern_src , $pattern_rpl. if string vary in length, more complex explain. yes, write function/parser builds required regular expressions based on simple user pattern %%.%%%-%%-%%.%. wonder if there "built in" way achieve php? thinking sprintf etc., doesn't seem trick. ideas? ...
Read more

ios - Align baselines with characters in large line heights with Text Kit -

-
Image
when draw attributed string fixed line height text kit, characters aligned bottom of line fragment. while make sense on 1 line characters varying in size, breaks flow of text multiple lines. baselines appear decided largest descender each line. i've found article people behind sketch explaining exact problem in bit more detail , showing solution does, not explaining how achieved this. this want basically: when showing 2 lines large line height, result far ideal: the code i'm using: let smallfont = uifont.systemfont(ofsize: 15) let bigfont = uifont.systemfont(ofsize: 25) let paragraphstyle = nsmutableparagraphstyle() paragraphstyle.minimumlineheight = 22 paragraphstyle.maximumlineheight = 22 var attributes = [ nsfontattributename: smallfont, nsparagraphstyleattributename: paragraphstyle ] let textstorage = nstextstorage() let textcontainer = nstextcontainer(size: cgsize(width: 250, height: 500)) let layoutmanager = nslayoutmanager() textstorage.append(n...
Read more

xcode - CocoaPod Storyboard error: -

-
i made cocoapod include in main project, splash screen animations used while app loading page go to. builds fine in cocoapod project, when include local copy in other projects local folder, following error on storyboard... error: not enough arguments provided; input document operate on? any idea on going on here? it ended being issue .podspec file. had .source_files spec including not swift file, storyboard.. apparently xcode not cool (shown below).. spec.source_files = 'cocoapodprojectfolder/source/*.{swift, storyboard}' to fix had move storyboard file correct spec: resource_bundle... spec.source_files = 'cocoapodprojectfolder/source/*.{swift}' spec.resource_bundle = {'cocoapodproject' => 'cocoapodprojectfolder/source/*.{storyboard}'}
Read more