Jump to content

Substring variable length


BobH

Recommended Posts

  • MVP 2023

Yes.

Start by using the "Find Substring" function to the location of the "/" characters.  You may have to call the function a couple of times to find them all - put the separate found locations in separate tags.

image.png.4ce041f6eac4c8d629b6f6c2549346e4.png

Then you can use the "Middle of String" function to extract your data.

I'm not going to post any more here right now because I would like you to try to build this yourself and post your program to see how you're doing.

Joe T.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...