Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
may be this
subfield(subfield(fieldname,'#',2) ,'-',1)
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.
Hi Sunil,
That doesn't work. Would be nice if it would though.
LOAD
...
'[#' & FIELD & ']' as FIELD,
...
from Table1;
edit: Have you tried the purgechar() ?
for first table use can use
fieldname as somename
and in second Table
use this
subfield(fieldname,'#',2) as somename
hope this helps
Thanks swuehl, that worked. Now I have the same fields. Thanks all!