|
| Iniciado por guest, 13,sep. 2016 16:21 - 3 respuestas |
| |
| | | |
|
| |
| Publicado el 13,septiembre 2016 - 16:21 |
Hi . I am stugling with a string. Maybe a stupid quiestion but here it goes
I have a string in this format 1111/20150202
The / is the seperator but can be contained in the string as well
111/11/20150203
so I cannot use left or string extract.
I need to remove the last part with is always a date format yyyymmdd.
If I use right I get that date so that is not good .
I would really appricate some help on this . Thanks
The first part( the part that I need) can be a lot of digits. the part that needs to be removed is always the date format YYYYMMDD
Thanks
Allard |
| |
| |
| | | |
|
| | |
| |
| Publicado el 13,septiembre 2016 - 16:28 |
Hi ,
Solved it . Sorry for asking
regards
Allard |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
34 mensajes |
|
| Publicado el 13,septiembre 2016 - 17:11 |
Hi Allard,
try this:
sInitialString, sCorrectString is string
nStringLenght is int
sInitialString = "111/11/20150203"
nStringLenght = Length(sInitialString) - 8
sCorrectString = Left(sInitialString,nStringLenght) |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
34 mensajes |
|
| Publicado el 13,septiembre 2016 - 17:13 |
Hi Allard,
try this:
sInitialString, sCorrectString is string
nStringLenght is int
sInitialString = "111/11/20150203"
nStringLenght = Length(sInitialString) - 8
sCorrectString = Left(sInitialString,nStringLenght) |
| |
| |
| | | |
|
| | | | |
| | |
|