f



Insert carriage return in a text field to warp text down

I've imported data from a database - containing separate fields for
name, address and postcode, into one single text field in another
database (I know that's rotten database practice, but I was asked to
do this at work).

I concatenated the fields in the "donor database then mapped the
single concatenated field to the recipient single text field on
import. I now have a field containing name, address and postcode, with
spaces between each element(I inserted them), but of course there is
no wrapping. I now have (example)

MrTest Name Test Address TestPostcode

in a single text field.

I'd like to bring this dbase file into Access and use a function/vb to
insert the carriage return at the end of each element so text is
wrapped correctly. Does anyone know how to do this please?

I could envisage writing a character (eg a comma or asterisk) at the
end of each piece of data, prior to performing the concatenation so
that this character could be used as a criterion for a function
inserting a break, but I'm not very experienced in parsing strings
etc, so the idea hardly solves my problem.

Any help would be appreciated.

Thanks
Greg
0
8/16/2003 6:04:02 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

2 Replies
1101 Views

Similar Articles

[PageSpeed] 52

gregory.oxnard@ntlworld.com (Greg Oxnard) wrote in 
news:7dee7a8c.0308161004.443136a4@posting.google.com:

> I've imported data from a database - containing separate fields for
> name, address and postcode, into one single text field in another
> database (I know that's rotten database practice, but I was asked to
> do this at work).
> 
> I concatenated the fields in the "donor database then mapped the
> single concatenated field to the recipient single text field on
> import. I now have a field containing name, address and postcode, with
> spaces between each element(I inserted them), but of course there is
> no wrapping. I now have (example)
> 
> MrTest Name Test Address TestPostcode
> 
> in a single text field.
> 
> I'd like to bring this dbase file into Access and use a function/vb to
> insert the carriage return at the end of each element so text is
> wrapped correctly. Does anyone know how to do this please?
> 
> I could envisage writing a character (eg a comma or asterisk) at the
> end of each piece of data, prior to performing the concatenation so
> that this character could be used as a criterion for a function
> inserting a break, but I'm not very experienced in parsing strings
> etc, so the idea hardly solves my problem.
> 
> Any help would be appreciated.
> 
> Thanks
> Greg

I expect there will be some suggestions made about parsing functions.

I would point out that if you can connect to your dBase source using ADO 
and create an ADODB recordset, you can use
GetString(adClipString, 1, vbNewLine)
to return each address already formatted as you describe, and can then use 
some query string to append that to your recipient? table.

-- 
Lyle

0
lylefair1 (164)
8/16/2003 6:18:29 PM
Another way would be to use a fixed length string.  Say the name portion is
always 30 characters, the address starts at position 31 and is always the
next 50 characters and so on.  In the importing database you can do what
ever you want because you'll know the start and stop position of each
element of the string.

Example Export String:
"FirstName M LastName                            Address Starts at position
31                             Postcode starts at position 81
"

In the receiving database you could then use the portion of the string you
want such as the address: strAddress = MID(ImportString,31,50)
Mid(string, start[, length])



"Bob Quintal" <bquintal@generation.net> wrote in message
news:Xns93D99DF604FD5Bquintal@216.168.3.44...
> gregory.oxnard@ntlworld.com (Greg Oxnard) wrote in
> news:7dee7a8c.0308161004.443136a4@posting.google.com:
>
> > I've imported data from a database - containing separate fields for
> > name, address and postcode, into one single text field in another
> > database (I know that's rotten database practice, but I was asked to
> > do this at work).
> >
> > I concatenated the fields in the "donor database then mapped the
> > single concatenated field to the recipient single text field on
> > import. I now have a field containing name, address and postcode, with
> > spaces between each element(I inserted them), but of course there is
> > no wrapping. I now have (example)
> >
> > MrTest Name Test Address TestPostcode
> >
> > in a single text field.
> >
> > I'd like to bring this dbase file into Access and use a function/vb to
> > insert the carriage return at the end of each element so text is
> > wrapped correctly. Does anyone know how to do this please?
>
> Go back to the idi\\\person who told you to import the data as a single
> field, then tell them to fix it you need to re-import as separate
> fields. Then you can generate reports and mailing lists properly in the
> future, using concatenation to put the data on one line when
> appropriate. :)
>
> Otherwise, you'll need to write code to break the data at the
> appropriate points, concatenate Chr(13) & chr(10) & the next part of
> your string, another Chr(13) & chr(10) & the next part of your string
> and so on until you've completed the line.
>
> A lot of useless work, IMO.
>
>
>
> >
> > I could envisage writing a character (eg a comma or asterisk) at the
> > end of each piece of data, prior to performing the concatenation so
> > that this character could be used as a criterion for a function
> > inserting a break, but I'm not very experienced in parsing strings
> > etc, so the idea hardly solves my problem.
> >
>
> Given that the end of each piece of data may be different in length, may
> contain embedded spaces and possibly other punctuation, it's not easy
> for even an experienced programmer.
>
> > Any help would be appreciated.
> >
> > Thanks
> > Greg
>
> Bob


0
8/19/2003 3:28:52 PM
Reply:

Similar Artilces:

Insert text file in a text field ...
Hallo, I have 2 questions: 1) How can I insert a text file into a TEXT field of a table (by an sql instruction) ? 2) How can I insert a microsoft word file into a BLOB field of a table (by an sql instruction) ? Please, could you help me ? Thank you . Fab. On Thu, 18 Oct 2007 06:41:52 -0700, electric_r@yahoo.it wrote: > Hallo, > > I have 2 questions: > > 1) How can I insert a text file into a TEXT field of a table (by an > sql instruction) ? > > 2) How can I insert a microsoft word file into a BLOB field of a table > (by an sql instruction) ? > > Please, could you help me ? This is a task for the application program, not the database itself. -- A way of life that is odd or even erratic but interferes with no rights or interests of others is not to be condemned because it is different. -- Chief Justice Warren E. Burger electric_r@yahoo.it wrote: > Hallo, > > I have 2 questions: > > 1) How can I insert a text file into a TEXT field of a table (by an > sql instruction) ? > > 2) How can I insert a microsoft word file into a BLOB field of a table > (by an sql instruction) ? > > Please, could you help me ? > > Thank you . > > Fab. Look at the LOAD_FILE() function in the manual On 18 Oct, 14:41, electri...@yahoo.it wrote: > Hallo, > > I have 2 questions: > > 1) How can I insert a text file into a TEXT field of a table (by an > sql instruction) ? > > 2) How can...

Insert text file in a text field #3
Hallo, I have 2 questions: with php and mysql : 1) How can I insert a text file into a TEXT field of a table ? 2) How can I insert a microsoft word file into a BLOB field of a table ? Please, could you help me with a simple example ? Thank you . Fab On Thu, 18 Oct 2007 18:36:59 +0200, <electric_r@yahoo.it> wrote: > Hallo, > > I have 2 questions: > > with php and mysql : > > 1) How can I insert a text file into a TEXT field of a table ? > > 2) How can I insert a microsoft word file into a BLOB field of a > table ? > > Please, could you help me with a simple example ? mysql_query("INSERT INTO tablename (fieldname) VALUES ('".mysql_real_escape_string(file_get_contents('/path/to/file'))."')"); -- Rik Wasmus On Thu, 18 Oct 2007 19:29:54 +0200, Rik Wasmus <luiheidsgoeroe@hotmail.com> wrote: > On Thu, 18 Oct 2007 18:36:59 +0200, <electric_r@yahoo.it> wrote: > >> Hallo, >> >> I have 2 questions: >> >> with php and mysql : >> >> 1) How can I insert a text file into a TEXT field of a table ? >> >> 2) How can I insert a microsoft word file into a BLOB field of a >> table ? >> >> Please, could you help me with a simple example ? > > > mysql_query("INSERT INTO tablename (fieldname) VALUES > ('".mysql_real_escape_string(file_get_contents('/path/to/file'))."')...

text + text
What is "text + text" supposed to do right now? It doesn't seem very useful to me. What about making "text + text" as an equivalent for "text || text"? Most strongly-typed programming languages do this. And MS SQL Server too, I think (CMIIW). -- dave ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org Am Freitag, 8. Oktober 2004 12:57 schrieb David Garamond: > What is "text + text" supposed to do right now? Nothing. > What about making "text + text" as an equivalent for "text > || text"? Most strongly-typed programming languages do this. And MS SQL > Server too, I think (CMIIW). What would this gain except for bloat? It's not like SQL is utterly compatible with any programming language; users will still have to learn all the operators anyway. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match Peter Eisentraut wrote: >>What is "text + text" supposed to do right now? > > Nothing. Then are these bugs? (7.4.5 and 8.0.0beta1 give same results). Frankly, the current behaviour is quite strange to me. ------------------ =...

Carriage Return in text field on form?
Can I change the behavior of using the enter key in a text box? The current behavior when using a carriage return is that you will be taken to the next field. I don't want that to occur, I want the cursor to go to the next line in the same field. Possible? Thanks again in advance! Tom You can if the field is a memo. You have to trigger editentermemoview when you arrive or go into edit mode. See the constants section of the opal help. Denn Santoro President Resource Development Associates http://www.RDAWorldWide.Com Offices in the United States and Germany Provi...

text-text
Wondering how what I input to my UTF-8 terminal gets passed along through my patched [1] trn ... Cyrillic: А Б В Г Д Е Ж З И Й К Л М Н О П а б в г д е ж з и й к л м н о п IPA: ᴀ ᴁ ᴂ ᴃ ᴄ ᴅ ᴆ ᴇ ᴈ ᴉ ᴊ ᴋ ᴌ ᴍ ᴎ ᴏ ɀ Ɂ ɂ Ƀ Ʉ Ʌ Ɇ ɇ Ɉ ɉ Ɋ ɋ Ɍ ɍ Ɏ ɏ [1] https://groups.google.com/d/msg/comp.sys.raspberry-pi/7Z37Hdrm0DM/6aqD-reXFzAJ ...

Unbound text box, text>255, MS Access/PostgreSQL
Hello. I have the following problem with MS Access/PostgreSQL combination: There is a form in Access that has an unbound text box, used for entering a commentary of a batch of records. There is a DAO Append Query that has a parameter that is passed from the text box using parameter of DAO QueryDef object. I adjusted B7 parameter (Text as LongVarchar) in connection string (ODBC driver) to 1, so that Access links PostgreSQL Text fields as Memo fields in Access. The intention was to be able to enter unlimited length commentary into the field. But, although I can enter unlimited text by using bound text box in some other forms, in this particular form I can't use bound control, so I need to pass text from UNBOUND control to the linked table by using DAO or ADO code. It seems that DAO query can't accept Memo as parameter, but only text. If my text exceeds length of 255, I have an VBA error 3271. If text in unbound text box is shorter that 255 everything is OK. So, is there any way to pass text of length >255 from unbound text box to Memo field of linked PostgreSQL table, by using DAO or ADO ? Thanks in advance, Zlatko On Mon, 3 Oct 2005 01:15:54 +0200, "Zlatko Mati�" <zlatko.matic1@sb.t-com.hr> wrote: >Hello. >I have the following problem with MS Access/PostgreSQL combination: >There is a form in Access that has an unbound text box, used for entering a >commentary of a batch of records. >There is a DAO Append Query tha...

Why does the Database Connectivity Toolkit not return my text fields?
I'm running LV 8.2.1 and have the Database Connectivity Toolkit. My database is served by MS SQL Server 2005.&nbsp; The table looks like this: &lt;meta http-equiv="Content-Type" content="text/html;charset=UTF-8">dbo_Test dbo_Test ID Text 1 abc 2 def 3 slkdfj 4 owierlkjsdf 5 soiwuers A snapshot of my vi block diagram is attached.A snapshot of my vi front panel is attached.Where is the text?<img src="file:///C:/DOCUME%7E1/s156556/LOCALS%7E1/Temp/moz-screenshot.jpg" alt=""><img src="file:///C:/DOCUME%7E1/s156556/LOCALS%7E1/Temp/moz-screenshot-1.jpg" alt=""> vi.jpg: http://forums.ni.com/attachments/ni/170/312825/1/vi.jpg vi-fp.jpg: http://forums.ni.com/attachments/ni/170/312825/2/vi-fp.jpg kc64, I don't think I completely understand the problem.&nbsp; Can you go into more details of exactly what is the issue you are experiencing? ...

Splitting a text field conatining a carriage return.
I have a field in an access 2000 database that is actually three lines of text separated by carriage returns. Is there a function in the Access version of SQL that will let me locate the carriage returns and then split the field based on the positions of the carriage returns? Or do I need to process the field with Visual Basic? I seached for an answer to this on the web. I found an answer that said to use the CHARINDEX function but that is apparently not a part of ACCESS 2000 because I get an error message saying that it is invalid. Thanks in advance for your help. Greg Teets Cincinnati Ohio USA On Thu, 30 Dec 2004 20:06:19 GMT, Greg Teets wrote: > I have a field in an access 2000 database that is actually three lines > of text separated by carriage returns. > > Is there a function in the Access version of SQL that will let me > locate the carriage returns and then split the field based on the > positions of the carriage returns? > > Or do I need to process the field with Visual Basic? > > I seached for an answer to this on the web. I found an answer that > said to use the CHARINDEX function but that is apparently not a part > of ACCESS 2000 because I get an error message saying that it is > invalid. > > Thanks in advance for your help. > > Greg Teets > Cincinnati Ohio USA If your version of Access has the Split() function (look it up in VBA Help), you can use it to parse the field into 3 different par...

Inserting text into MS Access with ASP.NET
Hello all, Can anyone out there please explain me how to insert text wich is formatted into an access database via ASP.NET? Now, I can insert plain text (without characters like ' and page breaks, bold or cursive format, etc...). When I try to insert 'chris' then I get a query error (wich is logical, since the SQL interpreter doesn't know anymore where the query statement ends). Is there any way to avoid this error while inserting special characters and formatted text? Thanks in advance guys for your help! Greetz Chris c_cools@hotmail.com (Chris Cools) wrote: >Can anyone out there please explain me how to insert text wich is >formatted into an access database via ASP.NET? This is more of an ASP.NET configuration question than an Access question. I know a little of the answer but only enough to be very dangerous. <smile> Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm "Tony Toews" <ttoews@telusplanet.net> wrote in message news:c3kl101mjdt2lolmlblupvk5mie1aro45f@4ax.com... >Comments: This message did not originate from the Sender address above. > It was remailed automatically by anonymizing remailer software. Please ignore this posting. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so...

Re: Replace a carriage return in a text field
----=_vm_0011_W853083665_20681_1178885376 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I usually unload the primary key and the field in question to a file on unix, and use the 'tr' command to get rid of any control characters, then load it back up with a sql statement. <DIV><FONT face=Verdana size=2>&nbsp;</FONT></DIV> <br> ======================== <br> email: floyd@fwellers.com <br> Home: 703-430-0805 <br> Cell: 703-477-6045 <br> ======================== <br> <br> www.one.org <br> <br> <br> <br> >-----Original Message----- >From: jared.hanks@gmail.com [mailto:jared.hanks@gmail.com] >Sent: Thursday, May 10, 2007 09:05 PM >To: informix-list@iiug.org >Subject: Replace a carriage return in a text field > >Hello, > >I need to remove carriage returns in a text field. Does anyone know >how to do this? I've tried the following: > >update item_table >Set long_description = replace(long_description,"~r"," ") >where inv_id = "130539"; > >and I get the following error: "674: Routine (replace) can not be >resolved." > >I've also tried: > >Update items_table >Set long_description = replace(replace(long_description, >char(10),char(13)),char(13),' ') >where inv_id = "1305...

Parsing out data on text field in MS ACCESS
Hi All, A newbie here having a hard time figuring out how to parse out the City, State and Zip from a text field. I have a text field called "Registration" with a size of 40. In this field there are city, state and zip information. I need to seperate all three items into their own respective fields. Unfortunately, the information varies in size and location. An example, would be: "LOS ANGELES CA90063 ", while another record would be "LOS ANGELES CA90063". If anyone can point me to any references or examples on the web, it would be greatly appreciated. Thanks. Assuming that you have "inherited" this structure, and need to sort it out one time, after which it will stay in its separate fields, I'd suggest this procedure: Export the table to Excel. Use Data - Text to Columns to separate the data Re-import to Access. HTH - Turtle "Ronnie" <cyberron28@earthlink.net> wrote in message news:51be4a51.0401081529.2b96be83@posting.google.com... > Hi All, > > A newbie here having a hard time figuring out how to parse out the > City, State and Zip from a text field. I have a text field called > "Registration" with a size of 40. In this field there are city, state > and zip information. I need to seperate all three items into their > own respective fields. Unfortunately, the information varies in size > and location. An example, would be: > "...

text field only for text
Hi I would like some help about the following : I have a text field and I don't want it contains any numbers. How can I limit this situation ? So far, I couldn't find literature exacly about this here in the newsgroup. TIA Paulo "Paulo Rodrigues" <amigo.alf@netvisao.pt> wrote in message news:<newscache$kgmtmh$bb1$1@newsfront4.netvisao.pt>... > Hi > > I would like some help about the following : > > I have a text field and I don't want it contains any numbers. How can I > limit > this situation ? > > So far, I couldn't find literature exacly about this here in the newsgroup. > > TIA > Paulo Paulo, the online help is your FRIEND. Private Sub Text0_KeyPress(KeyAscii As Integer) If KeyAscii >= 48 And KeyAscii <= 57 Then KeyAscii = 0 End If End Sub Just put this code in the KeyPress event of whatever text field you do not want to contain numbers. OR you could glue thumbtacks to the number keys on all your users keyboards... Thought I'd add my 2 cents worth. Avoid magic numbers, especially when you can use builtin VBA constants. The following is a little more intuitive to read and a future developer does not have to lookup 48 and 57 to see exactly what is being blocked. Private Sub Text2_KeyPress(KeyAscii As Integer) 'Cancel any numeric keys If KeyAscii >= vbKey0 And KeyAscii <= vbKey9 Then KeyAscii = 0 End If End Sub The above solu...

rich text in text field
I am using GUIDE for my UI work. (MATLAB 2009b) I would like to display some rich-text (font size change, bold, underline etc) inside a panel. Can I put some rich-text, using html tags, in a text field? For example: <html><b> this is bold </b></html> I know you can do it in table headers. Thank you. ...

Search for text in a text field
Hi When posting a search box for the users, how do you take their input and search whether or not it is contained in a text field in many records and then diplay the records which contains the input. Thanks in advance, Luke. There is a function called InStr that will probably do what you require. Cheers, Chris "Luke Jones" <luke_jones_82@yahoo.co.uk> wrote in message news:24bb1508.0407080157.d587c63@posting.google.com... > Hi > > When posting a search box for the users, how do you take their input > and search whether or not it is contained in a text field in many > records and then diplay the records which contains the input. > > Thanks in advance, > > Luke. ...

Text filtering in a text field
Hi, am new to SKILL and would like to do some text checking and filtering for illegal characters in the text field. Meaning I have a text field in my form that is only to be with text, not any of the symbols (i.e. ~!@#$%^&* and so on). When the user input and saved the fields, those characters won't be allowed to be saved. What will be the best way to filter out only text? Only numbers? Terence <terrylau77@gmail.com> writes: > Hi, am new to SKILL and would like to do some text checking and > filtering for illegal characters in the text field. Meaning I have a > text f...

Remove Carriage Return in Access Exported Text File
Hi All - I have some data that I export from Access to a pipe-delimited text file. Unfortunately, the text file always has a carriage return symbol at the end. I need to export this file frequently and send to a system that cannot accept this character at the end of the file. I am looking for a way, perhaps with VB code, to automate this process. I found this code on another Google Group, but I can't get it to work. Any advice appreciated. :O) Here is that code: Function RemoveCarriageReturn_UMG() Set fso = CreateObject("Scripting.FileSystemObject") Set NewFile = fso.CreateTextFile("C:\hello.txt") Set file = fso.OpenTextFile("C:\return.txt") Do While Not file.AtEndOfStream CLine = file.ReadLine CLine = Replace(CLine, vbCrLf, "") NewFile.Write CLine Loop file.Close NewFile.Close Set NewFile = Nothing Set file = Nothing Set fso = Nothing End Function You need to search for chr(10) and chr(13) and replace them "Ellen" <ellenchriston@gmail.com> wrote in message news:1168944047.244816.224500@m58g2000cwm.googlegroups.com... > Hi All - > > I have some data that I export from Access to a pipe-delimited text > file. Unfortunately, the text file always has a carriage return symbol > at the end. I need to export this file frequently and send to a system > that cannot accept this character at the end of the file. I am looking > for a way, perhaps with VB code, to automat...

How to import a tab delimited text file into MS Access database
Hi, I have the following task to be done in VC++ 6.0. I have a tab delimited text file that needs to be imported into a MS Access table. The table is created and the table structure is defined using DAO methods. So now I have to fill this table with the data in the text files. For a few rows in the text file, the number of columns could be less than the number of columns in the table. Can anyone please post me the code to do this. Thanks a ton in advance. Pradeep wrote: > I have the following task to be done in VC++ 6.0. We'd be happy to give you the VBA code, but do you really want to throw away your C++ and use Microsoft Access for the job? If you want to keep C++, you can ask for C++ code in another newsgroup, because we'd just be guessing. -- Message posted via http://www.accessmonster.com ...

Forcing a New Line in a Text Field in MS Access using VB
Heya! I feel I'm beating an old horse to death with this question but I can't get around the problem. I want to update a text field on a form with a string from a VB module. I need enter/linefeeds in the string. I've tried: Chr(10) & Chr(13) Chr(13) & Chr(10 vbnewline vbcrlf none of which seem to work. I've set the properties for the text box to [Enter Key Behavior] = 'New Line In Field' and [Can Grow] = 'yes'. At the moment, my code looks like this: celsql = celsql _ & "Program: " & encname _ & vbCrLf _ & vbCrLf _ & "Start Time: " & sttim _ & vbCrLf _ & "Participants: " & numpart _ & vbCrLf _ & "Confirmed by Curator: " & cbc _ & vbCrLf _ & "Client: " & clntnm _ & vbCrLf _ & "Contact: " & cntct _ & vbCrLf _ & vbCrLf Forms(frm)(bts) = celsql If I toss this string into a [MsgBox], it comes out fine. It's just something about the text field... I'm working in MSAccess 2007, but need it backwards compatible to 2003. I'd really appreciate any advice. Cheers, KG I've seen this type of problem before, but I typically just use a separate text box for each data field. Is there a par...

MS Qry and text field to date field
I am using MS Query to pull files (from IBM AS400) and put them in Excel. However, when I do this the dates are now text fields. The text/ Date field looks like this: 20070331 (YYYYMMDD) I would like the change this text to a date field so Excel will see it as a date. Can someone please help me? I have looked all over the place for a solution and I have found nothing. Also, if you know of a good place to get information on MS query please let me know. /Thanks! wwolford wrote: > I am using MS Query to pull files (from IBM AS400) and put them in > Excel. However, when I do this the dates are now text fields. The text/ > Date field looks like this: 20070331 (YYYYMMDD) > > > I would like the change this text to a date field so Excel will see > it as a date. > > Can someone please help me? I have looked all over the place for a > solution and I have found nothing. > > Also, if you know of a good place to get information on MS query > please let me know. > > /Thanks! > In Access you could use DateSerial. Ex: x ="20070331" ? dateserial(left(x,4),Mid(x,5,2),mid(x,7,2)) ...

Problem with carriage return/newline character when writing SAS database to a text file...
I had a table in Excel which included an ID (identification number), COMMENTS, and AMOUNT column. The COMMENTS column were text notes (up to 2000 characters) commenting on the corresponding ID. I imported this table (via proc import) into a SAS dataset and then used the file and put statements to write the dataset to a fixed-length text file (i.e., for each record, the ID variabe was outputted to positions 1-4, COMMENTS outputted to positions 6-2005, and the AMOUNT column outputted to positions 2007-2012). The text file, however, did not come out how I expected because some of the text in the COMMENTS field wrapped over to the next line in the text file (each record is supposed to appear on only one line in the text file, not multiple lines). When I looked into the COMMENT field in the SAS dataset I created, I noticed some tiny black, rectangular symbols that appeared sporadically throughout some of my records. I'm assuming those symbols represent a carriage return/newline character (I don't know what the exact terminology is for it)?? I noticed that wherever those symbols appeared in the SAS dataset is where the text file broke to a new line when the dataset was written to the text file. Is it possible to eliminate this carriage return (or whatever it's called) symbol is SAS? For my text file to be correct, I need to have each dataset record appear on only one line in the text file and it appears as though it is this carriage return which is making some of the ...

how to import text field from MySQL db to MS Access 2003 using ImportXML
Hi Guys, I'm trying to import data out of MySQL db to MS Access 2003 using ImportXML. I don't have any problems doing the import, except for one table with a "text" field defined. I'm getting an error message saying "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.". Thanks, Do you have to use ImportXML? Why can't you use the ODBC driver to MySQL? Linda <nepifanio@gmail.com> wrote in message news:1137431763.824498.100740@g44g2000cwa.googlegroups.com... > Hi Guys, > > I'm trying to import data out of MySQL db to MS Access 2003 using > ImportXML. I don't have any problems doing the import, except for one > table with a "text" field defined. I'm getting an error message saying > "The field is too small to accept the amount of data you attempted to > add. Try inserting or pasting less data.". > > Thanks, > MS Access is not allowed to directly access the data from mysql db. The data from mysql db is exported in xml format using a system (with user login/password) and then imported into MS Access. I'm not exactly sure what cosmic events make it work for me, but I do it all the time. I access tables in a MySQL database using MS Access. I make edits and run reports. Linda <nepifanio@gmail.com> wrote in message news:1137532447.886457.233460@g14g2000cwa.googlegroups.com... > MS Acces...

Get the real type of columns from MS Access databases(OLEObject, text, memo, numeric)
Hello, I made one application that opens MS Access databases.And I have one problem.How can I find the real data type of columns(text, memo, OLEObject, numeric) like it is into Access.I tried with resultSetMetaData.getColumnType(columnIndex) but I receive java.sql.Types.I have two columns that contains OLEObjects(images).But I receive two different types for columns : VARCHAR once, and for second column SMALLINT.I only want to see the types like in Access(OLEObjects, Text, Numeric, Memo...).Thanks in advance! Best regards, Calin Pop ...

Re: How can labview update the string control (text-edit box) after we have pressed the carriage return key on the keyboard during text-editing within that box?
Hello Alberto, &nbsp; I have trouble to edit an exited text file and save it after the content changed. Can you please&nbsp;help me out? &nbsp; Thanks, Jason&nbsp; ...

Accessing text form fields name=field[label]
I'm pretty much a JavaScript novice. I'm good at learning by example and changing those examples to suit my needs. That said .... ..... I have some select fields in a form I created for a database search that I am unable to figure out how to access. (The search is implemented in Php/MySQL.) The user enters search values for: name, address1, city, .... etc., ..... and for each of these they also select whether the search should look for the field to be equal to, not equal to, Like, or Not Like the value in the database. So in the form I have: <input type=text name=city> in combination with <select name=func[city]> <option value='='>=</option> <option value='!='>!=</option> <option value='LIKE'>LIKE</option> <option value='!='NOT LIKE>NOT LIKE</option> </select> For an example, this search could be to find an entry "WHERE city $func[city]] $city. (Php - e.g., WHERE city = 'Denver'). This works fine - in Php. I use similar combinations for name, address, etc., ... Okay, here's the JavaScript problem. For the Reset action I have a JavaScript function to Reset all the form fields. I want to Reset the selected indexes for the "func" fields (func[name], func[city], func[state], ...) using a loop that goes through the associative array, "func." I cannot find the right syntax to address them as an array and I am beg...

Web resources about - Insert carriage return in a text field to warp text down - comp.databases.ms-access

Carriage - Wikipedia, the free encyclopedia
A carriage is a wheeled vehicle for people, usually horse-drawn; litters (palanquins) and sedan chairs are excluded, since they are wheelless ...

Carriage - Wikipedia, the free encyclopedia
A carriage is a wheeled vehicle for people, usually horse-drawn; litters (palanquins) and sedan chairs are excluded, since they are wheelless ...

Train Chartering - private First Class carriage from London - Flickr - Photo Sharing!
Train Chartering organises private carriages on scheduled train services throughout Europe, inclduing the UK. This is a First Class carriage ...

Amish Kids Racing with Carriages - YouTube
... Watch Queue TV Queue Remove all Disconnect Loading... Watch Queue TV Queue __count__/__total__ Find out why Close Amish Kids Racing with Carriages ...

Calls for ban after horse pulling carriage of six bolts in CBD
A spooked horse pulling a carriage&nbsp;has bolted across tram tracks on St Kilda Road, throwing its driver from his seat.

Historic rail carriages destroyed in fire at the Newport rail yards
Two historic rail carriages were destroyed when a suspicious fire ripped through a shed at the Newport rail yards in Melbourne's inner-west early ...

Sydney Metro Northwest: Transport minister unveils life-size model of Metropolis carriage - DailyTelegraph ...
THIS is the first glimpse of Sydney’s new single-deck driverless trains that are set to run on the city’s new Metro network from 2019.

Catwalk in carriages: Fashion launch on Perth train
IT’S not a typical runway where you’d expect to find the latest fashions.

Catwalk in carriages: Fashion launch on Perth train - PerthNow Search Search
IT’S not a typical runway where you’d expect to find the latest fashions.

Swiss train carriage plunges into ravine
A landslide has derailed a passenger train in Switzerland sending one carriage plunging into a ravine.

Resources last updated: 3/21/2016 11:06:34 PM