Convert Formatted Field Values to Text

[manjubarkavi]

how to convert a MsAccess database table which contains formated string values in the field (like ###99@<) to simple plain text format.

[nico5038]

Just create a query and format the field(s) as you like.
Next use the Export option when right-clicking the query to create a textfile when the SaveAs dialog opens chose .txt as filetype.

Nic;o)

[NeoPa]

how to convert a MsAccess database table which contains formated string values in the field (like ###99@<) to simple plain text format.

This really depends on what you mean.
Do you simply want to change the format of the data as displayed in Access?
Is the data stored in this format or is it simply displayed that way using the Format property?
Has the data itself been preformatted and you want to update the data in your table?

[manjubarkavi]

This really depends on what you mean.
Do you simply want to change the format of the data as displayed in Access?
Is the data stored in this format or is it simply displayed that way using the Format property?
Has the data itself been preformatted and you want to update the data in your table?

the data was preformatted using some functions which i didn't know ,all i want is to see the data in normal text format.

[NeoPa]

Well, I can't tell you how to do that until you answer my questions about how the data is currently.
I can't find that out without access to your database, so you'll have to do that for yourself.
If that's too complicated for you, let us know where you get stuck and we can help you. I don't intend to do everything for you though - you've got to put something in yourself.

[manjubarkavi]

Well, I can't tell you how to do that until you answer my questions about how the data is currently.
I can't find that out without access to your database, so you'll have to do that for yourself.
If that's too complicated for you, let us know where you get stuck and we can help you. I don't intend to do everything for you though - you've got to put something in yourself.

Respected sir,
as per ur advice on ur last reply ,i tried myself to change the text,
but all in vain.so once again i need ur help in this matter. first i explain the things. i have a database with 35 tables .content of all tables is in the text format except one table.that table contains some kind of text like currency or dollar format text.a sample of words in one column of the table is m?(>8!9m$#m!).like this all values in all coloumns on that table looks.pls give me a solution to convert this type of text into normal text format.i will be very thankful too you if you do that.i am a small girl & not so fluent in english.so if any kind of mistakes in my way of telling, pls forgive me.waiting 4 ur reply.

[Rabbit]

Respected sir,
as per ur advice on ur last reply ,i tried myself to change the text,
but all in vain.so once again i need ur help in this matter. first i explain the things. i have a database with 35 tables .content of all tables is in the text format except one table.that table contains some kind of text like currency or dollar format text.a sample of words in one column of the table is m?(>8!9m$#m!).like this all values in all coloumns on that table looks.pls give me a solution to convert this type of text into normal text format.i will be very thankful too you if you do that.i am a small girl & not so fluent in english.so if any kind of mistakes in my way of telling, pls forgive me.waiting 4 ur reply.

What are these functions you keep speaking of?

[NeoPa]

Respected sir,
as per ur advice on ur last reply ,i tried myself to change the text,
but all in vain.so once again i need ur help in this matter. first i explain the things. i have a database with 35 tables .content of all tables is in the text format except one table.that table contains some kind of text like currency or dollar format text.a sample of words in one column of the table is m?(>8!9m$#m!).like this all values in all coloumns on that table looks.pls give me a solution to convert this type of text into normal text format.i will be very thankful too you if you do that.i am a small girl & not so fluent in english.so if any kind of mistakes in my way of telling, pls forgive me.waiting 4 ur reply.

I don't blame you for any mistakes in English. I simply don't understand what you're asking for. It doesn't matter if you're a little girl or a big man - if I can't understand then I can't answer.
You don't explain what needs to be converted to what in your post. Your example doesn't help me to understand what to change to what. Nor have you explained how your data is stored - which tables? which fields in the tables? etc.

[manjubarkavi]

Sir, it is a msaccess database table which contains two coloumns id & description with twenty rows.the field value of rows of id column contains 1,2,3.... and the field value of rows of description contains symbols like m>4!9#$ like that.New to msaccess i dont know how it was stored.Thats what i am unable to explain u correctly.It was a sample northwind database that was installed when i bought my system.I do self study learning of msaccess by doing step by step excersices.Now i am doing excersices of converting the values to another data types and suceeded through the formating option and save as option.This one i am unable to do it.Due to curiosity i am asking u this sir.

[NeoPa]

OK, we seem to be getting closer. Please answer all the following questions.

1. Do you want to display the changed data in a query? OR update the data in the same table it's already in? OR write the updated data into a new table?
2. What change do you want to do to the data?
3. Is it currently stored as Text in your table?

Lastly, can you post the actual data if it's only 20 lines. It's hard to know what sort of data you're talking about with just a couple of strange examples.