将一个字符串分成多个并插入多个colunms [英] Spliting one string into multiple and inserting into multiple colunms

问题描述

我想知道宏或查询将字符串拆分为一个单独的colunm并将其插入多个colunms（可能是一个句子）

例如


colunm1包含：


每日1234！@＃$（这些单词以空格分隔）


这些东西必须是分成每日$！
1234，@！@并插入三个不同的组合

colunm2 colunm3 colunm4

每日1234！@＃$


这些colunms在同一个表中。

解决方案

（这些单词用空格分隔）


这些东西必须分成

1234，每日，！@＃

并插入三个不同的组合

colunm2 colunm3 colunm4

每日1234！@＃

这些colunms在同一张表中。

I want to know the macro or query to split the string in one single colunm and insert those into multiple colunms(that may be a sentence)
like for example

colunm1 contains:

1234 daily !@#$(these words are separated by space)

these things must be splited in to
1234,daily,!@#$ and inserted into three different colunms
colunm2 colunm3 colunm4
1234 daily !@#$

these colunms are in same table.

解决方案

(these words are separated by space)

these things must be splited in to
1234,daily,!@#

and inserted into three different colunms
colunm2 colunm3 colunm4
1234 daily !@#

these colunms are in same table.

这篇关于将一个字符串分成多个并插入多个colunms的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！