mercredi 3 juin 2020

extract the values in a select query as Individual column based on null occurrence and pattern from SQLite database

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