Split to values

anupambit1797 

Try this Go script for reference.

Rename the attached from .xlsx to .zip and unzip it.

package main

import (
	"fmt"
	"io/ioutil"
	"os"
	"regexp"
	"strconv"
	/*
	"strings"
	*/
	"encoding/csv"
)

func main() {
	// Read the input file
	data, err := ioutil.ReadFile("pdsch_config_setup.txt")
	if err != nil {
		fmt.Println("Error reading file:", err)
		return
	}

	// Extract relevant information using regular expressions
	//regex := regexp.MustCompile(`tci-StateId (\d+),.*?csi-rs : (\d+),.*?qcl-Type (\w+)`)
	//regex :=regexp.MustCompile(`tci-StateId (\d+),[\s\S]*?csi-rs : (\d+),[\s\S]*?qcl-Type (\w+)`)
	regex :=regexp.MustCompile(`tci-StateId (\d+),[\s\S]*?(csi-rs|ssb) : (\d+),[\s\S]*?qcl-Type (\w+)`)
	matches := regex.FindAllStringSubmatch(string(data), -1)

	// Open the output CSV file
	file, err := os.Create("output.csv")
	if err != nil {
		fmt.Println("Error creating file:", err)
		return
	}
	defer file.Close()

	writer := csv.NewWriter(file)
	defer writer.Flush()

	// Write the header row
	header := []string{"tci-StateId", "referenceSignal csi-rs", "qcl-Type", "referenceSignal", "referenceSignal Id"}
	err = writer.Write(header)
	if err != nil {
		fmt.Println("Error writing header:", err)
		return
	}

	// Write the data rows
//	for index, match := range matches {
	for _, match := range matches {
		tciStateId, _ := strconv.Atoi(match[1])
		referenceSignal, _ := strconv.Atoi(match[3])
		qclType := match[4]

		row := []string{
			//strconv.Itoa(index),
			strconv.Itoa(tciStateId),
			strconv.Itoa(referenceSignal),
			qclType,
			match[2],
			strconv.Itoa(referenceSignal),
		}
		err = writer.Write(row)
		if err != nil {
			fmt.Println("Error writing data:", err)
			return
		}
	}

	fmt.Println("CSV file created successfully.")
}

Hi anupambit1797 

Update the path (in the Source step) to the text file in the attached query and if your actual file is as consistent as the one you shared that should work...