Access VBA remove CR & LF only from the beginning of a text string by searching for them

Posted by uZI on Stack Overflow See other posts from Stack Overflow or by uZI
Published on 2010-03-28T15:16:00Z Indexed on 2010/03/28 15:23 UTC
Read the original article Hit count: 312

Filed under:

access-vba

|

search-and-replace

|

find-and-replace

|

crlf

|

linebreaks

Hi there

I need to remove line breaks from the beginning of a memo type records. I dont want to use the replace function as it would remove all line breaks from the record which is not desired. Its only the line breaks at the beginning of the field that I am interested in removing.

Furthermore, the my records do not always begin with a line break so I cant really use text positioning, the solution would be to look for line break at the beginning instead of always expecting it at the beginning.

click here for a sample of what my data looks like

any help will be greatly appreciated

© Stack Overflow or respective owner

Related posts about access-vba

T-SQL Equivalents for Microsoft Access VBA Functions

as seen on Internet.com - Search for 'Internet.com'
If you need to migrate your Access application to SQL Server, don't count on The SQL Server Upsize Wizard in Microsoft Access to automatically convert your VBA functions. If you want to push the complex query processing done by your Access queries to the back end, you'll have to rewrite them in T-SQL. >>> More
Access VBA sub with form as parameter doesn't alter the form

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Microsoft Access 2003 file with various tables of data. Each table also has a duplicate of it, with the name '[original table name]_working'. Depending on the user's choices in the switchboard, the form the user choose to view must switch its recordsource table to the working table. I… >>> More
Achieve Rails-style migrations in MS Access VBA application

as seen on Stack Overflow - Search for 'Stack Overflow'
This is a simple way to do Rails-style migrations in a VBA application. Just add additional migrations like migration(name, sql_string, database) to run_migratons and call run_migrations somewhere in the beginning of your execution. Function migrate(signature As String, sql As String, dbs As DAO… >>> More
Using INSERT INTO and setting one field value - Access VBA

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm using INSERT INTO to copy rows of data from one table to another: INSERT INTO tblNewCustomers (CustomerID, [Last Name], [First Name]) SELECT CustomerID, [Last Name], [First Name] FROM tblOldCustomers How can I set one of the field values in tblNewCustomers for all of the new records that… >>> More
MS-Access VBA: form_error vs on error

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to set up error handling for a MS-Access application. The standard method to do this seems to be with an On Error statement in each subroutine/function. It seems simpler to me to use the Form_Error function to catch all the runtime errors in that form as opposed to an On Error statement… >>> More

Related posts about search-and-replace

Regex: Search and replace left side = to right side

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I use regular expressions and search and replace to turn this [UserID] = <UserID, int,> [UserID] = 123123 [UserID] = asd123123 into [UserID] = [UserID] [UserID] = [UserID] [UserID] = [UserID] In other words I want to take everything from left side of the line up to the '=' character… >>> More
sed whole word search and replace

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How do I search and replace whole words using sed? Doing sed -i 's/[oldtext]/[newtext]/g' will also replace partial matches of [oldtext] which I don't want it to do. Thanks, Kenneth >>> More
Perl Search and Replace Avoid Variable Interpolation

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm really getting my butt kicked here. I can not figure out how to write a search and replace that will properly find this string. String: $QData{"OrigFrom"} $Text{"wrote"}: Note: That is the actual STRING. Those are NOT variables. I didn't write it. I need to replace that string with nothing… >>> More
C# string "search and replace" using a regex

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to do a 2 rule "replace" -- my rules are, replace all open parens, "(" with a hyphen "-" and strip out all closing parens ")". So for example this: "foobar(baz2)" would become "foobar-baz2" I currently do it like this -- but, my hunch regex would be cleaner. myString.Replace("(", "-")… >>> More
Search and replace macro in Netbeans

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I record (or write) search and replace macro in Netbeans? I want to record the actions I do in Ctrl+H dialog. >>> More