INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Extracting data between [ ]

Extracting data between [ ]

(OP)
Here's the data format:

[32] Event linked to [Warehouse] [BB16027901]

I'm trying to figure out a way to isolate BB16027901 above and I can't do it with a mid() formula since the database has changed. As seen above there are 3 sets of [ ]. In the first set, the number is 32, which is two digits. Unfortunately, the number can be one, two of three digits. In the [Warehouse] area, the number of characters also differs since the location name [Warehouse] can change. For the third set of [ ], this will always be a 10 character event number and that's what I would like to isolate so I can create a hyperlink to another event. Any thoughts? Thanks!

RE: Extracting data between [ ]

Try:

left(Split({yourFieldName},"[")[3],10)

RE: Extracting data between [ ]

(OP)
Thanks Andy, It did not work, but I changed your [3] to a [4] and the correct result appeared. If you know why the [4] works instead, please let me know.

RE: Extracting data between [ ]

It means I can't count :)

The formula breaks the string into segments based on the '[' character. So the segment that gets you to your substring is the fourth, not the third.

I'm glad you got it working!

-Andy

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close