Forum Discussion
Need Help with Excel Spreadsheet
I am trying to find client names (Column B) that are associated with the same jobs numbers that are column C and paste all the names in a new column. For Example: Jon Doe - B20-999A Jim Doe - B1...
create temp table aa as
select Column1,udf_trim(Column2,'"') Column2 from split_data_textjoin_by_column2;
cli_split_data~aa~\s~Column2;
select Column2,group_concat(Column1) from aasplit group by Column2;
http://e.anyoupin.cn/ceshi/jstest/pull_up_demo.php?s=split_data_text