Remove part of a string

[#1]

Hi

I have a addressfield that include specific apartment-ID. I would like to remove the nr/id in the script.

The addresses can look like this.

Mainstreet 43 D lgh 2005  - remove D lgh 2005

Walkingstreet 9 lgh 105    - remove lgh 105

Littlestreet 10a, lgh 100    - remove a, lgh 100

Main littlestreet 240-10     - remove -10

Littlestreeet 52                  - don´t remove anything

Little mainstreet 12          - don´t remove anything

Hope you understand, I would like to keep the streetname and streetnr

[rustyfishbones]

try this

[rustyfishbones]

PFA qvw that may help

Regards

Alan

[sunilkumarqv]

Make use of somthing like this

subfield(FieldName, ' ', 1) & ' ' & subfield(FieldName, ' ', substringcount(FieldName, ' ')) as FieldName

Hope you get the solution

[alexandros17]

Hi,

use "findoneof(myString, '1234567890')" function to search the first numerical occurrence.

At this point use mid function to extract the substring starting from the first numerical occurrence, take the first n numerical values (you have to check any position in the string - I think no more than 4 digits) and at the end

use left of the original string up to the last numerical position

[Peter_Cammaert]

Still alphabetic residues at the end of some addresses, Alan.

How about this?

SUBFIELD(Address, ' ', 1) & ' ' & KEEPCHAR(SUBFIELD(SUBFIELD(Address, ' ', 2), '-', 1), '0123456789')

[beeaj2011]

Hi

you can use a multiple (preceding loads) usage of subfield see attached qvw

Regards

Ton

Dropbox - split.qvw

[rustyfishbones]

Sorry I missed that.

regards

Alan

[#9]

Please try this:

mid(Address,1,findoneof(Address, '1234567890')-1) & ''& KeepChar(mid(Address,findoneof(Address, '1234567890'),4),'1234567890')

where Address is the Field

Help taken from Alessandro Saccone

Thanks,

Angad

[alexandros17]

Use this script (in a text box for instance ...) where myStr is your string

=If(FindOneOf(myStr,'1234567890')>0,

  If(IsNum(Mid(myStr,FindOneOf(myStr,'1234567890')+1,1)),

  If(IsNum(Mid(myStr,FindOneOf(myStr,'1234567890')+2,1)),

  'keep searching'

  ,Left(myStr,FindOneOf(AAA,'1234567890')+1)

  )

  ,Left(myStr,FindOneOf(myStr,'1234567890'))

  )

  ,myStr

)