I have a SQLite table with data in its column "Description" like the following
Description
"DX SVFO FERX DETYUY09"
"FCS DFT DEUU WALK LIM"
"D FX DS"
Now i have to split them based on occurrence of null and remove null
Expected result
Description_1 Description_2 DESCRIPTION3
DX SVFO D
FCS DFT F
D FX D
Exact pattern expected is below. the description_1 takes any character in starting and so does the second , third one would take exactly a single character from the second null occurence to the third
Can you tell me how to build the pattern here to achieve this with a select statement in SQLITE Database
Br, G
Aucun commentaire:
Enregistrer un commentaire