Get part of a string

[#1]

Hi Everyone,

I have two fields that mean the same from 2 different tables, but are not the same in characters.

The first one is like ODI-1, the second one is like [#ODI-1].

I have tried mid(field, 3, 5) and that works for now. But what do to when we reach [#ODI-10]  until [#ODI-99] or higher?

Or is there maybe another way to connect these fields because they mean the same?

[SunilChauhan]

may be this

subfield(subfield(fieldname,'#',2) ,'-',1)

[#3]

And how about addin [#] to the first table? Don't know how that works. But the first table field only contains abc-1 and so on.

[#4]

Hi Sunil,

That doesn't work. Would be nice if it would though.

[swuehl · Accepted solution]

LOAD

...

'[#' & FIELD & ']' as FIELD,

...

from Table1;

edit: Have you tried the purgechar() ?

[SunilChauhan]

for first table use can use

fieldname  as somename

and in second Table

use this

subfield(fieldname,'#',2)  as somename

hope this helps

[#7]

Thanks swuehl, that worked. Now I have the same fields. Thanks all!