Topics Search

split a column into two seperate columns

split a column into two seperate columns
Views: 60
I was wondering if it possible to use an expression in a query to split one column in a table into two seperate columns. Column X is Description and looks like this, for example.
2,500 @ $21.55. The @ symbol is always present so I essentially want to wind up with two columns Quantity (2,500) and Price
Sponsored Links:

More topics

 

How to split the content of one column into 4 columns?

Preview
How to split the content of one column into 4 columns?

Please, see the attached image that shows my question
Attached also the table
i need to split the column that contains the N E values into 4 columns
Why I need this?

Im given the coordinates in long-lat and I need to convert them into XY, so first I need to convert them into Decimal degrees then to be converted to xy.
 

Macro to export to word?

Preview
I have an access table that has 2 columns. I need each line exported to a seperate word document. Column A and Column B (where A goes on top of word doc and B near the bottom of the word doc).

I will have about 2000 lines that need to go to seperate word doc
 

Split string into Date and Time Columns?

Preview
I am looking for assistance in a sql query in MS Access 2007.

I have imported a table into access. One of the columns is a column called DTG_LOCAL (which is short for Date/time group local time). This column is a string column with the format DDMMMYYYY:HH:MM:SS or 01JAN2010:13:40:00.

I am looking for a sql query that will take the string DTG_LOCAL column and break out DDMMMYYYY and HH:MM to their own columns with an additional column with just HH for a total of three new columns with the broken out information. The three columns would be DATE, TIME, and HOUR; Lastly, convert the columns from a text column to DATE/TIME respectively.

DTG_LOCAL --> DATE / TIME / HOUR or
01JAN2010:13:40:00 --> 01JAN2010 / 13:40:00 / 13

The other columns in the file are not deleted.

The table name is GPS_AI_Import
 

Splitting One Column Into Multiple Columns

Preview
I have an Excel workbook, where a language column has 1 to 5 languages. For example:
Language
Record 1: English
Chinese
Spanish

The 3 languages are separated by hitting the enter key, and not the space bar key. I have about 400 records of this issue.

Is there a way I can split the language column into 5 columns at most? And then, if a record only has 3 languages, only the first 3 columns are populated?

FYI, I have MS Access
 

Default Split Form Column Layout

Preview
I have a form displayed in Split Form view. A certain number of columns show in the datasheet portion of the form. How do I set which default columns show and in what order? I know how to unhide and move columns around, but it changes everytime you leave the form.
 

Default Split Form Column Layout

Preview
I have a form displayed in Split Form view. A certain number of columns show in the datasheet portion of the form. How do I set which default columns show and in what order? I know how tounhide and move columns around, but it changes everytime you leave the form.
 

Split Data in a column in Excel, via VBA Code in Access

Preview
I have an excel file I need to read and update a column in an access table. But the data I need is in a combined format like AA-000, BB-001 etc.
I need to separate the values AA, BB as one column and 000,001 as another column.

So the tasks I need to do is:
read in the Excel file
split the data in a column in to two columns
update the already existing access table with the data in the two new columns.
 

Splitting positive and negative figures into seperate columns

Preview
hoping someone can help

I have a table called Table1 and within it are various columns including a Transactions column that contain both credit and debit (positive and negative) transactions. As well as the Transactions column in Table1 there is also an Account Number column. There are several account numbers and each account number has several transactions.

The end goal is to create a query that splits the debit/credit transactions into separate columns and then totalled for each account.

Iv tried creating one query with <0 criteria under the Transactions field for negative and vice versa for positive then a third to bring the two columns together but its not really working!

Ideally it would be great to do from one query but think it may be unlikely to do from the query design view.

Whilst I have no experience with SQL, I am confident of following any clear guidance offered
 

Split a field

Preview
Have a table column which has data like 1, First and Last name. Trying to split that data into 2 columns: Team_Num (which is the above 1) and Name (which is above First and Last name
 

Auto resize columns in split forms

Preview
Just to confirm, is it true you can't auto resize column widths in Split Forms using VBA code?

For example :

Me.[nameOfColumn].Columnwidth = -2

This doesn't seem to work in my split form