silentwolf
Well-known Member
- Joined
- May 14, 2008
- Messages
- 1,216
- Office Version
- 2016
Hi guys..
So I am not sure how this can be but into a formular so I can get the wanted result on the right above in the table.
On the left side there are more numbers and Letters to the left but they are not consisted or hang on.. there are numbers like FT12345678 or TT12345678910 if the letters change..
and on the RZKTAT2KXXX they are as far as I can recall consistant with 11 charakters..and as you can see there are / slashes at different places..
Idealy I like to add at the last " " "RNR." so it Looks like last cell on the right...
Does anyone of you gurus know how to do that?
This is what I got so far but it is not correct obviously
Many thanks for your input...
[TABLE="width: 1000"]
<tbody>[TR]
[TD]000001093566 / RZKTAT2KXXX / Our Home Furniture Greatthing 1222098[/TD]
[TD]Our Home Furniture Greatthing 1222098[/TD]
[/TR]
[TR]
[TD]000000036459 / RVVGAT2B420 Lovethe Funriture & Home GmbH Coolstuff 1352036[/TD]
[TD]Lovethe Funriture & Home GmbH Coolstuff 1352036[/TD]
[/TR]
[TR]
[TD]000074262159 / Sweetest 5295 13321[/TD]
[TD]Sweetest 5295 13321[/TD]
[/TR]
[TR]
[TD]00300035041300 / Shipping Service Centre GmbH 0634719431[/TD]
[TD]Shipping Service Centre GmbH 0634719431[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]
<tbody>
</tbody>[/TD]
[/TR]
</tbody>[/TABLE]
It is a bit messed up now as I took to long to post the thread so I got loged out .(
Hope it is still ok so..
I need to head of very soon so I will not be able to get back to you to soon.. but I will reply later if anyone as a suggestion
Thanks
So I am not sure how this can be but into a formular so I can get the wanted result on the right above in the table.
On the left side there are more numbers and Letters to the left but they are not consisted or hang on.. there are numbers like FT12345678 or TT12345678910 if the letters change..
and on the RZKTAT2KXXX they are as far as I can recall consistant with 11 charakters..and as you can see there are / slashes at different places..
Idealy I like to add at the last " " "RNR." so it Looks like last cell on the right...
Does anyone of you gurus know how to do that?
This is what I got so far but it is not correct obviously
Code:
Case strText Like "*( 1 UMS)*"
If strText Like "*# / ????AT????? / *" Then
intPos = InStrRev(strText, "/")
StringDelete= Mid(strText, intPos + 2)
ElseIf strText Like "*# / ????AT????? [A-Z]*#" Then
intPos = InStrRev(strText, " ")
StringDelete= Mid(strText, intPos + 2)
Many thanks for your input...
[TABLE="width: 1000"]
<tbody>[TR]
[TD]000001093566 / RZKTAT2KXXX / Our Home Furniture Greatthing 1222098[/TD]
[TD]Our Home Furniture Greatthing 1222098[/TD]
[/TR]
[TR]
[TD]000000036459 / RVVGAT2B420 Lovethe Funriture & Home GmbH Coolstuff 1352036[/TD]
[TD]Lovethe Funriture & Home GmbH Coolstuff 1352036[/TD]
[/TR]
[TR]
[TD]000074262159 / Sweetest 5295 13321[/TD]
[TD]Sweetest 5295 13321[/TD]
[/TR]
[TR]
[TD]00300035041300 / Shipping Service Centre GmbH 0634719431[/TD]
[TD]Shipping Service Centre GmbH 0634719431[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]
Shipping Service Centre GmbH RNR. 0634719431 |
<tbody>
</tbody>
[/TR]
</tbody>[/TABLE]
It is a bit messed up now as I took to long to post the thread so I got loged out .(
Hope it is still ok so..
I need to head of very soon so I will not be able to get back to you to soon.. but I will reply later if anyone as a suggestion
Thanks
Last edited: