suggest

[satishqlik]

Hi Community,

I have a string 01#345@78$

How to change the special characters (#,@,$) to 2,6,9 respectvely from the string?

I tried with using replace function but didn't work properly

Any ideas?

[MindaugasBacius]

You can use Replace or MapSubstring functions.

[MindaugasBacius]

=replace(replace(Replace('01#345@78$', '#', 2), '@', 6), '$', 9)

Well Replace works fine.

Result:

[satishqlik]

Thanks but how can we do by using MapSubstring function?

It showing only two parameters map_id and text.

[sunny_talwar]

May be like this:

MappingTable:

Mapping

LOAD * Inline [

From, To

#, 2

@, 6

$, 9

];

FactTable:

LOAD FieldName,

          MapSubString('MappingTable', FieldName) as NewFieldName

FROM Source;

[tamilarasu]

Hi Satish,

Hope you are asking for dynamic expression. If so, try below expression,

=Replace(

    Replace(

       Replace('01#345@78$',

                '#',Mid('01#345@78$',Index('01#345@78$','#')-1,1)+1),

             '@',Mid('01#345@78$',Index('01#345@78$','@')-1,1)+1),

          '$',Mid('01#345@78$',Index('01#345@78$','$')-1,1)+1)

[MindaugasBacius · Accepted solution]

map1:
mapping load * inline [
     #, 2
     @, 6
     $,9
] ;


Data:
LOAD *,
MapSubstring ('map1', F1) as new
INLINE [
    F1
    01#345@78$
];

Result:

See the attachement.

[qlikview979]

Hi Satish,

You can try this

[satishqlik]

Thanks for all your ideas...

[Saravanan_Desingh]

One more version..

Load  Concat(Out,'') As text2;
Load *,
Alt(Mid(text,IterNo(),1)*1,IterNo()-1) As Out
Inline [
text
01#345@78$
]
While IterNo() <= Len(text);

text2 will have 0123456789