分裂文本 [英] Splitting Text

问题描述

你好，


我写了一个小脚本，应该拆分FirstName，Mr.Ms.Miss和LastName。但是，我收到的原始数据，我将不得不使用我的VB脚本，有点复杂，我还不能解决这个挑战。我需要专家的一些提示。 :-)

Hi There,

I have written a little script that should splitt FirstName, Mr.Ms.Miss and LastName. However, the raw data I received with which I will have to use my VB script, is a bit more complicated, and I can''t solve that challenge yet. I need some tips from experts. :-)

展开 | 选择 | Wrap | 行号

推荐答案

检查：

Hi,

Check This :

展开 | 选择 | Wrap | 行号

问题：您是否相信总是包含的数据标题？这将对逻辑产生影响。

Question: Do you trust the data to always include a title? This will make a difference to the logic.

问题：您是否相信总是包含的数据标题？这将对逻辑产生影响。

Question: Do you trust the data to always include a title? This will make a difference to the logic.

感谢您的想法到目前为止。


To Killer42：


不，也有一些人有博士作为头衔。


到Veena：


谢谢，我会尝试使用你的输入，但我真的不明白为什么你要使用SQL？


感谢您的投入。


问候，

Thanks for the ideas so far.

To Killer42:

No, there are also some, who have a Doctor as Title.

To Veena:

Thanks, I will try to use your input, but I am not really getting it why you are using SQL?

Thanks for the inputs.

Regards,

这篇关于分裂文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！