Trim everything before a character

[urobee]

Hy,

I have a text looks like:

"abcdef | 123456 | xyz"

I need to show only the last few character after the last " | " character, (delete everything before the last " | " and the pipe character too)
so in this case i need: "xyz" (the number of the characters is different all the time)

Oh, and i need to do this with VBA, not with formula.

Thanks for your help!

 

[urobee]

Sorry, but i have another problem:
The example is the same: "abcdef | 123456 | xyz"
I need to modify the file so i need the text from the middle : "123456"

 

[Haluk]

See this if it helps;

MsgBox Trim(Split(ComboL.Value, "|")(1))

 

[urobee]

See this if it helps;

MsgBox Trim(Split(ComboL.Value, "|")(1))

wow, cool, thanks for your quick help!

 

[Rick Rothstein]

Sorry, but i have another problem:
The example is the same: "abcdef | 123456 | xyz"
I need to modify the file so i need the text from the middle : "123456"

If there are always only three delimited fields, then you would want to use the suggestion Haluk made in Message #9 as s basis...

If you will need all of these in the same procedure, then declare a Variant variable which I'll name Arr for this example, and do something like this...'

Dim FirstField As String
Dim MiddleField As String
Dim LastField As String
Dim Arr As Variant
Arr = Split(ComboL.Value, "|")
FirstField = Trim(Arr(0))
MiddleField = Trim(Arr(1))
LastField = Trim(Arr(2))

If you will only need any one of these without the other two, then you can use the Split function directly...

MiddleField = Split(ComboL.Value, "|")([B][COLOR="#FF0000"]1[/COLOR][/B])

You would use 0 in place of the 1 for the first field and 2 in place of the 1 for the last field.

 

[urobee]

If there are always only three delimited fields, then you would want to use the suggestion Haluk made in Message #9 as s basis...

If you will need all of these in the same procedure, then declare a Variant variable which I'll name Arr for this example, and do something like this...'

Dim FirstField As String
Dim MiddleField As String
Dim LastField As String
Dim Arr As Variant
Arr = Split(ComboL.Value, "|")
FirstField = Trim(Arr(0))
MiddleField = Trim(Arr(1))
LastField = Trim(Arr(2))

If you will only need any one of these without the other two, then you can use the Split function directly...

MiddleField = Split(ComboL.Value, "|")([B][COLOR=#FF0000]1[/COLOR][/B])

You would use 0 in place of the 1 for the first field and 2 in place of the 1 for the last field.

Thanks!

I really like this site, i always learn here a lot!

 

[hiker95]

Thanks!

I really like this site, i always learn here a lot!

urobee,

See if something, in the below link(s), of my most up to date list will help you:

Training / Books / Sites as of 2/3/2018

https://www.mrexcel.com/forum/excel...ere-entries-another-column-2.html#post5001046