我需要添加一个新列来过滤'rowmbr1'的部分文本并将其放置在新列中。
示例：
rowmbr1的值为“Sales staff”或“Marketing staff”
在输出csv中，我需要在rowmbr1旁边添加一个新列，仅包含文本“Sales”或“Marketing”

我的脚本没有新列：

def povDims = [ Povdim1, povdim2]
def povMbrs = [['Povmbr1'], ['povmbr2']]
def colDims =  ['coldim'] 
def colMbrs = [ ['coldim1','coldim2'] 
def rowDims = ['rowdim']
def rowMbrs = [ ['rowmbr1']]

 
Cube cube = operation.application.getCube("Plan")
DataGridDefinitionBuilder builder = cube.dataGridDefinitionBuilder()
builder.setSuppressMissingBlocks(true)
builder.setSuppressMissingRows(true)
builder.addPov(povDims, povMbrs)
builder.addColumn(colDims, colMbrs)
builder.addRow(rowDims, rowMbrs)

DataGridDefinition gridDefinition = builder.build()

cube.loadGrid(gridDefinition, false).withCloseable {
grid ->

  //def filteredRows = grid.rows.findAll{it.data.findAll{it.name() == 'Territory'}}

    operation.exportDataToFile(grid, 'fullGridExport.csv')
    }

非常感谢您的帮助。
示例：
rowmbr1的值为“Sales staff”或“Marketing staff”
在输出csv中，我需要在rowmbr1旁边添加一个新列，仅包含文本“Sales”或“Marketing”
我无法在导出CSV之前创建新列。