User Profile

Collapse

Profile Sidebar

Collapse
goodaan
goodaan
Last Activity: Jul 12 '16, 07:55 PM
Joined: Dec 20 '15
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • goodaan
    replied to Removing text from the middle of a string - in Access
    in Access
    Bingo! I could kick myself as the answer is in fact very simply. I am new to Access and do not know the InStr function. I should have thought how to do this in BO or Excel. The Trim works, as well as -2 instead of -1 from the left position.

    I suppose I thought everyone uses queries in Access since I am not a programmer - I'll try to be clearer next time. Thank you zmbd for the answer I was looking for. Thanks to all others who joined...
    See more | Go to post

      Leave a comment:

    • goodaan
      replied to Removing text from the middle of a string - in Access
      in Access
      What is this lecture?

      I've read all answers. I also gave EXACTLY what I am looking for. You all give a string as an example. I am working with a variable string in a field.

      Yes I do understand the theory. No I have not found anything that helps me. Either my syntax is wrong or it's not possible to replace the Str with a field. ZMBD said it was not possible with a field.

      If I take this answer:
      ...
      See more | Go to post
      Last edited by zmbd; Dec 24 '15, 06:39 PM. Reason: [z{stepped the equation to make it easier to follow :) }]

        Leave a comment:

      • goodaan
        replied to Removing text from the middle of a string - in Access
        in Access
        Yes this is the sort of answer I am looking for. However I am using the expression Builder in a query, and I have a field name instead of strA:

        Code:
        TO_DESCRIPTION: left([FROM_DESCRIPTION],len([FROM_DESCRIPTION]) - instr(1, [FROM_DESCRIPTION], "(",0)) + right( [FROM_DESCRIPTION], len([FROM_DESCRIPTION]) - instr(1, [FROM_DESCRIPTION], ")", 0))
        I suppose this cannog be done directly in a query? If I have to...
        See more | Go to post
        Last edited by zmbd; Dec 22 '15, 02:35 PM. Reason: [z{please use the [CODE/] format for scipt/SQL thnx:) }]

          Leave a comment:

        • goodaan
          replied to Removing text from the middle of a string - in Access
          in Access
          I'm afraid I'm new to Access. I tried this to find the first parentheses but the syntax is no good:

          FIND_PARENTH: InStr(1, [COM_APP_LNK_DES CRIPTION], "(" )
          See more | Go to post

            Leave a comment:

          • goodaan
            replied to Removing text from the middle of a string - in Access
            in Access
            How do I use your pattern? The following gives an error:

            COM_NEW_DESCRIP TION: Replace([COM_APP_LNK_DES CRIPTION],"\([\s\S]*?\)","")
            See more | Go to post

              Leave a comment:

            • goodaan
              replied to Removing text from the middle of a string - in Access
              in Access
              thank you for your suggestions. I will try the 1st & 2nd method. And I will keep in mind the names (I usually say brackets for parentheses, square brackets for brackets). Regards
              See more | Go to post

                Leave a comment:

              • goodaan
                started a topic Removing text from the middle of a string - in Access
                in Access

                Removing text from the middle of a string - in Access

                I have string values as follows:
                RM - B08 - (1510) EXTERNAL
                IRMM - D01 - (M21305) MANAGEMENT
                RM - B03 - (S-1120) TRAINING
                IES - H02 - (A24007) AIR
                IET - F06 - (A13102 / A13111 / A13206) ENERGY TECHNOLOGY

                How can I remove the middle code surrounded by brackets - using Access?
                See more | Go to post
                No activity results to display
                Show More
                Working...