String functions

[#1]

How to eliminate only first colon from below string .

: 23 - JUL - 16 06:00 PM

[Chanty4u]

try this

sam:

LOAD * INLINE [

    colon

    : 23 - JUL - 16 06:00 PM

];

LOAD *,

PurgeChar(colon,':') as new

Resident sam;

[Anonymous]

e.g. you can use

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

[avinashelite]

if the : position is always fixed then try like this

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

if its a field

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

[Chanty4u]

orelse

sam:

LOAD * INLINE [

    colon

    : 23 - JUL - 16 06:00 PM

];

LOAD *,

Right(colon,23) as result

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

Resident sam;

[maxgro]

I think you want to remove ': '

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

or

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

[yasmeenk]

Try this,

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

[MarcoWedel]

Mid(string,3)

or

Replace(string,': ','')

hope this helps

regards

Marco

[pk2019]

Hi Snehal,

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

Purgechar(YourDateTimefield, ':')