将一个单元格中的地址数据拆分为多个单元格所需的紧急帮助（Excel） [英] Urgent Help Needed in Splitting the Address data in one cell to multiple cells (Excel)

问题描述

需要帮助找出问题的解决方案。可以使用.NET完成吗



我有一个包含Sl.No，Mobile No，Email Id，Address Main（4 Columns）的数据。

在地址主列中，整个地址输入一个单元格



样本：

（Kishore kumar.Madugmla H.no：1 11 110/92 / A / 43，New Tatachari殖民地，Shyamlal建筑物，Begum宠物，Hyderabad91-9290910799）



我试图使用Delimiter和试图在，或 - 的帮助下拆分它，这是一个失败。大约3562条记录，地址字段中的数据在大多数单元格中都不合适。



有没有办法可以将D列中的字段拆分为不同的单元格，例如我想要这样的数据（使用上面的示例地址单元格）



EFGH

Kishore Kumar.Madugula H .No：1-11-110 / 92 / A / 43新Tatachari殖民地Shyamlal建筑物



PS：但对于上述样本，每个细节都用，分隔。但对于许多其他细胞来说并非如此。这对我来说是主要的挑战。



你能帮我解决一下吗？



样本文件



https://docs.google.com/file/d/0B_8nXiEldUKKa3g5QzJwMUk4blU/edit?usp=sharing

Help needed in figuring out a solution for my problem. Can this be done using .NET

I have a data which contains Sl.No, Mobile No, Email Id, Address Main (4 Columns).
In "Address Main" Column the entire address is entered in a single cell

Sample:
(Kishore kumar.Madugmla H.no: 1 11 110/92/A/43, New Tatachari colony,Shyamlal Buildings, Begum pet, Hyderabad91-9290910799)

I tried to used Delimiter and tried to Split it with the help of " , " or " - " and it was a failure. There are around 3562 records and the data in the address field is not proper in most of the cells.

Is there a way i can split the field in Column D into different cells, for example i want the data in this way (Using the above sample address cell)

E F G H
Kishore Kumar.Madugula H.No: 1-11-110/92/A/43 New Tatachari colony Shyamlal Buildings

P.S : But for the above sample every details is seperated by " , " but for many other cell it is not the case. That is the main challenge for me.

Can you help me out with a solution

Sample Document

https://docs.google.com/file/d/0B_8nXiEldUKKa3g5QzJwMUk4blU/edit?usp=sharing

推荐答案

如果您的数据缺少一致的分隔符，则没有可靠的方法来执行此操作。你的代码怎么知道这个：

If your data is missing a consistent seperator, there''s no reliable way to do this. How is your code going to know that this:

123 Some Street SomeCity SomeStateSomPostalCode

应该是：

Should be:

123 Some Street
SomeCity, SomeState  SomePostalCode

而不是

and not

123 Some Street SomeCity
SomeState  SomePostalCode

??



不可能。至少没有TON的数据库工作和完整的街道，城市，地区，邮政编码列表，等等，等等，等等......你的代码可以从中抽取并识别出格式错误的数据。



说实话，只有3500条记录，在导入它们之前手动完成它们并将它们全部修复比写入代码为你完成并测试废弃它。你仍然必须通过并确保数据是正确的。



这是从用户收集数据并在输入时学习验证步骤的问题时间。你保存它们的工作突然完全落在了你身上。

??

It can''t. At least not without a TON of database work and complete lists of streets, cities, territories, postal codes, blah, blah, blah, ... som your code has something to draw from and recognize the malformed data.

Truthfully, with only 3500 records, it would be faster to go through them by hand and fix them all before importing them than it would to write the code to do it for you and test the crap out of it. You''d STILL have to go through and make sure that data is correct.

This is the problem with collecting data from the user and skilling the validation step at input time. The work you save them suddenly falls entirely on you to fix.

谢谢你的回复。



是的，我可以做到手动，但我会在每周两次得到这种数据。所以我必须为这类问题创建一个通用的解决方案。



你能帮助我找到解决方案吗？有可能......！

Thanks For the reply.

Yes i can do it manually but i will be getting this kind of data twice in every week. So i have to create a generic solution for this kind of problem.

Can you help me out in finding out a solution. Is it possible.....!

这篇关于将一个单元格中的地址数据拆分为多个单元格所需的紧急帮助（Excel）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！