嗨,
我编写了以下代码,其功能如下 -
1.检查表中是否存在列名EPATH
2.如果是,请获取该列的所有值
3.需要在列值中的最后一个“\”后获取字符串。
4.代码确实有效,但在值的末尾追加“}”。
If( Contains( col_name ,"EPATH" ),
unique_epath = {};
unique_epath = Associative Array(dt:EPATH) << Get Keys;
wordlist=Words(char(unique_epath), "\");
totword=NItems(wordlist);
Column(dtout,"Order")[1] = wordlist[totword-0];
);
我怎样才能解决这个问题?
TIA
这就是你追求的吗?
NamesDefaultToHere(1);
dt = New Table( "Test",
Add Rows( 5 ),
New Column( "EPATH",
Character,
"Nominal",
Set Values( {"a\b\c", "a\b\c", "d\e\f", "d\e\f", "g\h\i"} )
)
);
unique_epath = Associative Array(dt:EPATH) << Get Keys;
lastPart = {};
for(p=1, p<=NItems(unique_epath), p++,
parts = Words(unique_epath[p], "\");
InsertInto(lastPart, parts[NItems(parts)])
);
Print(lastPart);