topic Re: String functions in QlikView

String functions

Tue, 23 Aug 2016 09:21:54 GMT

How to eliminate only first colon from below string .

: 23 - JUL - 16 06:00 PM

Re: String functions

Chanty4u — Tue, 23 Aug 2016 09:24:27 GMT

try this

sam:

LOAD * INLINE [

colon

: 23 - JUL - 16 06:00 PM

];

LOAD *,

PurgeChar(colon,':') as new

Resident sam;

Re: String functions

Anonymous — Tue, 23 Aug 2016 09:25:31 GMT

e.g. you can use

=mid(': 23 - JUL - 16 06:00 PM',2,len(': 23 - JUL - 16 06:00 PM')-1)

Re: String functions

avinashelite — Tue, 23 Aug 2016 09:29:00 GMT

if the : position is always fixed then try like this

replace('-'&': 23 - JUL - 16 06:00 PM','-:','')

if its a field

replace('-'&field_name,'-:','')

Re: String functions

Chanty4u — Tue, 23 Aug 2016 09:30:04 GMT

orelse

sam:

LOAD * INLINE [

colon

: 23 - JUL - 16 06:00 PM

];

LOAD *,

Right(colon,23) as result

//PurgeChar(colon,':') as new

Resident sam;

Re: String functions

maxgro — Tue, 23 Aug 2016 09:30:30 GMT

I think you want to remove ': '

=right(': 23 - JUL - 16 06:00 PM', len(': 23 - JUL - 16 06:00 PM')-2)

=subfield(': 23 - JUL - 16 06:00 PM', ': ', 2)

Re: String functions

yasmeenk — Tue, 23 Aug 2016 09:40:01 GMT

Try this,

=subfield(': 23 - JUL - 16 06:00 PM', ': ', 2)

Re: String functions

MarcoWedel — Wed, 24 Aug 2016 00:09:56 GMT

Mid(string,3)

Replace(string,': ','')

hope this helps

regards

Marco

Re: String functions

pk2019 — Wed, 24 Aug 2016 00:26:32 GMT

Hi Snehal,

You need to use the following function in Data Load Editor:

Purgechar(YourDateTimefield, ':')