Srno Report Date Zone-region-bkbr-state Customer May 2026
"SRNO Report Date ZONE-REGION-BKBR-STATE CUSTOMER"
| Field | Formula | |--------|---------| | SRNO | =TEXTBEFORE(A1," ") | | Report Date | =TEXTBEFORE(TEXTAFTER(A1," ")," ") | | ZONE-REGION-BKBR-STATE | =TEXTBEFORE(TEXTAFTER(A1," ",2)," ",1) | | CUSTOMER | =TEXTAFTER(A1," ",3) | SRNO Report Date ZONE-REGION-BKBR-STATE CUSTOMER
SELECT SUBSTRING_INDEX(combined_column, ' ', 1) AS SRNO, SUBSTRING_INDEX(SUBSTRING_INDEX(combined_column, ' ', 2), ' ', -1) AS Report_Date, SUBSTRING_INDEX(SUBSTRING_INDEX(combined_column, ' ', 3), ' ', -1) AS ZONE_REGION_BKBR_STATE, SUBSTRING_INDEX(combined_column, ' ', -1) AS CUSTOMER FROM your_table; For with dashes in the middle part: "SRNO Report Date ZONE-REGION-BKBR-STATE CUSTOMER" | Field |