@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.")
}
