Dear friends,
I have a problem.I want to break a column in which Address text is written, into two other column for Ist adrress and 2nd City.How Can i do this.
Thanks
5  1413  NeoPa 32,556
Expert Mod 16PB
Dear friends,
I have a problem.I want to break a column in which Address text is written, into two other column for Ist adrress and 2nd City.How Can i do this.
Thanks
What you need to do first is give a little more information.
We need your current table or query and the manner of splitting you require (Is it on each comma (,) etc).
Please post the MetaData (Name of table and Fields + Type of Fields) for tables and/or the SQL for queries.
Dear friends,
I have a problem.I want to break a column in which Address text is written, into two other column for Ist adrress and 2nd City.How Can i do this.
Thanks
If the column has a comma separating the two values then it's not too difficult.
You need to run the following query. -
UPDATE TableName SET [1st address]=Left([Address], InStr([Address], ",")-1), [2nd City]=Right([Address], InStr([Address], ",")+2)
-
Mary
Hi
I want to say that there is no comma in the text, text are seperated by space only. once again i told u---suppose it is the text in the column
C-43 Teacher Colony Deoband
i want to break the above example so that the first part C-43 should be in one column and Teacher Colony in 2nd column and Deoband should be in third column.
Plz help me.
NeoPa 32,556
Expert Mod 16PB
I cannot help much here as the MetaData is still unavailable.
However, I guess that you're talking about imorting text into the database rather than processing records already imported.
If you go through the Import Wizard (File / Get External Data / Import...) then there is an option to import as delimited.
Use this and set the delimiter to space.
I cannot help much here as the MetaData is still unavailable.
However, I guess that you're talking about imorting text into the database rather than processing records already imported.
If you go through the Import Wizard (File / Get External Data / Import...) then there is an option to import as delimited.
Use this and set the delimiter to space.
Also if the text file is set to fixed size fields you can import it as a fixed length text file.
Mary
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Joakim Braun |
last post by:
Greetings,
say I have a table with two rows of one column each.
How do I get the text of the second row's cell to line-break at the width of
the first row's cell, which is determined by the...
|
by: Eric Lindsay |
last post by:
I've seen a page using display, and especially display table that did
some neat things with boxes, but basically it only worked with Mozilla
browsers. Fell over fairly badly with Opera and Safari...
|
by: Owen T. Soroke |
last post by:
Using VB.NET
I have a ListView with several columns.
Two columns contain integer values, while the remaining contain string
values.
I am confused as to how I would provide functionality to...
|
by: cr115 |
last post by:
I'm knew to writing code and this might not make perfect sense but here goes.
I have a datagrid with multiple lines of data. The thing I want to do is have a button on the datagird that when i...
|
by: =?Utf-8?B?aXdlYg==?= |
last post by:
Can we set page breaks in ASP Pages dynamically based on the data being
populated?
Akshay.
|
by: jimmybaba |
last post by:
hi all i am newly graduate and started my first job.......i am geting problem to convert datetime into date only , i am trying to get values from sqlserver table with comparison of date. i am using...
|
by: coldy |
last post by:
Hi,
I have a large txt file (1GB) which I need to break into smaller files based on the contents of a column in the file.
The values in the column of intrest starts low, then increases, then...
|
by: DTV12345 |
last post by:
Greetings!
This is an excerpt from the Oracle documentation:"...ORACLE SQL*Plus BREAK command creates a subset of records and add space and/or summary lines after each subset. The column you...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |
