| Field | Formula | |--------|---------| | SRNO | =TEXTBEFORE(A1," ") | | Report Date | =TEXTBEFORE(TEXTAFTER(A1," ")," ") | | ZONE-REGION-BKBR-STATE | =TEXTBEFORE(TEXTAFTER(A1," ",2)," ",1) | | CUSTOMER | =TEXTAFTER(A1," ",3) |
Since the requirement is open-ended, here are depending on your use case (SQL, Python/Pandas, or Excel formula). 1. SQL (Parse / Extract from a combined string field) If you have a column containing a string like: "SRNO Report Date ZONE-REGION-BKBR-STATE CUSTOMER" (e.g., "001 2025-03-20 NORTH-EAST-BKBR01-CA John Doe" ) SRNO Report Date ZONE-REGION-BKBR-STATE CUSTOMER
SRNO Report_Date CUSTOMER ZONE REGION BKBR STATE 0 001 2025-03-20 Alice NORTH EAST BKBR01 CA 1 002 2025-03-21 Bob SOUTH WEST BKBR02 TX To extract each component: | Field | Formula | |--------|---------| | SRNO
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: 1) | | CUSTOMER | =TEXTAFTER(A1
"SRNO Report Date ZONE-REGION-BKBR-STATE CUSTOMER"