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

[jamal numan]

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?

I’m 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.

Thank you

[TheShabz]

Look up the Left() Mid() and Right() functions. You can use them in a query to get it done.

[ajetrumpet]

Look up the Left() Mid() and Right() functions. You can use them in a query to get it done.

even easier than this, would be to use the split() function. it would be much easier to write, as it would simply be a loop through the result array and assignment to each field.

it does depend on how large the set is though. the larger, the slow the function call would be. It would work easier simply because it appears that your data is always parsed by the space. is that true?

[jamal numan]

Thank you for the answer

Please, see the attached image

I don’t feel that I can do it! Well, what I’m looking for now is only how to get rid of the two letters (E and N.) from the column named position

Appreciated

Jamal

Look up the Left() Mid() and Right() functions. You can use them in a query to get it done.

[TheShabz]

If all you want to do is Remove the "E" and the "N", there is a handy tool called the Find/Replace.
1. backup your table
2. ctrl+H
3. choose the proper field in "Look In"
4. enter in E in "Find What"
5. enter in "" in "Replace With"
6. change "Match" to "Any part of field"
7. repeat 1-6 with N instead of E

[ajetrumpet]

If all you want to do is Remove the "E" and the "N", there is a handy tool called the Find/Replace.
1. backup your table
2. ctrl+H
3. choose the proper field in "Look In"
4. enter in E in "Find What"
5. enter in "" in "Replace With"
6. change "Match" to "Any part of field"
7. repeat 1-6 with N instead of E

yep! do this. the request is simpler than I thought

[weekend00]

a simpler way is(may need some knowledge of pattern to understand):
1. backup your table
2. ctrl+H
3. choose the proper field in "Look In"
4. enter in "[EN]" in "Find What"
5. enter in "" in "Replace With"
6. change "Match" to "Any part of field"
7. click "Replace All"

[TheShabz]

[EN] is interpreted as E OR N?

[jamal numan]

thank you for the answer.

i did the steps but it didn't work! what might be the problem!

please, see the attached image that shows how i did it!!!!!

i'm attaching also the access file itself...

thank you

yep! do this. the request is simpler than I thought

[TheShabz]

did you hit "replace all"?

[jamal numan]

thank you! i kept pressing next instead of replace!

but it replaces the N by the "", while i need to reomove the N but not replace it by "" or by even a spcae!!!

please, see that attached image about the result!


how can i do that?

appreciated

Jamal

did you hit "replace all"?

[TheShabz]

My mistake. "" is usually the indicator for empty string. Just leave the "replace with" blank. That should do it. Also, you'll have to manually delete the few that you already replaced, but that shouldn't be an issue.

Hit "replace all" instead of "replace". It'll save you some time.

[jamal numan]

thank you so much. your notes are very helpful. it did work

My mistake. "" is usually the indicator for empty string. Just leave the "replace with" blank. That should do it. Also, you'll have to manually delete the few that you already replaced, but that shouldn't be an issue.

Hit "replace all" instead of "replace". It'll save you some time.

[TheShabz]

Glad you got it working. If it's all working well, go ahead and mark the thread as solved so others can make use of it as well.

Thanks

[jamal numan]

Yes sure.

but:

- how to mark it as solved? i couldn't find the botton! could u please indictae me how?

- the title of the thread was to separat the columns into four! but what we did is just to remove the E and N

thank u

Glad you got it working. If it's all working well, go ahead and mark the thread as solved so others can make use of it as well.

Thanks