Search and find a string

[#1]

Hi All,

I have a requirement to find a string from the data base and represne in a table.

Input data :

Data :

ABC1230

dfg ABC11 th

yur ABC435000 mm

kk ABC76859 ndf ght ii

I need to find the string Which start from ABC.

Expected Output:-

data

ABC1230

ABC11

ABC435000

ABC76859

You help will be highly appriciated

Thanks!
D J

[rustyfishbones]

You could try

KEEPCHAR(data,'ABC0123456789') AS Data

[alexandros17 · Accepted solution]

This is the working expression

If(Index(VAL,'ABC')>0,

  If(Index(Mid(VAL, Index(VAL,'ABC')),' ') > 0,

  Mid(VAL, Index(VAL,'ABC'), Index(Mid(VAL, Index(VAL,'ABC')),' ')),

  If(Index(Mid(VAL, Index(VAL,'ABC')),' ') = 0,

  Mid(VAL, Index(VAL,'ABC')),

  '---'

  )

  )

  ,'---'

)

[rustyfishbones]

Or try

TRIM(PURGECHAR(data,'abcdefghijklmnopqrstuvwxyz')) as [New Data]

[#5]

KeepChar is not working because it will return all the character in that string .

Thanks

D J

[tresesco]

May be like:

Input:

Load SubField(data, ' ')  as NewData From <>;

Output:

Load

          NewData

Resident Input Where WildMatch(NewData, 'ABC*') ;

Drop table Input;

[rustyfishbones]

See attached

[rustyfishbones]

You could also try