帮助分离一些数据 [英] Help separating some data

问题描述

美好的前夕，


只是一个快速（希望）


只是想知道我如何分离一些数据，不幸的是它不是以非常合理的格式（这只是数据的一个字段）

展开 | 选择 | Wrap | 行号

解决方案

@ Dan2kx


据我所知，SQL中没有已知功能t会按你的要求做，但是等等看看其他会员提出了什么，因为他们比SQL更精通SQL。然而，你要求的是DAO和VBA代码的结合。首先，有几个问题：

1. 包含此数据的表的名称是什么？
2. 您声明此数据存在在一个字段中，该字段的名称是什么？
3. 10位数条目（如果存在）是否始终位于字段的开头？
4. 是否有可能多个10位数的数字可以存在于同一个记录中吗？
5. 如果存在10个数字的条目，是否总会有空格？
6. 什么是名称您想要记录''与'10位数条目附加到哪个表/字段？
7. 您希望记录'没有'的表/字段的名称是什么10-数字条目附加？
8. 如果您对基于代码的解决方案感兴趣，请尽可能准确地回答问题，如果没有，请忽略此帖子。

@ADezii


此数据不是我的，因为您可能已经猜到了，这个分离只是操作过程的第一步，随后我将需要使用DAO等


i确实设法创建了一些分离数据的SQL，并且基于以下：

展开 | 选择 | Wrap | 行号

@ Dan2kx


当我有机会发布我想出的结果时，将结果发布到2个表中，从而为您提供另一种方法。

Good eve peeps,

Just a quicky (hopefully)

Just wondering how i can seperate some data, unfortunately it is not in a very logical format,( this is just one field of the data)

Expand|Select|Wrap|Line Numbers

解决方案

@Dan2kx
To the best of my knowledge, there is no known functionality within SQL that will do what you request, but wait and see what other Members come up with since they are better versed in SQL than I. What you are requesting can be done, however, with a combination of DAO and VBA code. First and foremost, a couple of questions:

1. What is the Name of the Table containing this data?
2. You stated that this data exists in a single Field, what is the Name of this Field?
3. Will the 10 digit entry, if it exists, always be at the start of the Field?
4. Is there a possibility that multiple, 10-digit numbers, can exist in the same Record?
5. Will there always be a Space after a 10-digit entry if it exists?
6. What is the Name of the Table/Field into which you want the Records ''with'' 10-digit entries Appended?
7. What is the Name of the Table/Field into which you want the Records ''without'' 10-digit entries Appended?
8. If you are interested in a code-based solution, kindly answer the questions as accurately as possible, if not, simply ignore this Post.

@ADezii
this data is not mine as you might have guessed, this seperation is only the first step in the manipulation process, subsequently i will need to use DAO etc

i did manage to create some SQL that seperates the data and supprisingly to work based on the following:

Expand|Select|Wrap|Line Numbers

@Dan2kx
I''l post what I come up with when I get a chance, posting the results into 2 Tables, thus giving you another approach.

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